January 27, 2011 at 9:24 am
I understand that your connection is dedicated between your webserver and your database server. I'm referring to a layer between your client and your webservers.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 27, 2011 at 9:34 am
David , now according to you there are 3 layers . 1) client 2) webserver 3) db
the situation i am trying to describe is that the db layer is down. the web server doesn't know anything abt it. and the client which is before the webserver doesn't know anything abt that either.
so i cant load balance or redirect until i know that there's a problem at the db.how do i know that is what i have been asking from the beginning?
by the way did i ask right - abt the mirror in my previous post?.
January 27, 2011 at 9:50 am
smarttrail (1/27/2011)
may i ask another question. I am not sure if it's foolish ? but is it wise to have a raid mirror db for each of the nodes which are replicated.? is it possible to have a mirror db at all for the replicated nodes?
Yes, you can do what you have above and that would be good for redundancy at the individual sites. At a minimum your database servers should be in a cluster at their remote sites. Having the mirror would be a safe option.
As to the layers, you would need the ability to have the clients routed to an alternate webserver or to take a webserver out of the load balance if the associated database server went down or the link between that webserver and the database server went down. How you monitor the connectivity and the database availability is up to you but the monitoring needs to be in place.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 27, 2011 at 9:55 am
david,thanks a lot for answering in.
January 27, 2011 at 10:02 am
You're welcome. Sorry that I can't answer the initial question more definitively but that is something that you have to come up with a viable solution that will work for you. There are different ways that people implement that type of architecture and some are more costly due to the requirements that they have while others are more manual but don't really cost anything.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Viewing 5 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply