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

Update events should contain old values in addition to new values

XMLWordPrintable

      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.

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

                Created:
                Updated:
                Resolved: