Active Active SQL 2008 cluster

Posted on 2009-04-30
Last Modified: 2012-05-06
has anyone set one of these up?
Can I get a general outline?
I suspect it is something like this, but would like some confirmation;
setup MSCS Cluster and test working correctly
install failover cluster sql2008 on first node. (I should now have a Active Passive cluster)
(do I need to use a differant shared disk for 2nd active? second IP?)
install sql2008 failover cluster on second node.

any input here would be much appreciated.
Question by:loftyworm
    LVL 13

    Expert Comment

    Just wondering why you want A/A when most people see a two-node as A/P ?

    In essence you're correct; but when you install SQL2008 for the first time; you need to give it an instance name; not the default.

    You would need 2nd shared disk, names, IP's etc.

    LVL 38

    Expert Comment

    by:Jim P.
    Good quick primer:
    Getting Started with SQL Server 2008 Failover Clustering

    Technically there is no such thing as Active/Active SQL. A named SQL instance can only be active on one node at a time. You can have multiple instances running on the cluster, but each will be holding its own distinct set of databases.

    Each distinct instance will need a separate drive, IP, and network name.

    You should have a default instance though. some applications can't handle the MyServer\MyInstance naming for SQL.
    LVL 11

    Author Comment

    I am choosing an A/A because I want to do a bit of load balancing and prep for  patching.  We have 25+ DB's we will put on it, and I do not want to bring them all down for a patch.  So I figure I will have an A/A.

    So it should be like this then?
    ClusterName------Node1----SQLClusterName1---IP1,disk1,networkname1---Default instance
     ClusterName------Node2----SQLClusterName2---IP2,disk2,networkname2---Second instance
    This should allow me to take one of the nodes down for patching/maintenance and not effect the clients, correct?

    and clients will connect to ClusterName/Instance, or networkname#/instance?
    LVL 11

    Author Comment

    DB load is design so it can be handled by 1 node with little impact on performance.
    LVL 38

    Accepted Solution

    >> I am choosing an A/A because I want to do a bit of load
    >> balancing and prep for  patching.

    That won't help for patching.

    When you install a new instance you have to do it from the inactive node. When you install a patch it has to be done from the active node and the other node has to have all instances inactive. You would have to flop all the instances to one node.

    The load balancing would probably help -- split the databases between two instances.

    >> and clients will connect to ClusterName/Instance, or networkname#/instance?

    The default instance will still be just NetworkName. The other would be NetworkName\InstanceName
    LVL 38

    Expert Comment

    by:Jim P.
    Can I ask why a B grade?

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    Some time ago I faced the need to use a uniform folder structure that spanned across numerous sites of an enterprise to be used as a common repository for the Software packages of the Configuration Manager 2007 infrastructure. Because the procedu…
    Know what services you can and cannot, should and should not combine on your server.
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now