I have 2 nodes (active-passive) with 2017 Standard edition. I need to AG 3 databases. Can I do it with 1 listener or do I really have to have 1 listener per db in Standard edition. I should also mention that the 3 databases rely on each other. It would be very problematic if any one of them failed over without all 3 failing over at the exact same time. Any advice? Safe workarounds?
January 9, 2020 at 2:09 pm
I haven't used Availability Groups in Standard Edition, but the documentation clearly states you can only have a single database in an AG. There may be some coding you can do to work around that limitation, but I'm not sure it would qualify as "safe".
John
January 9, 2020 at 2:30 pm
I should have worded differently. I guess what I'm asking is if there's a way to have more than one AG use the same listener.
I don't think there is. Think about what it would mean: you have three AGs all running on the same node, all with the same listener, which points to that node. One of the AGs then fails over to the second node. Where would the listener point then?
John
January 9, 2020 at 2:42 pm
That makes total sense. I guess thoroughly asking the question sometimes provides the answer 🙂 Thanks
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply