Is it possible to create FAILOVER CLUSTER A with Node01 (active) and Node02 (passive) and FAILOVER CLUSTER B with the same Node02 (passive) and Node03 (active)?
I realized that SQL Server instances on passive nodes are not charged, only the OS. So sharing a node for more than one passive Sql-Instance would make sense here. I know, once cluster A and cluster B have an issue I am nipped...
But is this an allowed and/or common scenario?
1 Answer 1
Is it possible to create FAILOVER CLUSTER A with Node01 (active) and Node02 (passive) and FAILOVER CLUSTER B with the same Node02 (passive) and Node03 (active)?
No you cannot. This is enforced by Windows Server Failover Clustering.
I realized that SQL Server instances on passive nodes are not charged, only the OS. So sharing a node for more than one passive Sql-Instance would make sense here. I know, once cluster A and cluster B have an issue I am nipped...
There is nothing stopping you from creating a 3-node cluster (all nodes in the same cluster) and installing two SQL Server FCIs. You'll get roughly the same results.
-
Isn't SQL Server (2016) Standard Edition stopping me from creating a 3-node cluster?Magier– Magier2016年12月19日 09:48:12 +00:00Commented Dec 19, 2016 at 9:48
-
1Standard edition is stopping you form having 3 nodes for the same instance. It says nothing about having more than one instance in a cluster. If you have three nodes and an instance on N1 and N2 and another instance on N3 and N2 you're not violating anything.Sean Gallardy– Sean Gallardy2016年12月19日 13:29:43 +00:00Commented Dec 19, 2016 at 13:29
Explore related questions
See similar questions with these tags.