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

Replace use of XtraBackup with MariaDB Backup

Details

    Description

      XtraBackup doesn't work with MariaDB Server 10.1 and newer. You might not notice it, but you can end up with inconsistent backups.

      • For Galera there are scripts for SST that make use of XtraBackup. These should be updated to use MariaDB Backup instead.
      • Galera tests using XtraBackup should also be updated

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-12289 Keep 128 persistent rollback segments for compatibility and performance

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13564 TRUNCATE TABLE and undo tablespace truncation are not compatible with Mariabackup

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-15522 Change galera suite MTR tests to use mariabackup instead of xtrabackup

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Task - A task that needs to be done. MDEV-16913 Correct documentation of xtrabackup as Galera SST method

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17835 Remove wsrep-sst-method=xtrabackup

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            marko Marko Mäkelä added a comment -

            I would expect XtraBackup to work with MariaDB Server 10.1, except when page_compressed or encrypted tables are present.

            With MariaDB Server 10.2, I would expect some trouble due to MDEV-12289. MySQL 5.7 changed the transaction system format in such a way that an upgrade from earlier versions can be affected.

            MariaDB 10.2 with MDEV-12289 fixed will allow upgrade from earlier MariaDB and MySQL versions. Xtrabackup contains some logic that will handle undo log records, and it is possible that this logic is compatible with the MySQL 5.7 format but not the earlier format. I am not aware of related failures, but I have also not tested it.

            The crash-downgrade protection required by the undo log format change related to MDEV-13564 will prevent XtraBackup from working.

            XtraBackup never worked with MariaDB Server 10.3, because the redo log format (and identifier) was changed.

            marko Marko Mäkelä added a comment - I would expect XtraBackup to work with MariaDB Server 10.1, except when page_compressed or encrypted  tables are present. With MariaDB Server 10.2, I would expect some trouble due to MDEV-12289 . MySQL 5.7 changed the transaction system format in such a way that an upgrade from earlier versions can be affected. MariaDB 10.2 with MDEV-12289 fixed will allow upgrade from earlier MariaDB and MySQL versions. Xtrabackup contains some logic that will handle undo log records, and it is possible that this logic is compatible with the MySQL 5.7 format but not the earlier format. I am not aware of related failures, but I have also not tested it. The crash-downgrade protection required by the undo log format change related to MDEV-13564 will prevent XtraBackup from working. XtraBackup never worked with MariaDB Server 10.3, because the redo log format (and identifier) was changed.

            People

              jplindst Jan Lindström (Inactive)
              ratzpo Rasmus Johansson (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              5 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.