SQL 2012 AlwaysOn Availability group Failover settings

We have a 4 node 2012 Sql availability cluster and are hoping someone can verify some settings for me. We have two nodes in our HQ site and two in DR. Tak a look at the attached screen shot but basically my thinking is that HQ node 1 is primary and set to manual failover HQ2 is set to automatic, DR1 is also automatic. So the question is if we have a failure on HQ1 will it fail to HQ2 then to DR1?

Cluster settings
LVL 1
FirstcomAsked:
Who is Participating?
 
PadawanDBAOperational DBACommented:
So the primary replica is configured with manual failover mode.  Which means, if it crashes, it's not going to failover without you failing it over.  HQSQL02 and DRSQL01 create what's referred to as an automatic failover set.  As long as the primary replica is on one of those two nodes, it will automagically failover between the two nodes.  Only one automatic failover set per AG.

Also, you typically don't leverage synchronous commit between datacenters (this is not to say you never do it).  The reason for this is that in most cases the latency between the datacenters is an unacceptable amount of latency for a transaction to have to wait to commit and return control to the app.
0
 
FirstcomAuthor Commented:
That is what i was afraid of. So when you have 4 nodes hosting an AG you are really limited to two possible primary owners from an automatic failover standpoint.
0
 
PadawanDBAOperational DBACommented:
Yessir.  Pertaining to your setup, however, I rarely find a setup where you *want* the failover to a DR site to be automatic, as there are usually many other components that need to move together.  Regardless, to do it the way you are wanting, you would have two AlwaysOn FCIs (one in each datacenter) and then build the availability group on top of those (host the replicas on the FCIs).
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.