0

We currently have a 4 Node cluster used for our Availability Groups. 2 nodes in local data center and 2 nodes in remote data center.

Currently the 2 nodes local are Synchronous and the 2 remote nodes are ASynchronous.

They are setup in a multi-subnet network.

We are wanting to make one of the remote nodes Synchronous so that we can manually failover to the remote data center to run production traffic.

Our testing turned up a network issue that we did not think about.

We use DNS aliases to connect to the listener. (ex. product.company.com) that resolves to the primary through the listener IP address. When we failover manually to the remote node the listener IP stays in the local subnet IP.

My question is how can we configure our DNS Alias to automatically resolve to the remote listener to hit the remote as primary with either CNAME or other DNS options.

Below is a crude diagram I tried to work up.

enter image description here

3
  • Did you configure the AG listener with two IP addresses, one for each subnet? And set RegisterAllIPs to 1 in the WSFC, as well as use the MultiSubnetFailover flag in the client connection string? – Nic Jul 20 '17 at 19:31
  • Yes, we have two IP's on the listener. One in each subnet. We have not messed with the RegisterAll setting on this cluster. The apps that can utilize the multisubnet flag do use it. – user761786 Jul 20 '17 at 19:54
  • Adjust the register all, and that should resolve your problem (provided that you're using the multisubnet flag) – Nic Jul 21 '17 at 13:42
0

how can we configure our DNS Alias to automatically resolve to the remote listener to hit the remote as primary with either CNAME or other DNS options

So you don't want to configure applications to connect to the AG Listener's Hostname?

If you use a CNAME pointing to the Listener hostname, it should always return both IP addresses, and clients will handle picking between the IP addresses.

0

Have you considered using Distributed AGs. That could be a solution to failing over, however both, but connecting to the correct primary, will be handled by the client.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.