群集模式下与2个SQL Server的Azure App混合连接 [英] Azure App hybrid connection with 2 SQL Servers in cluster mode

问题描述

我在Azure中有一个应用程序...我想将我的应用程序连接到在内部前提下的群集SQL数据库...我有2个SQL Server ... i

I have an app in Azure...i want to connect my app to a clustered SQL database which in on premise...i have 2 SQL servers...i installed hybrid connector on one...should i install it on the other one...how will the redundancy or fail over work?

推荐答案

对于冗余，每个HCM是可以支持多个混合连接.而且，任何给定的混合连接都可以由多个 HCM.默认行为是在任何给定的端点之间跨已配置的HCM路由流量.如果要从网络上的混合连接中获得高可用性，请在单独的计算机上运行多个HCM.负载分配算法 将流量分配到HCM的中继服务是随机分配.

For redundancy, yes each HCM can support multiple Hybrid Connections. Also, any given Hybrid Connection can be supported by multiple HCMs. The default behavior is to route traffic across the configured HCMs for any given endpoint. If you want high availability on your Hybrid Connections from your network, run multiple HCMs on separate machines. The load distribution algorithm used by the Relay service to distribute traffic to the HCMs is random assignment.

这篇关于群集模式下与2个SQL Server的Azure App混合连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！