Percona XtraBackup does not work with MariaDB 10.2 or greater, or with MariaDB 10.1 if encryption or compression is used, or when innodb_page_size is set to some value other than 16K. See MariaDB Backup instead.

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

It 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 want to try to use XtraBackup 2.4 for MariaDB Server versions beginning with 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 is not compatible with MariaDB 10.3 and later.

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.

MariaDB Backup 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.

See Also

Comments

Comments loading...