February 8, 2022 at 7:37 pm
Hello, I'm looking for a bit of advice.
We have been using a model of Failover Cluster Instance for high availability at the instance level and non cluster Availability Groups for a reporting replica of a few databases on different servers.
The company wants to virtualize the physical cluster and it was suggested that we switch from FCI to AG with automatic failover and a listener. We came to realize that if we add all of the databases to a Windows cluster AG, we will not be able to add an async replica of a couple of the databases on another server for reporting purposes. AG replicas include all databases.
I was thinking we could have two AGs, one for the databases that need a reporting replica and a second AG for the databases that don't. Problem is there would be two listeners and no guarantee that the AGs would failover together from server to server for HA purposes. I know it doesn't matter where the databases live because the app connects to the listener and therefor would reach the primary regardless which node is hosting it. The app team would need to change the connection string to the listener of the destination database's AG and also cross database queries could be a problem if the databases primaries are on different nodes.
Is there a design option that I'm missing or another way to handle this?
Thanks,
Howard
February 9, 2022 at 1:28 pm
xEvents are your friend !
Have a look in the attached scripts file on how I monitor hand handle failovers ....
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 24, 2022 at 6:36 am
This was removed by the editor as SPAM
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply