SQL AlwaysON和负载均衡器 [英] SQL AlwaysON & Load Balancers

问题描述

在线阅读文章之后，我仍然不清楚我们是否需要为SQL Always ON创建两个负载均衡器?

After reading articles online, it is still not clear to me whether do we need to create TWO Load Balancers for SQL Always ON?

对于2个节点，SQL Always Windows故障转移群集的ON可用性组.
> sqlAvailabilitySet集具有以下VM:  SQL 1，SQL 2& SQL见证.

For a 2 nodes SQL Always  ON Availability Group with Windows Failover Cluster.
> The sqlAvailabilitySet set has these VMs: SQL 1, SQL 2 & the SQL Witness.

我们是否需要创建两个内部负载均衡器:
1.侦听器的基本内部负载平衡器，前端IP :(侦听器IP)；健康状况探针TCP 59999;负载平衡规则:TCP 1443，还有一个

Do we need to create two Internal Load Balancers:
1. Basic Internal Load Balancer for the Listener, Front End IP: (Listener IP); Health Probe TCP 59999; Load Balancing Rule: TCP 1443 and also a

2. Windows故障转移群集的基本内部负载平衡器:(故障转移群集IP)；健康状况探针TCP 58888;负载平衡规则:TCP 1443

2. Basic Internal Load Balancer for Windows Failover Cluster: (Failover Cluster IP); Health Probe TCP 58888; Load Balancing Rule: TCP 1443

请照亮一些灯光.谢谢

推荐答案

您需要一个负载均衡器(侦听器)

You need a single load balancer (the listener)

https ://docs.microsoft.com/zh-CN/azure/virtual-machines/windows/sql/virtual-machines-windows-portal-sql-alwayson-int-listener

请勿将VM用作SQL见证-而是实施Cloud Witness

Do not use a VM as the SQL Witness - instead implement Cloud Witness

https://docs.microsoft.com/zh-CN /windows-server/failover-clustering/deploy-cloud-witness

hth
Marcin

hth
Marcin

这篇关于SQL AlwaysON和负载均衡器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！