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

Filter out events without ROW_EVENT

    XMLWordPrintable

Details

    • Task
    • Resolution: Unresolved
    • Major
    • 1.9-backlog
    • None
    • vitess-connector
    • None
    • False
    • False

    Description

      VEvent with ROW_EVENT field are the "real" binlog events from main database that we are interested. Vitess will stream out transactions on "internal" tables (e.g., _vt.* tables) with `begin/gtid/commit`.

      Example:

      {
        "events": [
          {
            "type": "BEGIN",
            "timestamp": "1643917461",
            "currentTime": "1643917461158158827"
          },
          {
            "type": "VGTID",
            "vgtid": {
              "shardGtids": [
                {
                  "keyspace": "test_keyspace",
                  "shard": "-80",
                  "gtid": "MySQL56/2582b27c-7e73-4cd2-8640-028069dc2704:1-2575468:3343958-3344114"
                }
              ]
            }
          },
          {
            "type": "COMMIT",
            "timestamp": "1643917461",
            "currentTime": "1643917461158209298"
          }
        ]
      }
      

      There is no row updates at all since this is an update on `_vt.heartbeat` table. We should have an flag to filter them out
       

       

       

      Attachments

        Activity

          People

            Unassigned Unassigned
            ywu-stripe Yang Wu (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: