Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-7192

binlog_annotate_row_events not completely compatible with galera

    XMLWordPrintable

Details

    Description

      When using binlog_annotate_row_events in a galera cluster, row events in the binlog originating from the local node are annotated correctly. However, events originating on other nodes are annotated with an incorrect query.

      This makes sense since I don't think galera provides information about the query that generated an event. Without adding significant overhead to galera replication, the only thing I can think of for this would be to disable annotations for events originating from other nodes. This way, not every event would be annotated, but the ones that are would at least be correct.

      I attached some lightly redacted decoded binlog events. If needed, I can find some events I can leave intact with some more searching.

      Attachments

        Activity

          People

            nirbhay_c Nirbhay Choubey (Inactive)
            bradjorgensen Brad Jorgensen
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.