Share via

why cannot sql server AG listener with pacemaker on linux redirect to secondary replica with -K readOnly for read scale out?

麗君 劉 1 Reputation point
2022-08-16T06:08:59.917+00:00

sql server version=15.0.4236.7-1.x86_64
MSSQL_PID=Developer
Create AG group command

CREATE availability GROUP [AG] WITH (cluster_type = EXTERNAL) FOR DATABASE [SQLAG] replica ON N'node1' WITH ( endpoint_url = N'TCP://node1:5022', failover_mode = EXTERNAL, availability_mode = synchronous_commit, seeding_mode = automatic, primary_role (allow_connections = read_write, read_only_routing_list = (('node2', 'node3')),read_write_routing_url = 'TCP://172.30.110.32:1433' ), secondary_role (allow_connections = ALL, read_only_routing_url = N'TCP://172.30.110.32:1433')), N'node2' WITH ( endpoint_url = N'TCP://node2:5022', failover_mode = EXTERNAL, seeding_mode = automatic, availability_mode = synchronous_commit, primary_role (allow_connections = read_write, read_only_routing_list = (('node1', 'node3')),read_write_routing_url = 'TCP://172.30.110.33:1433' ), secondary_role (allow_connections = ALL, read_only_routing_url = N'TCP://172.30.110.33:1433')), N'node3' WITH ( endpoint_url = N'TCP://node3:5022', failover_mode = EXTERNAL, seeding_mode = automatic, availability_mode = synchronous_commit, primary_role (allow_connections = read_write, read_only_routing_list = (('node1', 'node2')),read_write_routing_url = 'TCP://172.30.110.31:1433' ), secondary_role (allow_connections = ALL, read_only_routing_url = N'TCP://172.30.110.31:1433'));

AG Listener command
ALTER AVAILABILITY GROUP [K8sAG] ADD LISTENER N'sqllistener' ( WITH IP ((N'172.30.110.182', N'255.255.255.0')), PORT=1433);

set REQUIRED_SYNCHRONIZED_SECONDARIES_TO_COMMIT= 0 or 1

Microsoft 365 and Office | Skype for Business | Linux
Microsoft 365 and Office | Skype for Business | Linux

A Microsoft communications service that provides communications capabilities across presence, instant messaging, audio/video calling, and an online meeting experience that includes audio, video, and web conferencing.

0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.