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

Include "Always On mode" in SQL Server Connector Test matrix

    XMLWordPrintable

Details

    • False
    • None
    • False

    Description

      One of our major Customers, Poste Italiane (Account id: 1130105)  would like to configure debezium CDC on SQL Server configured in Always On mode.

      A hard requirement of this project is to have automatic failover of a SQL Server database to a standby server in case the primary server becomes unavailable. Therefore, in production environment, they need to enable the "Always On" mode which will basically expose a listener address instead of direct Hostname address to its clients.

      This option does not appear to be tested. There is a mention of it, in the community documentation https://debezium.io/documentation/reference/2.1/connectors/sqlserver.html#sqlserver-always-on-replica.

      Database version: SQL Server 2017 Product: 14.0.3356.20 CU22 

      What Debezium connector do you use and what version?

      2.1.4

      What is the connector configuration?

      connector-config

      Which use case/requirement will be addressed by the proposed feature?

      Use Debezium Connector with SQL Server in HA.

      Attachments

        Activity

          People

            obabec Ondřej Babec
            fmarchio@redhat.com Francesco Marchioni
            Votes:
            1 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: