May 23, 2019 at 9:33 am
If you have 4 Availability Groups across 4 nodes in a cluster, do you need to have multiple listeners for this, ie one listener per Availability group.
I maintain that for each AG you need its own listener but the team have been in contact with a Microsoft contact who seems to be saying that in this setup of 4 AG’s across the nodes you don’t need that many listeners (4).
What he is saying don’t seem correct to me but the rest of the team are taking his advice on board in the planning.
May 23, 2019 at 3:15 pm
Every AG I set up had to have it's own listener. Each Listener has its own static IP and Port number defined when it is created. I don't see how else could an AG know which is the active node (or Primary) without one.
May 24, 2019 at 1:04 pm
sysadmins can connect to any database/AG via any listener. Accounts with more restricted permissions cannot. Therefore I'd always set up one listener for each AG. If you don't, and the AGs fail over at different times, you can get some weird things happening.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply