Percona XtraBackup 2.0.5

Percona is glad to announce the release of Percona XtraBackup 2.0.5 on January 18th, 2013. 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.0 series.

New Features

New option --defaults-extra-file has been introduced. This option specifies from what extra file to read the default MySQL options before the standard defaults-file. It can be used to load the user/password combination for the dedicated backup user from a separate configuration file, to avoid storing it in the crontab or a script somewhere in the system.

Bugs Fixed

In case of streaming backups, innobackupex would resume the Percona XtraBackup process and then wait for it to finish before running UNLOCK TABLES. This caused database to be unnecessarily locked with FLUSH TABLES WITH READ LOCK. Innobackupex now waits only till log copying is finished to unlock the databases. Bug fixed #1055989 (Alexey Kopytov).

innobackupex error messages referencing the data directory have been extended to show the path of the data directory mentioned in the error message. Bug fixed #1089375 (Hartmut Holzgraefe).

Partitioned tables were not correctly handled by the --databases, --include, --tables-file options of innobackupex, and by the --tables and --tables-file options of Percona XtraBackup. Fixed by removing the partition suffix (#P#...) before doing filtering. Bug fixed #711166 (Sergei Glushchenko).

When built-in compression was used, Percona XtraBackup was doing unbuffered writes to the destination file or stream in very small chunks which in return caused inefficient I/O. Fixed by using a 1M buffer for output similar to the uncompressed backups. Bug fixed #1095249 (Alexey Kopytov).

Unnecessary long sleep() in innobackupex lead to FLUSH TABLES WITH READ LOCK taking too long. Fixed by replacing 2 seconds sleep interval with 100 milliseconds one. Bug fixed #1095551 (Sergei Glushchenko).

If innobackupex would crash it would leave the xtrabackup_suspended file on the filesystem. This could then cause innobackupex to think Percona XtraBackup has suspended itself the moment it started, and then when xtrabackup actually does suspend itself innobackupex would wait for it to end and wouldn’t re-remove the suspend_file, leading to a wait deadlock. Fixed by removing the stale xtrabackup_suspended file when innobackupex is started. Bug fixed #1007446 (George Ormond Lorch III).

innobackupex would fail to recognize MariaDB 5.2 and MariaDB 5.3. Fixed by augmenting version checks in innobackupex. Bug fixed #733665 (Daniël van Eeden, Alexey Kopytov).

Other bug fixes: bug fixed #924492 (Alexey Kopytov), bug fixed #1097158 (Alexey Kopytov), bug fixed #1081882 (Alexey Kopytov), bug fixed #1096584 (Alexey Kopytov),

© Copyright 2009-2014, Percona LLC and/or its affiliates.
Except where otherwise noted, this documentation is licensed under the following license:
CC Attribution-ShareAlike 2.0 Generic
Created using Sphinx 1.2.2.
This documentation is developed in Launchpad as part of the Percona XtraBackup source code.
If you spotted innacuracies, errors, don't understood it or you think something is missing or should be improved, please file a bug.
{"cc_re__cc_re__cc_by_sa_2_0": ["en\" name=\"check_keywords\" value=\"yes\" />\n      <input type=\"hidden\" name=\"area\" value=\"default\" />\n    </form>\n\n</div>\n<script type=\"text/javascript\">$('#searchbox').show(0);</script>\n\n\t\t\t\n        </div>\n      </div>\n\n      <div class=\"clearer\"></div>\n     \n     \n    \n    \n    <div class=\"license\">\n      &copy; Copyright 2009-2014, Percona LLC and/or its affiliates.\n\n      <br />\n        Except where otherwise noted, this documentation is licensed under the following license:\n      <br />\n      <a class=\"urlextern\" rel=\"license\" href=\"http://creativecommons.org/licenses/by-sa/2.0/\">\n        CC Attribution-ShareAlike 2.0 Generic</a><br />\n      Created using <a href=\"http://sphinx.pocoo.org/\">Sphinx</a> 1.2.2.    \n\n     </div>\n\n    </div>\n</div>\n\n\n    <div class=\"file-bugs\">\n        This documentation is developed in Launchpad as part of the <a  rel=\"nofollow\" href=\"https://code.launchpad.net/percona-xtrabackup\">Percona XtraBackup source code</a>.<br/>\n    If you spotted innacuracies, errors, don't understood it or you think something is missing or should be improved, pleas"], "copyright__copyright__copyright": ["81882 (Alexey Kopytov), bug fixed #1096584 (Alexey Kopytov),\n\n\u00a9 Copyright 2009-2014, Percona LLC and/or its affiliates.\nExcept where otherwise noted, this documentation is licensed under the following license:\nCC Attribution-ShareAlike 2.0 Generic\nCreated using Sphinx 1.2.2.\nThis documentation is developed in Launchpad as part of the Percona XtraBackup source code.\nIf you spotted innacuracies, errors, don't understood it or you think something is missing or should be improved, please file a bug.", "81882 (Alexey Kopytov), bug fixed #1096584 (Alexey Kopytov),\n\n\u00a9 Copyright 2009-2014, Percona LLC and/or its affiliates.\nExcept where otherwise noted, this documentation is licensed under the following license:\nCC Attribution-ShareAlike 2.0 Generic\nCreated using Sphinx 1.2.2.\nThis documentation is developed in Launchpad as part of the Percona XtraBackup source code.\nIf you spotted innacuracies, errors, don't understood it or you think something is missing or should be improved, please file a bug.", "81882 (Alexey Kopytov), bug fixed #1096584 (Alexey Kopytov),\n\n\u00a9 Copyright 2009-2014, Percona LLC and/or its affiliates.\nExcept where otherwise noted, this documentation is licensed under the following license:\nCC Attribution-ShareAlike 2.0 Generic\nCreated using Sphinx 1.2.2.\nThis documentation is developed in Launchpad as part of the Percona XtraBackup source code.\nIf you spotted innacuracies, errors, don't understood it or you think something is missing or should be improved, please file a bug.", "81882 (Alexey Kopytov), bug fixed #1096584 (Alexey Kopytov),\n\n\u00a9 Copyright 2009-2014, Percona LLC and/or its affiliates.\nExcept where otherwise noted, this documentation is licensed under the following license:\nCC Attribution-ShareAlike 2.0 Generic\nCreated using Sphinx 1.2.2.\nThis documentation is developed in Launchpad as part of the Percona XtraBackup source code.\nIf you spotted innacuracies, errors, don't understood it or you think something is missing or should be improved, please file a bug.", "81882 (Alexey Kopytov), bug fixed #1096584 (Alexey Kopytov),\n\n\u00a9 Copyright 2009-2014, Percona LLC and/or its affiliates.\nExcept where otherwise noted, this documentation is licensed under the following license:\nCC Attribution-ShareAlike 2.0 Generic\nCreated using Sphinx 1.2.2.\nThis documentation is developed in Launchpad as part of the Percona XtraBackup source code.\nIf you spotted innacuracies, errors, don't understood it or you think something is missing or should be improved, please file a bug.", "81882 (Alexey Kopytov), bug fixed #1096584 (Alexey Kopytov),\n\n\u00a9 Copyright 2009-2014, Percona LLC and/or its affiliates.\nExcept where otherwise noted, this documentation is licensed under the following license:\nCC Attribution-ShareAlike 2.0 Generic\nCreated using Sphinx 1.2.2.\nThis documentation is developed in Launchpad as part of the Percona XtraBackup source code.\nIf you spotted innacuracies, errors, don't understood it or you think something is missing or should be improved, please file a bug."]}