SQL Server Performance


Discussion in 'SQL Server Clustering' started by gopal, Mar 3, 2004.

  1. gopal Member

    We currently have active/passive clustering and we are planning to test
    active/active clustering. I understand that active/active requires atleast
    2 nodes and each node has an sql instance running on it. Both the nodes are
    totally independent and do not share any data or processing what so ever.
    If one fails it switches over to the other node and now you have 2 Instances
    running on the same node instead of one on each node.

    My question is :

    1. how the data will be insync between the nodes ? If node1 is failed and it
    is not online for couple of days how will it catchup with all the updates
    from Node2.
    2. How is logshipping works on active/active ? If a node becomes unavailable
    and if logshipping is setup from that node, do we need to setup log shipping
    from other node ?
    3. We currently have 15 databases on production server. Do we need to have
    all the databases on both the nodes ?

    I hope someone can help me on these issues.

  2. bradmcgehee New Member

    Active/active clusterin is just two instances of active/passive clustering. Because of this, active/active works identical to active/passive, just on different nodes of the cluster.

    Question 1: The same database is used for both nodes of the cluster, so your example can't occur.
    Question 2: Log shipping should not be used between two facets of an active/active cluster. If you want log shipping, ship to a different physical cluster or server.
    Question 3: No, it won't work that way. Each cluster is completely separate.

    Brad M. McGehee, MVP

Share This Page