Percona XtraBackup

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

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.

Note that XtraBackup (at least as of 2.4.7) will not work with MariaDB 10.1 encryption or compression, or when innodb_page_size is set to some value other than 16K.

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

More info

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.