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

Port clone plugin from MySQL

Details

    Description

      Once we have the new clone plugin API from MySQL 8.0 (see MDEV-21105), we may want to port MySQL's clone plugin as well:

      https://github.com/mysql/mysql-server/tree/mysql-8.0.18/plugin/clone

      Information about this plugin can be found here:

      https://dev.mysql.com/doc/refman/8.0/en/clone-plugin.html

      This can be especially useful with replication:

      https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-replication.html

      Attachments

        Issue Links

          is blocked by

          New Feature - A new feature of the product, which has yet to be developed. MDEV-21105 Port clone plugin API (MYSQL_CLONE_PLUGIN) from MySQL

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

          Technical task - A technical task. MDEV-35248 in server backup: Research, scope & prototyping

          • Major - Major loss of function.
          • In Progress
          relates to

          New Feature - A new feature of the product, which has yet to be developed. MDEV-7502 Automatic provisioning of slave

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-8925 Extending protocol to support binary provisioning

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Task - A task that needs to be done. MDEV-15610 Add SST for asynchronous slaves

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MXS-2542 Add rebuild server to MariaDB Monitor

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            GeoffMontee Geoff Montee (Inactive) added a comment -

            As ralf.gebhardt@mariadb.com pointed out in MDEV-21105, the clone plugin from MySQL 8.0 only supports InnoDB:

            • The clone plugin only clones data stored in InnoDB. Other storage engine data is not cloned. MyISAM and CSV tables stored in any schema including the sys schema are cloned as empty tables.

            https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-limitations.html

            I have no idea how dependent the clone plugin is on the InnoDB features in MySQL 8.0 that have not been ported to MariaDB. marko would probably have to comment on that.

            GeoffMontee Geoff Montee (Inactive) added a comment - As ralf.gebhardt@mariadb.com pointed out in MDEV-21105 , the clone plugin from MySQL 8.0 only supports InnoDB: The clone plugin only clones data stored in InnoDB. Other storage engine data is not cloned. MyISAM and CSV tables stored in any schema including the sys schema are cloned as empty tables. https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-limitations.html I have no idea how dependent the clone plugin is on the InnoDB features in MySQL 8.0 that have not been ported to MariaDB. marko would probably have to comment on that.
            colin Colin Charles added a comment -

            Worth noting that the CLONE plugin has been ported to work with MyRocks. So it is possible that it can support more than just InnoDB.

            See: https://github.com/facebook/mysql-5.6/wiki/MyRocks-Clone-Plugin

            And overall reading https://of-code.blogspot.com/2024/01/mysql-clone-plugin-internals-and.html

            colin Colin Charles added a comment - Worth noting that the CLONE plugin has been ported to work with MyRocks. So it is possible that it can support more than just InnoDB. See: https://github.com/facebook/mysql-5.6/wiki/MyRocks-Clone-Plugin And overall reading https://of-code.blogspot.com/2024/01/mysql-clone-plugin-internals-and.html

            People

              Unassigned Unassigned
              GeoffMontee Geoff Montee (Inactive)
              Votes:
              4 Vote for this issue
              Watchers:
              11 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.