AAG with multiple network interface

sakuraime 2,341 Reputation points
2020-09-18T07:37:23.253+00:00

suppose I am having a AAG , 2 node, and a separate network for AAG end point. so another network is for public , AG listener. And two replica are in sync mode
whenever there is interface problem on public (ag listener interface, like the interface is disable) , the AG is not able to failover , given that just before the interface is disable, the database are in sync state. I found in the cluster log , it said the database are out sync .
25700-capturejoin.jpg

So in the failover cluster, it is checked both network can perform heartbeat.
25757-capturejoin-both-heartbeart.jpg

If I change only one interface can perform heartbeat, i did the same test, and the AG IS ABLE TO FAILOVER AUTOMATICALLY , why is that
25781-capturejoin-both-noheartbeart.jpg

SQL Server Other
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Shashank Singh 6,251 Reputation points
    2020-09-18T08:52:56.857+00:00

    You have to show the complete cluster log to tell you why this has happened. There must be something which stopped automatic failover.

    My assumption is since private network was online and running cluster nodes were still able to communicate and hence there was no failover. In latter case you removed both cluster and client communication from network 2 and disabled network 1 so there was no communication at all and hence cluster initiated failover.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.