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

Filter out useless commands from the history topic

XMLWordPrintable

    • Icon: Enhancement Enhancement
    • Resolution: Done
    • Icon: Minor Minor
    • 0.7.5
    • 0.7.4
    • mysql-connector
    • None

      Hello,

      While I was trying to debug some issues with the help of jpechane, I noticed that my history table was filled with the same MySQL administrative command : "FLUSH RELAY LOGS;" (as the source DB is a replica).

      These commands should not be valuable for debezium so I think they should be filtered out and not stored.

      "{\n  \"source\" : {\n    \"server\" : \"dbz\"\n  },\n  \"position\" : {\n    \"ts_sec\" : 1520391602,\n    \"file\" : \"mysql-bin.017886\",\n    \"pos\" : 318724798,\n    \"gtids\" : \"2fbd5b-db33-11e5-a2e4-38eaac:1-31334113,61d9-a0fa-11e6-ac91-38ea16c44:1-21926905203,99a-dcda-11e6-af0c-387918a70:1-143634\",\n    \"server_id\" : 1111,\n    \"event\" : 5\n  },\n  \"databaseName\" : \"\",\n  \"ddl\" : \"flush relay logs\"\n}"
      

              Unassigned Unassigned
              fuyar UYAR Farid (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: