Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Wednesday, October 4, 2017 1:18 PM
On of our customers only has SQL Server 2016 Standard licenses. He wants to use Always On for redundancy purposes. We have to implement it.
I'm aware of the limitations of Basic Availability Groups (f.e. support for only one availability database in one group). Question for me is now, can we use the same Always On Group Listener address for multiple Basic Availability Groups? This aspect is not answered in the Microsoft documents found online.
Wednesday, October 4, 2017 3:24 PM ✅Answered
. Question for me is now, can we use the same Always On Group Listener address for multiple Basic Availability Groups? This aspect is not answered in the Microsoft documents found online.
This is doable and should work fine if all the BAG's are on same node. You have to choose BAG which is of utmost important and configure listener as per this. The problem would arise when you would failover manually any one of them in that case listener would not work. I would suggest to try to avoid such scenario its is bit cumbersome to maintain. You have to have a script running to check on which node the BAG for which listener is configured is running any make sure all other BAG are on that node.
Cheers,
Shashank
Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it
Wednesday, October 4, 2017 2:09 PM
Technically, the listener name you create for a Basic Availability Group will always point to the primary replica. So, even if you create just one listener name, client applications will get redirected to the primary where all of the Availability Groups are hosted.
In almost all cases, the cluster will move all of the Basic Availability Groups together when a failover occurs. That's the nature of failover clustering. However, there will be rare cases where one Basic Availability Group might end up in a different replica than the rest, for example, initiating a manual failover. When this happens, you need to define a process on how to keep all of the Basic Availability Groups running on the same replica. And, you certainly don't want to be violating your licensing agreement when this happens.
Edwin M Sarmiento Microsoft Data Platform MVP | Microsoft Certified Master/Solutions Master
Blog | Twitter | LinkedIn
Learn SQL Server High Availability and Disaster Recovery
Thursday, October 5, 2017 6:18 AM
. Question for me is now, can we use the same Always On Group Listener address for multiple Basic Availability Groups? This aspect is not answered in the Microsoft documents found online.
This is doable and should work fine if all the BAG's are on same node. You have to choose BAG which is of utmost important and configure listener as per this. The problem would arise when you would failover manually any one of them in that case listener would not work. I would suggest to try to avoid such scenario its is bit cumbersome to maintain. You have to have a script running to check on which node the BAG for which listener is configured is running any make sure all other BAG are on that node.
Thx for clarifying. When setting up this scenario, can I configure Always-On, that all BAGs have to be on the same node? In other words, does Always-On with the proper configuration accomplishes it for me?
Thursday, October 5, 2017 6:28 AM
Thx for clarifying. When setting up this scenario, can I configure Always-On, that all BAGs have to be on the same node? In other words, does Always-On with the proper configuration accomplishes it for me?
If you want to use listener to connect to primary replica for applications they have to be on same node otherwise it would not work. This is more administrative thing than proper configuration, you have to make sure that all BAG's are on same node
Cheers,
Shashank
Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it