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

GTID set is not properly initialized after DB failover

    XMLWordPrintable

    Details

      Description

      Let's suppose there are two MySQL databases in master/master setup with HA proxy in front of it
      1) Debezium is connected to database 1
      2) Events are processed form database
      3) Database 1 is shutdown
      4) New records are added to database 2
      4) Debezium is connected to database 2
      5) Database 2 reports a GTID set of GTIDs coming from database 1 and its own GTIDs
      6) Debezium fiters out Database 2 GTIDs because io.debezium.connector.mysql.MySqlTaskContext.filterGtidSet(GtidSet, GtidSet) does not remove database 2 UUIDs from filtered set as it does not have any recorded to overwrite
      7) All records that were written before Debezium restart are lost

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                jpechanec Jiri Pechanec
                Reporter:
                jpechanec Jiri Pechanec
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: