Question!!

  • 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.

  • 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

  • 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 🙂

  • 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