Presentation: Highly efficient backup with Xtrabackup


Xtrabackup is the most widely open source hot backup tool for MySQL. Xtrabackup support InnoDB and MyISAM engines.It supports both MySQL Server , Percona Server and MariaDB. This presentation covers some of the important features in Xtrabackup.

Pic Courtesy :

5 thoughts on “Presentation: Highly efficient backup with Xtrabackup

  1. Slide 11 claims that Percona Xtrabackup versions starting with 2.3 are compatible with MariaDB 10.x.
    I was under the impression that Xtrabackup 2.3 is not compatible with MySQL 5.7 or MariaDB 10.2 or later. The reason is that the InnoDB redo log header format was changed in MySQL 5.7.9 (WL#8845 by me).

    Furthermore, Xtrabackup is not compatible with the MariaDB 10.1 encryption and compression features. This was one of the motivations why Mariabackup was created.

    When it comes to MariaDB 10.2, Percona Xtrabackup 2.4 may seem to works, but there is a caveat: The MySQL 5.7 undo log format is not compatible with earlier MySQL versions, because MySQL 5.7 hard-codes the rollback segment IDs 1 to 32 in the persistent data structures for temporary undo logs. Because of this incompatible change, an upgrade form MySQL 5.6 to MySQL 5.7 will require the undo logs to be emptied, which (sometimes) happens if the server is shut down after SET GLOBAL innodb_fast_shutdown=0 prior to the upgrade.

    In MariaDB 10.2, which is based on MySQL 5.7, the undo log format was changed to be backward-compatible with MySQL 5.6 and earlier MariaDB versions, in Because Xtrabackup 2.4 is based on MySQL 5.7, problems may arise when it is used with MariaDB 10.2.

    Side note: When I ported Mariabackup for MariaDB 10.2, I tried to make the ‘prepare’ (’apply-log’) operation more robust, partly because I was concerned about the correctness of incremental restore operations. Mariabackup 10.2 will normally not generate any redo log, and will not process any change buffer or undo log entries. These actions will only be taken if the –export option is used, for partial restore.

    Upgrades, including crash-upgrades, are part of the MariaDB continuous integration testing. MariaDB 10.3 will change both undo and redo log formats again, but crash-upgrades from 10.2 and normal upgrades from 10.x are being tested. While we neither test nor endorse attempts to downgrades, under certain limitations downgrades from 10.3 to 10.2.13 or later should work.

    I believe that Mariabackup 10.1 should work with MariaDB 5.5, 10.0, 10.1. Mariabackup 10.2 only works with MariaDB 10.2. Mariabackup 10.3 should work with both MariaDB 10.2 and 10.3 when 10.3 is released as GA.

    Liked by 2 people

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s