October 17, 2024 at 10:52 am
currently we have 3 node AAG with only one listener (one primary one secondary read only node and 1 DR node) . We want to add one more read only node to the AG group.
I have gone through many articles and as per my understanding when we have 2 read-only nodes by default the requests will go in round robin method . which means 1st request will go to node 2 and second request will go to node 3 and so on.
My requirement is for the new upcoming application is we want to redirect the all traffic to particular node only instead of distributing the load in load balancing manner on all read only nodes.
the version of SQL is SQL 2022 with latest CU.
October 17, 2024 at 8:22 pm
You can configure Read-only Routing URL and Read-only Routing List listing the servers in order.
E.g. If node 1 is primary. then the read-only routing list can be set up as
server3,server2, server4 etc..
Are all the AAG nodes in same subnet or multi subnet??
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply