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?