0

Can automatic failover occur to a DR node on a different data center if synchronous commit is enabled and other conditions are right. I'm asking because we had a two node scenario where a primary node was quarantined because of a network issue on the primary site and the AG went into resolving state causing a bit of a lengthy outage. The question is if we had set up the AG to have have automatic failover would it have failed over to the DR on the secondary site i.e not on the same data center?

1
  • I would push back and ask why, specifically, your AG went into the resolving state? Because if it was a simple loss of quorum because the two nodes in the AG are the only voting members, simply adding another voter (whether that be a non-SQL node, file share witness, or shared disk witness) might be a cheaper alternative.
    – Ben Thul
    Jan 3 at 15:44

1 Answer 1

2

Can automatic failover occur to a DR node on a different data center if synchronous commit is enabled and other conditions are right.

The question is if we had set up the AG to have have automatic failover would it have failed over to the DR on the secondary site i.e not on the same data center?

Yes, the AG has no idea what a DR site is, so if it's set to do automatic failover (which requires synchronous commit and be up to date), then it will assuming the cluster survives (that partition has quorum) and no other issues occur (such as hitting the maximum number of failures).

2
  • 1
    Note, that configuring the cluster so the DR side can have quorum has the downside that if your primary datacenter becomes partitioned, it will lose quorum, which you may not want. Jan 6 at 17:57
  • Thanks @Sean Gallardy Mar 11 at 9:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.