Is it possible for a node to host multiple cluster in relation to Always On AG

by Edgar Allan Bayron   Last Updated July 24, 2019 05:06 AM

enter image description here

In my example, I have 3 database servers with their own DR servers, own availability group, own clusters. Is it possible to setup another server which can be part of the 3 clusters and be a secondary replica on each of them?



Answers 1


As I understand your requirement to make DR site of the primary cluster. These two options you have.

If you have sufficient network bandwidth that can replicate data from the head office to DR site properly then

  1. You can use the file-share quorum and add DR nodes into the cluster and add the nodes to AG.
  2. Upgrading SQL Server to 2016 will give you an additional advantage of using Distributed Availability Group. It helps to synchronize AG databases across the cluster.

Thanks!

Rajesh Ranjan
Rajesh Ranjan
July 24, 2019 04:40 AM

Related Questions


Always On -Stand Alones

Updated May 08, 2016 08:02 AM

SQL Server error 19456 when adding the listener

Updated December 05, 2018 19:06 PM

Listener Port 1433 for Always on Availability Group

Updated December 19, 2018 20:06 PM

SQL Server 2014 SP2 upgrade on Alwayson + FCI

Updated August 17, 2017 08:06 AM

I'm confused about High Availability/Always On

Updated April 25, 2016 09:02 AM