Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered free as an open source solution, it drives down backup costs while providing unique features for MySQL backups.
New features and improvements:
- PXB-1548: Percona XtraBackup enables updating the
ib_buffer_poolfile with the latest pages present in the buffer pool using the
--dump-innodb-buffer-pooloption. Thanks to Marcelo Altmann for contribution.
xtrabackupdid not delete missing tables from the partial backup which led to error messages logged by the server on startup. Bug fixed PXB-1536.
--historyoption did not work when autocommit was disabled. Bug fixed PXB-1569.
xtrabackupcould fail to backup encrypted tablespace when it was recently created or altered. Bug fixed PXB-1648.
- When the
--throttleoption was used, the applied value was different from the one specified by the user (off by one error). Bug fixed PXB-1668.
- It was not allowed for MTS (multi-threaded slaves) without GTID to be backed up with
--safe-slave-backup. Bug fixed PXB-1672.
- Percona Xtrabackup could crash when the
ALTER TABLE … TRUNCATE PARTITIONcommand was run during a backup without locking DDL. Bug fixed PXB-1679.
xbcryptcould display an assertion failure and generated core if the required parameters are missing. Bug fixed PXB-1683.
--lock-ddl-per-tablecaused the server to scan all records of partitioned tables which could lead to the “out of memory error”. Bugs fixed PXB-1691 and PXB-1698.
xtrabackup --preparecould hang while performing insert buffer merge. Bug fixed PXB-1704.
- Incremental backups did not update
--binlog-info=lockless. Bug fixed PXB-1711