sql server alwayson 可用性组 只读路由的设置

 昨天晚上学习了【SQL Server 2012实施与管理实战指南】的第三章，于是今天想在前段时间建的那个alwayson

可用性组测试环境上也配置一下只读路由，尝试实现读写分离。

按照书中的方法，执行如下脚本（本来我是3节点的可用性组，由于笔记本开4台虚拟机实在是太卡，我把server03给关掉了，只读路由也没配置这个节点。）：

--指定在此可用性副本当前拥有辅助角色（即它是辅助副本）时要生效的角色有设置：ALTER AVAILABILITY GROUP [AG01]MODIFY REPLICA ONN'SERVER02\ISS' WITH(SECONDARY_ROLE (ALLOW_CONNECTIONS = READ_ONLY));ALTER AVAILABILITY GROUP [AG01]MODIFY REPLICA ONN'SERVER02\ISS' WITH(SECONDARY_ROLE (READ_ONLY_ROUTING_URL = N'TCP://SERVER02.testad.com:1433'))ALTER AVAILABILITY GROUP [AG01]MODIFY REPLICA ONN'SERVER04\ISS' WITH(SECONDARY_ROLE (ALLOW_CONNECTIONS = READ_ONLY));ALTER AVAILABILITY GROUP [AG01]MODIFY REPLICA ONN'SERVER04\ISS' WITH(SECONDARY_ROLE (READ_ONLY_ROUTING_URL = N'TCP://SERVER04.testad.com:1433'))--指定在此可用性副本当前拥有主角色（即它是主副本）时要生效的角色有设置：ALTER AVAILABILITY GROUP [AG01]MODIFY REPLICA ONN'SERVER04\ISS' WITH(PRIMARY_ROLE (READ_ONLY_ROUTING_LIST = (N'SERVER02\ISS',N'SERVER04\ISS')));ALTER AVAILABILITY GROUP [AG01]MODIFY REPLICA ONN'SERVER02\ISS' WITH(PRIMARY_ROLE (READ_ONLY_ROUTING_LIST = (N'SERVER04\ISS',N'SERVER02\ISS')));

海外公司注册、海外银行开户、跨境平台代入驻、VAT、EPR等知识和在线办理：https://www.xlkjsw.com

原标题：sql server alwayson 可用性组 只读路由的设置

关键词：sql