November 5, 2008 at 9:39 pm
We are trying to see what will be the best high availability for our database servers along with the load balancing given the following scenario:
We have two db servers one is sql 2005 and the other is sql 2008, we are trying to see which one will be best:
1. Clustering
or
2. Database mirroring: Mirror both sql 2005 and sql 2008 servers to the secondary 2008 server.
And also we are concerned about the load balancing.
Please advice.
November 6, 2008 at 1:44 am
If load balancing is spreading your users over more servers, that's not possible with MSSQL (Buy Oracle RAC in that case, but you'll have to win the lottery first 😉 )
About failover: MSSQL uses the shared-nothing principle, which means 1 server is active, the other server is passive, doing nothing until the active server crashes (some variants are possible, but that's beyond this answer).
About Mirroring: You can't use that database until the original database crashes.
Make sure you know both pros and cons of these concepts; this site is a good start.
Wilfred
The best things in life are the simple things
November 6, 2008 at 4:15 am
As Wilferd suggested, mirroring will be a best option, but this cannot be load balanced, read the link below to get a full idea about mirroring
http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx
Hope this helps 🙂
November 6, 2008 at 4:39 am
As Wilferd suggested, mirroring will be a best option ...
That's not what I mentioned, I don't know your recovery strategy of Service Level Agreements.
Wilfred
The best things in life are the simple things
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply