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

Add support for MySQL 8.0 binlog events

    XMLWordPrintable

Details

    • Bug
    • Status: In Testing (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.6
    • 10.6.21
    • Replication
    • None

    Description

      MySQL 8.0 has added the following new events in the MySQL binary log

      PARTIAL_UPDATE_ROWS_EVENT
      TRANSACTION_PAYLOAD_EVENT
      HEARTBEAT_LOG_EVENT_V2

      • PARTIAL_UPDATE_ROWS_EVENT is used by MySQL to generate update
        statements using JSON_SET, JSON_REPLACE and JSON_REMOVE to make
        update of JSON columns more efficient. These events can be
        disabled by setting 'binlog-row-value-options=""'
      • TRANSACTION_PAYLOAD_EVENT is used by MySQL to signal that a
        row event is compressed. It an be disably by setting
        'binlog_transaction_compression=0'.
      • HEARTBEAT_LOG_EVENT_V2 is written to the binary log many times
        per seconds. It can be ignored by the server.

      Attachments

        Issue Links

          Activity

            People

              susil.behera Susil Behera
              monty Michael Widenius
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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