July 30, 2014 at 7:23 am
Trying to get my head around a scenario
I have 2, 2 node clusters
PROD1(cluster 1) Clustered SQL instance1
PROD2(cluster 1)
DR 1 (cluster 2) Clustered SQL insatace 2
DR 2 (cluster 2)
I have set an availability group up from the PROD instance to the DR instance.
How does the AG behave if a SQL instance fails at PROD? Does it try to fail over to Node 2 on Prod before going over to DR? or bring the Replica at DR online straight away? Can we only use Manual Failover of the AG in this scenario to make use of the High Availability of the Windows cluster?
July 30, 2014 at 7:51 am
The AG would react to however you have the failover mode set for the replica. I would think you want it set to Asynchronous-commit, this would require manual failover.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
July 30, 2014 at 8:10 am
SQLSteve (7/30/2014)
Trying to get my head around a scenarioI have 2, 2 node clusters
PROD1(cluster 1) Clustered SQL instance1
PROD2(cluster 1)
DR 1 (cluster 2) Clustered SQL insatace 2
DR 2 (cluster 2)
I have set an availability group up from the PROD instance to the DR instance.
How does the AG behave if a SQL instance fails at PROD? Does it try to fail over to Node 2 on Prod before going over to DR? or bring the Replica at DR online straight away? Can we only use Manual Failover of the AG in this scenario to make use of the High Availability of the Windows cluster?
It won't failover to DR, the scenario you are using is not supported except for migration purposes.
All nodes must be part of the same windows cluster otherwise the AlwaysOn group cluster role cannot be failed over.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 30, 2014 at 8:41 am
Perry Whittle (7/30/2014)
SQLSteve (7/30/2014)
Trying to get my head around a scenarioI have 2, 2 node clusters
PROD1(cluster 1) Clustered SQL instance1
PROD2(cluster 1)
DR 1 (cluster 2) Clustered SQL insatace 2
DR 2 (cluster 2)
I have set an availability group up from the PROD instance to the DR instance.
How does the AG behave if a SQL instance fails at PROD? Does it try to fail over to Node 2 on Prod before going over to DR? or bring the Replica at DR online straight away? Can we only use Manual Failover of the AG in this scenario to make use of the High Availability of the Windows cluster?
It won't failover to DR, the scenario you are using is not supported except for migration purposes.
All nodes must be part of the same windows cluster otherwise the AlwaysOn group cluster role cannot be failed over.
Perry,
Thanks,
http://msdn.microsoft.com/en-us/library/jj215886.aspx
I just came across the above document which illustrates how to achieve a geo-cluster shared storage.
Thanks for the fast answers!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply