HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Distributed Availability groups & Listeners

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
groupslistenersdistributedavailability

Problem

I'm currently doing my first setup with Distributed Availability groups. This is currently a POC setup but will normally be implemented soon. I have 4 nodes, 2 nodes located together and 2 other also together but with some distance between them.

I set up the Distributed AG with the automatic seeding and everything is fine so far. The database got synchronised to the secondary Availability group without any issues.

Now comes the actual question: I have created two listener for my AG's (Primary & Secondary), but I can't create a listener for my Distributed AG (Not much information on it). This poses the problem that my application will have to be Listener aware...

Is there a way to create a listener for the Distributed AG, through which the application will always be able to connect even if we failover the distributed availability group?

Solution

After a call with someone from Microsoft, I was told that there are no listeners on the Distributed availability level yet. So currently if we want to use DAG, you will have to change your DNS or application connection to connect to the secondary availability group.

Context

StackExchange Database Administrators Q#142924, answer score: 5

Revisions (0)

No revisions yet.