question

Therealist avatar image
Therealist asked

How Active-Active cluster is different from Active-Passive?

How Active-Active cluster is different from Active-Passive? The goal of clustering is ensuring one server is up and working when other server goes down so that whatever the jobs or services running on one server will be failover to other server which is up, so why do we need Active-Active cluster, i mean in what scenarios we could use Active-Active and when is it better to use Active-Passive, How the things work at the back end when we configure these two types of clusters.
clustering
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
KenJ avatar image
KenJ answered
The intent behind the terms is to communicate the number of nodes and instances in a failover cluster. * Active-Passive is used to denote a 2-node, single-instance, failover cluster. * Active-Active is typically used to denote a 2-node, 2-instance, failover cluster where each node runs an instance. Active-Active is also used to describe a 2-node, 8-instance, failover cluster or any other combination of instances that run on both nodes of a 2-node failover cluster. People still call it Active-Active when all of the instances fail to a single node and the remaining node becomes "passive" (though, if this is done intentionally, it is commonly referred to as Active-Passive again). Of course, no discussion of Active-Active/Active-Passive is complete without a reference to Allan Hirt's classic 2012 rant on the subject - [ http://sqlha.com/2012/01/09/once-more-with-feeling-stop-using-activepassive-and-activeactive/][1]. [1]: http://sqlha.com/2012/01/09/once-more-with-feeling-stop-using-activepassive-and-activeactive/
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.