Setting up Active-Active Replication between 2 Availability Groups?

Question

I'm familiar with P2P replication in an Active-Active setup and I'm familiar with Availability Groups. I'm now wondering if I can marry the two for better availability.

Current setup is 2 servers in separate locations, using P2P in an Active-Active setup. We route traffic primarily to the servers based on geo location and secondarily to load balance. If a server fails, then all traffic goes to the remaining server.

We are working on the specs to set up new servers. To increase availability while still being able to load balance, I'm trying to figure out if the following is possible: Create an Availability Group in each location, so that a server failure at one location is handled without having to send all traffic to the second location -- possibly allowing read on the secondary replica, but that is not required. We would also still want to replicate data between the 2 locations, in an Active-Active mode.

I've read a variety of articles that discuss bits and pieces of this, but not really anything that seems specific to what I want to do - or maybe I'm not fully understanding some of what I'm reading. Pictures below to show current and desired setups.

Answer 1

Hi SRP-0959,

Welcome to Microsoft Q&A.
Please refer to https://learn.microsoft.com/en-us/sql/relational-databases/replication/transactional/peer-to-peer/multi-availability-group?view=sql-server-ver15 to configure the scenario with two peers - each in its own availability group.

Best Regards,
Amelia

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.