Percona is glad to announce the release of Percona XtraBackup 2.1.7 on January 24th, 2014. Downloads are available from our download site here and Percona Software Repositories.
This release is the current GA (Generally Available) stable release in the 2.1 series. Percona XtraBackup is an open source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. Percona XtraBackup is an open source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases.
New Features
Bugs Fixed
--help and --version options. Bug fixed #1223716.
ANSI_QUOTES SQL mode enabled. Bug fixed #1248331.
--galera-info is specified and Percona XtraDB Cluster is using GTID replication (version 5.6 only), innobackupex will execute FLUSH BINARY LOGS and then carry the current binary log as indicated in SHOW MASTER STATUS into the backup set. Bug fixed #1250375.
XA transactions when applying the log. Which was a regression introduced with the original port of Percona XtraBackup patches to 5.6. Fixed by restoring code that has been lost in the port. Bug fixed #1254227.
libgcrypt built in randomization functions for setting the Initialization Vector. Bug fixed #1255300.
xtrabackup_56 didn’t support ALL_O_DIRECT option for innodb_flush_method in Percona Server 5.6. Bug fixed #1261877.Other bugs fixed: #1255019, #1268325, #1265759, #1269694, #1271501.
Release notes with all the bugfixes for Percona XtraBackup 2.1.7 are available in our online documentation. All of Percona‘s software is open source and free, all the details of the release can be found in the 2.1.7 milestone at Launchpad. Bugs can be reported on the launchpad bug tracker.
Hi,
Can you show me any article that helps me to restore a single database (not just some tables) from a full mysql backup. Have been searching for this but got nothing. Overall, the main reason I am not sure about trying Percona products is the lack of documentation.
Hi Anh,
You can find the guide for making parital backups here: https://www.percona.com/doc/percona-xtrabackup/2.1/innobackupex/partial_backups_innobackupex.html
Hi Hrvoje,
Regarding the article you referred, I see
It can also be done by copying back the prepared backup to a “clean” datadir (in that case, make sure to include the mysql database).
Can I copy a single database, i.e., a subfolder in /var/lib/mysql to the datadir or I can only copy the whole datadir /var/lib/mysql.
so the new version is going to take care of the above problem. Instead of doing imports of individual tables can we restore the database with 1 command on a existing server and not a new install?
‘@Anh
You should just copy the /var/lib/mysql/mysql directory to the directory in which you made the partial backup and already run –aply-log –export (ie, /data/backups/2014-01-25-15-17-16). Copying the entire data directory would cause the backups to become inconsistent.
Regarding the lack of documentation, can you please report documentation bug(s) here (https://bugs.launchpad.net/percona-xtrabackup/+filebug) and I’ll make sure to improve the docs.
@shamim
No, this version doesn’t support one-command database restore to the existing server.
Thanks Hrvoje.