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.
why cannot sql server AG listener with pacemaker on linux redirect to secondary replica with -K readOnly for read scale out?
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