是否可以在两个不同数据中心之间的两个SQL 2016之间配置Always On [英] Is it possible to configure Always On between two SQL 2016 between two different data centers

问题描述

是否可以在两个SQL 2016之间配置Always On 在两个不同的数据中心之间



数据中心1

服务器A ---> SQL独立实例1

服务器B ---> SQL独立实例2



数据中心2

服务器C ---> SQL独立  Instance3

服务器D ---> SQL独立实例4

Is it possible to configure Always On between two SQL 2016  between two different data centers

Data center 1
Server A --->SQL standalone Instance1
Server B --->SQL standalone Instance2

Data center 2
Server C --->SQL standalone  Instance3
Server D --->SQL standalone Instance4

两个子网用于两个数据中心

始终可用这些数据中心之间？ 还有自动故障转移




我们需要创建多少个监听器？



问候，b
$
vignesh

two subnets are used for two data centers
Is Always on possible between these data centers?  and also automatic failover

How many Listener we need to create?

Regards,

vignesh

推荐答案

是的，DR节点需要加入现有集群，你做完了吗？

Yes the DR nodes need to be joined to the existing cluster, have you done it?

但是看一看在分布式可用性组中，在SQL Server 2016中引入 

But take a look at Distributed Availability Groups, that was introduced in SQL Server 2016 

>>>我们需要创建多少个Listener？ 

连接字符串应该指定AG听众 并确保您拥有  MultiSubnetFailover = True

The connection string should specify the AG listener  and make sure you have  MultiSubnetFailover=True

这篇关于是否可以在两个不同数据中心之间的两个SQL 2016之间配置Always On的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！