Percona XtraBackup 2.2.6

Percona is glad to announce the release of Percona XtraBackup 2.2.6 on November 3rd 2014. Downloads are available from our download site here and from apt and yum repositories.

This release is the current stable release in the 2.2 series.

New Features

Percona XtraBackup now reads server options from SHOW VARIABLES rather than my.cnf configuration file.

Percona XtraBackup now has more verbose output during initial table scan (it will now print a diagnostic message before performing a tablespace scan, which may take a long time on systems with large numbers of tablespaces) and before starting a backup/apply-log/copy-back operation in innobackupex (it will now print a diagnostic message with a timestamp to make it easier for users to get duration of the operation.)

Bugs Fixed

innobackupex didn’t take the default datadir, which caused backups to fail if the datadir wasn’t specified in the my.cnf configuration file. Bug fixed #936934.

innobackupex will now fail with an error when innobackupex --slave-info is used on a multi-threaded non-GTID slave, because Exec_Master_Log_Pos cannot be trusted for a multi-threaded slave. Bug fixed #1372679.

InnoDB log scanning failure (bug #60788) would cause backups to fail. Fixed by porting the fix from MySQL 5.7. Bug fixed #1375383.

Options innobackupex --apply-log and innobackupex --decompress weren’t marked as mutually exclusive, ie. if they were both specified, only innobackupex --decompress would work, which could lead to MySQL instance being started with an unprepared backup. Fixed by making mutually exclusive categories of options: 1. innobackupex --decompress, innobackupex --decrypt; 2. innobackupex --copy-back; 3. innobackupex --move-back; 4. innobackupex --apply-log. Bug fixed #1376874.

innobackupex wasn’t creating directories specified in innodb_data_home_dir and innodb_log_group_home_dir when innobackupex --copy-back option was used. Bug fixed #1382347.

Percona XtraBackup now supports all option modifiers supported by upstream MySQL: skip, disable, enable, maximum, loose. Bug fixed #664128.

Percona XtraBackup would fail to perform a full backup on Percona Server 5.5 if innodb_log_file_size variable wasn’t set in the [mysqld] section of my.cnf. Bug fixed #1334062.

Other bugs fixed: #1379905, #1386013, #1072695, #1375241, #1182841, and #1343722.

All of Percona’s software is open-source and free, all the details of the release can be found in the 2.2.6 milestone at Launchpad. Bugs can be reported on the launchpad bug tracker.