Active/Active | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive


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. Thanks,
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