I'm going to deploy SQL server distributed availability groups with SQL server 2017.
From the documentation, I understand that we can have listeners for primary AG and secondary AG.
The application now talking to primary AG listener. But after the failover, what will happen?
Will it use the primary AG listener name? How my applications know the new SQL server?