0

I understand that if a failover happens (among any nodes in an AG), then all nodes lose their existing connections.

And I assume that if a primary suspends data movement, that will have no effect on secondaries (just a potential pile of logs).

But suppose the primary node goes down? Or a database is removed from the AG on the primary? Will the secondary replicas keep doing their thing in those scenarios?

1 Answer 1

0

But suppose the primary node goes down? Or a database is removed from the AG on the primary? Will the secondary replicas keep doing their thing in those scenarios?

I believe you are taking about unexpected shutdown or similar scenario where primary server not available in this case first WSFC will see if it is in position to update cluster registry to set the status like not synchronizing if the server shutdown is immediate Registry may not get updated with the state. When primary is down it would not send log blocks to secondary and if secondary is also done redoing and undoing all the log records it will also not do any work but wait for log records to be pulled when primary comes online. But let us say when the primary went down secondary was behind it, primary it will continue its process of replaying the log records to come alike primary.

Or a database is removed from the AG on the primary

Database will NOT be removed from AG unless user does that, so my above statement does not apply to this.

3
  • thanks but my question about "connections" was application client connections -- are application connections to the secondary undisturbed by anything that happens to the primary, except for when a failover happens? Dec 21, 2020 at 17:17
  • @user2180778 Are you connecting to secondary replica via listener or via node name
    – Shanky
    Dec 22, 2020 at 5:41
  • connecting to secondary replica via the AG listener with intent ReadOnly Dec 23, 2020 at 19:37

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.