We have total 6 Nodes and 3 failover cluster (Each with two node).
Cluster1.TestAD.com
(Node1,Node2) – SQL Failover Instance (SQL1) – 1
TB Shared storageCluster2.TestAD.com
(Node3,Node4) – SQL Failover
Instance (SQL2)- 1 TB Shared storageCluster3.TestAD.com
(Node5,Node6) – SQL Failover Instance (SQL3)- 1 TB Shared storage
Now we want to create availability group setup between above three SQL
instance.
We plan to create new cluster (cluster4.TestAD.com
) with all six node and create Availability groups with all three instance.
SQL Edition : SQL Server 2012 R2 Enterprise
Is it possible? Any other recommendations ?
Best Answer
One of the requirements for AGs is that all instances are participating nodes in the same WSFC. I believe, based on what youa re telling us, is that the 3 instances are, in fact, in 3 separate clusters.
I don't believe that what you are trying to accomplish is possible.