Share via

Does SQL Server Distributed Availability Group support an Active/Active Configuration

Rehan Razak 5 Reputation points
2023-02-05T21:55:38.08+00:00

A-A-DAG-Arch

In total there would be 4 participating nodes and 2 instances. Node 1 will be the primary node for instance 1 and Node 2 will be the primary node for instance 2. Likewise global primary and the forwarded will change as well for the instances and its respecting AGs being built. Is such a configuration possible or are there any limitations preventing such a construct to be built? Any suggestion/help would be appreciated. Have put up a rough arch. diagram on what is being planned for.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,364 questions

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Rehan Razak 5 Reputation points
    2023-06-12T12:10:43.9733333+00:00

    Have successfully created the Dist. AVG across the data centers.

    There's been a change in architecture from my initial description; instead of multiple instances, we have multiple AVG. The production environment at Data Center 1 (DC1) has two AVGs configured with two listeners. That is, NODE_1 is primary for AVG_1 with LIST_1, and NODE_2 is primary for AVG_2 with LIST_2. DR requirements specify that the same environment be created at DC2 and that the databases sync across DCs.

    In the DR environment, we created a 2-node AlwaysOn AG and configured two AVGs (AVG_3 and AVG_4). Then we created two distributed availability groups connecting AVG_1 to AVG_3 and AVG_2 to AVG_4.

    1 person found this answer helpful.
  2. LiHongMSFT-4306 25,651 Reputation points
    2023-02-07T09:04:00.23+00:00

    Hi @Rehan Razak

    Please refer to this article introducing configuration of SQL Server AlwaysOn High availability Group for two nodes. Configuring a SQL Server AlwaysOn High Availability Group.

    Also, the number of nodes in the availability group will depend on customer requirements, as will the name of the nodes and listener. When creating the database during the installation process you will point to the address of the group listener.

    See: Active/Active Deployment Model.

    Best regards,

    Cosmog Hong

    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.

  3. Erland Sommarskog 107.2K Reputation points
    2023-02-08T22:35:45.6666667+00:00

    What exactly do you have in mind? Your description is somewhat abstract.

    But if the idea is that if the same logical database should be active at both nodes, the answer is no. Only one database can be writable at a time.

    Or is the idea is that database A is located on data centre X with two replicas, and data centre Y you have the other part of the DAG for database A. And then you have database B which has its primary in data centre Y, and then there is a DAG where the other end is X, and these two DAGs are on the same set of machines? I don't know for certain, but I seem to recall that there is a restriction that you can only have one DAG on the same machine. So, nor not would that work out.

  4. Edwin M Sarmiento 256 Reputation points
    2023-02-11T19:27:53.2266667+00:00

    Does SQL Server Distributed Availability Group support an Active/Active Configuration

    What is your ultimate goal?