question

DaRealMudau avatar image
DaRealMudau asked

AlwaysOn Availability Groups Failover: 2 node cluster in multisite clustering failover without wintess

We have setup a 2 node cluster with a multisite configuration of AlwaysOn to DR site using SQL Server 2014.

The DR site has only one node of SQL hosting 3 SQL instances and 3 Availability groups respectively.

We are in a process of setting up File_Share dynamic quorum which will be hosted at the same site as the primary replicas.

Ideally we would have like to host the file_share quorum in a 3rd location but we do not have luxury of such.

How best can we setup this topology to ensure that when both primary replicas are unreachable Failover still succeeds to DR node?

In a real world situation, if the network line between DR and Production is dropped, how can we have the failover working at DR without the quorum reachable?

alwayson
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.