Percona XtraBackup

You are viewing an old version of this article. View the current version here.

Percona XtraBackup is not supported in MariaDB. Mariabackup is the recommended backup method to use instead of Percona XtraBackup. See Percona XtraBackup Overview: Compatibility with MariaDB for more information.

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

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

See Also

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.