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

Support replication from MySQL 8.0 to MariaDB

Details

    • Bug
    • Status: In Progress (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.6, 11.4
    • 11.4
    • Replication
    • None

    Description

      The goal is to ensure that one can use MariaDB as a slave of a MySQL 8.0 server.

      There are a few issues when replication from MySQL 8.0 -> MariaDB:

      • As MariaDB server does not support the MySQL default authentication
        caching_sha2_password, one has to add another replication user using the mysql_native_password protocol.
      • One has to change JSON columns to be of type TEXT (as the MySQL JSON format
        is different from MariaDB).
      • One has to change the character set / collation from utf8mb4_0900_... to one supported by
        MariaDB, like utf8mb4 or utf8mb4_uca1400_ai_ci (starting from MariaDB 10.10).
        This is to be fixed in 11.4

      MySQL 8.0 has added the following new events in the MySQL binary log that needs to be taken care of:

      PARTIAL_UPDATE_ROWS_EVENT
      TRANSACTION_PAYLOAD_EVENT
      HEARTBEAT_LOG_EVENT_V2

      Attachments

        Issue Links

          includes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35643 Add support for MySQL 8.0 binlog events

          • Major - Major loss of function.
          • Closed
          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35780 MySQL 8 JSON data replication is stopping further replication

          • Major - Major loss of function.
          • Open
          is part of

          Task - A task that needs to be done. MDEV-28906 MySQL 8.0 desired compatibility

          • Major - Major loss of function.
          • Open
          relates to

          New Feature - A new feature of the product, which has yet to be developed. MDEV-35841 replicate MySQL 9.0 Vector to MariaDB

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-20912 Add support for utf8mb4_0900_* collations in MariaDB Server

          • Major - Major loss of function.
          • Closed

          Activity

            People

              monty Michael Widenius
              monty Michael Widenius
              Votes:
              0 Vote for this issue
              Watchers:
              7 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.