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

Update events should contain old values in addition to new values

    XMLWordPrintable

Details

    Description

      Currently the MySQL connector generates two kinds of events:

      1. When a row is removed, the connector generates a tombstone event that contains for the key the primary key of the removed row, and a null value.
      2. When a row is inserted or updated, the connector generates an event that uses the row's primary key for the event key, and a structure that contains fields for each of the row's new values.

      Thus, the only way to distinguish between insert and update events is to already know whether the primary key has appeared before. Additionally, the event does not contain any information about what changed in the row. Both of these are likely to be useful for some downstream consumers.

      We should consider changing the message format of events so that update events can more easily be distinguished and contain information about what changed.

      Attachments

        Issue Links

          Activity

            People

              rhauch Randall Hauch (Inactive)
              rhauch Randall Hauch (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: