Post reply

Question regarding Always On AG's

  • July 19, 2019 at 2:07 pm

    #3664539

    Setup:

    I have two Win Failover clusters with SQL 2016 Ent. (ServerA, ServerB) and (ServerC, ServerD).

    Problem:

    I need to replicate a db from ServerA to ServerC in as close to realtime as possible.

     

    I believe the only option I have is replication thru a Publisher/Distributor/Subscription model since I can't use Always On AG because the servers are already in failover clusters. Am I correct?

    Thanks for your time,

    Alonzo

  • July 20, 2019 at 2:10 pm

    #3664754

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • July 22, 2019 at 5:01 pm

    #3665152

    You can create a single-database AG in each cluster (Primary only, no secondaries) and the create an AG on top of that between the two clusters. The 'AG-of-AGs' is called a Distributed Availability Group. This feature allows you create an AG using SQL instances on different clusters.

    MS doc: https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/distributed-availability-groups?view=sql-server-2017

     

     

    Eddie Wuerch
    MCM: SQL

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply