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

When MySQL has BINLOG_ROWS_QUERY_LOG_EVENTS enabled, include original SQL query in event.

    Details

    • Type: Enhancement
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 0.8.0.Beta1
    • Component/s: mysql-connector
    • Labels:
      None
    • Environment:

      MySQL 5.6+ with BINLOG_ROWS_QUERY_LOG_EVENTS configuration option set to 'ON'

      Description

      Summary

      Starting with MySQL 5.6 the BINLOG_ROWS_QUERY_LOG_EVENTS configuration property allows adding the original SQL query to RBR events.

      It appears as thought the underlying MySQL Connector library supports parsing this additional property ( EventType.ROWS_QUERY ).

      It'd be great if the Debezium MySQL Connector could be updated to support parsing this optional property and including it in the Events published into Kafka.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                spowis Stephen Powis
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: