Timeline for How do you configure a 4-node AlwaysOn cluster to have two listeners?
Current License: CC BY-SA 4.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 16, 2020 at 16:30 | comment | added | David Browne - Microsoft | It would depend on what the goal of having multiple listeners is. In the normal configuration the listeners always point to the primary. See learn.microsoft.com/en-us/sql/database-engine/… | |
| May 15, 2020 at 3:28 | comment | added | Chinesinho | Thanks David for the detailed response. I know you said it's unusual to have two listeners in the same AG; however, if it is insisted to be done, how do I do it? Basically, would like AG_Listener1 point to servers A & B with synchronous commit and auto failover. AG_Listener2 point to servers C & D with async commit (manual failover) between them and A & B. Did I just make things more convoluted? Hope not. | |
| May 14, 2020 at 22:28 | history | answered | David Browne - Microsoft | CC BY-SA 4.0 |