locked
Distributed availability group RRS feed

  • Question

  • I have created distirbuted AG between Windows server 2012R2 datacenter (AG name- AG12) and Windows Server 2019 Datacenter (AG name-AG56). Each AG has its load balancer so I have created 4 load balancer rule - 2 for AG12, 2 for AG56, one of them is for listener port another one is for endpoint( 5022). But second AG status is not_healthy and any database doesn't appear in secondg AG primary node when I add database to first AG. Please help me how I configure this architecture? Should I run another script?


    Tuesday, September 8, 2020 11:08 AM

All replies

  • I have used the following scripts:

    First AG primary node:CREATE AVAILABILITY GROUP [distributedag]

    WITH (DISTRIBUTED) AVAILABILITY GROUP ON 'ag12' WITH ( LISTENER_URL = 'tcp://lst12.TESTDOMAIN.COM:5022', AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT, FAILOVER_MODE = MANUAL, SEEDING_MODE = AUTOMATIC ), 'ag56' WITH ( LISTENER_URL = 'tcp://lst56.TESTDOMAIN.COM:5022', AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT, FAILOVER_MODE = MANUAL, SEEDING_MODE = AUTOMATIC ); ALTER AVAILABILITY GROUP [distributedag] MODIFY AVAILABILITY GROUP ON 'ag56' WITH ( SEEDING_MODE = MANUAL );

    Second AG primary node:

    ALTER AVAILABILITY GROUP [distributedag]   
       JOIN   
       AVAILABILITY GROUP ON  
          'ag12' WITH    
          (   
             LISTENER_URL = 'tcp://lst12.TESTDOMAIN.COM:5022',    
             AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT,   
             FAILOVER_MODE = MANUAL,   
             SEEDING_MODE = AUTOMATIC   
          ),   
          'ag56' WITH    
          (   
             LISTENER_URL = 'tcp://lst56.TESTDOMAIN.COM:5022',   
             AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT,   
             FAILOVER_MODE = MANUAL,   
             SEEDING_MODE = AUTOMATIC   
          );    

        


    Tuesday, September 8, 2020 11:10 AM
  • And one of load balancing rule is as follows:


    Tuesday, September 8, 2020 11:11 AM