Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Question!! Expand / Collapse
Author
Message
Posted Wednesday, November 5, 2008 9:39 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 16, 2013 2:48 PM
Points: 262, Visits: 1,503
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.
Post #597873
Posted Thursday, November 6, 2008 1:44 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 6:01 AM
Points: 930, Visits: 1,131
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
Post #597942
Posted Thursday, November 6, 2008 4:15 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, August 11, 2014 9:44 AM
Points: 770, Visits: 1,597
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 :)
Post #597995
Posted Thursday, November 6, 2008 4:39 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 6:01 AM
Points: 930, Visits: 1,131

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
Post #598004
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse