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

Allow reseting MySQL connector's offset

    XMLWordPrintable

Details

    • Feature Request
    • Resolution: Won't Do
    • Optional
    • None
    • None
    • mysql-connector
    • None
    • False
    • None
    • False
    • 0
    • 0% 0%

    Description

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

      Add a config to MySQL connector that allows overriding committed offset. Replaying binlog is useful in case of a data corruption incident or data loss incidents. For example an SMT could have an issue in filtering or transformation logic when events get lost or corrupted.

      Implementation ideas (optional)

      Add an optional config that takes an offset to force reset to. The format is the same as for committed offsets, so that the desired offset could be copied from the connector's offsets topic.
      The previous offset gets overridden with the value from config if config is provided.
      The schema history will be recovered up to the provided offset, because there could be schema changes between provided and the latest committed offset. 

      Attachments

        Activity

          People

            Unassigned Unassigned
            kgalieva Kate Galieva (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: