Percona XtraBackup does not work with MariaDB 10.1 or greater if encryption or compression is used, or when innodb_page_size is set to some value other than 16K. It also does not work with MariaDB 10.2 or greater if innodb_safe_truncate=ON is set. It also does not work with MariaDB 10.3 or greater. For the cases where Percona XtraBackup is not supported, see Mariabackup instead.

Percona XtraBackup is an open source tool for performing hot backups of MariaDB, MySQL and Percona Server databases.

Mariabackup is a fork of Percona XtraBackup designed to work with encrypted and compressed tables and other MariaDB enhancements. There are many bug fixes, such as MDEV-13807, and some unsafe or redundant options have been removed. Mariabackup is the recommended backup method for MariaDB servers.

XtraBackup can perform compressed, incremental and streaming backups. It was designed to back up XtraDB/InnoDB tables but can also back up other storage engines.

If you want to use XtraBackup with uncompressed and unencrypted MariaDB data, use Percona XtraBackup 2.3 for MariaDB Server versions through 10.1.

You might also be able to use XtraBackup 2.4 for MariaDB Server 10.2, but be aware that problems are likely due to the MySQL 5.7 undo log format incompatibility bug that was fixed in MariaDB 10.2.2 in MDEV-12289. Due to this bug, backups prepared with XtraBackup 2.4 may fail to recover some transactions. Only if you ran the server with the setting innodb_undo_logs=1 this would not be a problem. XtraBackup 2.4 may also fail to work entirely with MariaDB 10.2.19 and later if innodb_safe_truncate=ON is set due to changes in the redo log format introduced by MDEV-14717. In that case, you may see the following error:

InnoDB: Unsupported redo log format. The redo log was created with MariaDB 10.2.19. Please follow the instructions at http://dev.mysql.com/doc/refman/5.7/en/upgrading-downgrading.html

XtraBackup is not compatible with MariaDB 10.3 and later, and according to the relevant XtraBackup bug report, it does not appear that this will be fixed.

XtraBackup 2.3 and 2.4 are both available from the MariaDB Package Repository. Note that XtraBackup 2.3 packages are called percona-xtrabackup while XtraBackup 2.4 packages are called percona-xtrabackup-24.

See Also

Comments

Comments loading...