Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-3435

CDC with sqlserver always on failover

    XMLWordPrintable

Details

    • Enhancement
    • Resolution: Not a Bug
    • Major
    • None
    • 1.3.1.Final
    • sqlserver-connector
    • None
    • False
    • False
    • Undefined

    Description

      Hi, i have used debezium sqlserver connetor on sqlserver always on cluster with a few months, there was a problem in the production environment, i opened CDC on primary database, and i set ApplicationIntent=ReadOnly in connector configuration, when failover happen, the primary can be second node, but the CDC didn't change to the new primary node, the connector will fail, is there some methodsĀ  i can handle the failover? Thank you.

      Attachments

        Activity

          People

            Unassigned Unassigned
            katty0924 katty he (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: