I'm looking at AlwaysOn availability groups. The more I look at it the more it appears that the availability listener group is a single point of failure. Where exactly does the listener actually run? A separate a server, the primary SQL server, all of them?
Say I have a whole application stack at my second data center. How do I configure the listener(s) such that they will be running at both sites and that the applications will point to their own local copies?
I'm sure I'm missing something here but I don't know what.
Best Answer
The AG listener is a virtual network name (VNN) or virtual IP (VIP).
You point applications to the listener (which is registered with DNS) and directs traffic in the AG. So, unless all your DCs go down at the same time, your redundancy is the number of DCs/DNS servers.
This MSDN article (which i quoted from) should be a good starting point for what, exactly, an AG Listener is.
https://msdn.microsoft.com/en-us/library/hh213417.aspx