I have environment, where is one cluster with 2 nodes. In every node there are 4 Availability group each with one database and its own listener.
AG A - DB A - Listener A
AG B - DB B - Listener B
AG C - DB C - Listener C
Application uses Listener A.
There is situation where application needs to read view, that combines data from database A and database B. But database A has listener A and database B has listener B. So if application uses listener A, there can be situation where database B will be on different node as database A. And view will not work.
What is best solution for this situation?
- Group database A and B under one Availability group and one listener?
- Create second listener that will be same for database A and B?
- Keep databases on the same node? - this is really bad idea I believe.