sql 2016中的基本可用性组自动故障转移 [英] basic availability group auto failover in sql 2016

问题描述

我已经设置了一个测试环境，其中包括2 win 2012 r2 std和2 sql 2016 std with cluster和  basic availability group with 1 listener and 2 可用性组，每个可用性组在其中具有不同的数据库.i重定向客户端以将
连接到侦听器并禁用主要可用性组中的网卡，发生故障转移并且两个数据库都处于活动状态并在从属设备中运行服务器（现在他成为主要的），这是非常好的，但根据这篇文章  https://blogs.technet.microsoft.com/msftpietervanhove/2017/03/14/top-5-questions-about-basic-availability-groups/

i've setup a test environment with 2 win 2012 r2 std and 2 sql 2016 std with cluster and basic availability group with 1 listener and 2 availability group that every availability group has different database in it.i redirect the client to connect to the listener and disable the network card in the primary availability group a failover is occur and both database are active and function in the slave server (now he become the primary) which is very good but according to this article https://blogs.technet.microsoft.com/msftpietervanhove/2017/03/14/top-5-questions-about-basic-availability-groups/

在第6节中，它不适用于第二个可用性组自动化cally故障转移。

in section 6 it shouldn't work for the second availability group to automatically failover.

所以我的问题是在我的生产中创建这个基本的可用性组之前 - 它是否应该自动进行故障转移，就像它在我的测试环境中有效一样，或者它不应该？

so my question is before i make this basic availability group in my production - should it failover automatically like it is works in my test environment or it shouldn't?

THX

推荐答案

Hi Avi，

Hi Avi,

我在这里有点困惑，因为第6节谈到为多个基本可用性组共享一个监听器IP而你的问题是关于自动故障转移？  

I'm a bit confused here as section 6 talks about sharing a listener IP for multiple basic availability groups and your question is about automatic failover?  

Basic AV群组确实支持自动故障转移，所以这是支持的。

Basic AV Groups do support automatic failover and so this is something that is supported.

如果我误解了，请告诉我？

Please let me know if I have misunderstood?

谢谢，

马特

这篇关于sql 2016中的基本可用性组自动故障转移的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！