Post reply

AOAG w/o Cluster Forced Failover Issue

  • September 24, 2018 at 12:43 pm

    #364207

    Hi all,

    I've set up a readscale AG with 1 primary and 3 secondary read-only replicas (all async). No AD, no cluster.

    Everything seems to work--the read-only replicas update properly as expected and are only slightly behind the primary, as expected.

    When I force a failover with data loss to a secondary replica, it knocks the other replica databases out of replication and I am unable to get them to recognize the new primary replica. After a forced failover the secondaries still have the original primary name listed in the dashboard.

    Is there a way to force the secondaries to recognize a new primary replica?

    Thanks

  • September 24, 2018 at 1:41 pm

    #2006813

    Got it resolved. It seems AOAG doesn't like it when the database username that owns the certificate used by the database mirroring endpoint is different from the associated login name.

    Go figure.

    Thanks

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply