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

      Attachments

        Activity

          People

            jpechane Jiri Pechanec
            jpechane Jiri Pechanec
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: