November 28, 2014

MySQL 5.6 Compatible Percona XtraBackup 2.0.6 Released

MySQL 5.6 Compatible Percona XtraBackup 2.0.6

MySQL 5.6 Compatible Percona XtraBackup 2.0.6 was released March 20.

Percona is glad to announce the release of Percona XtraBackup 2.0.6 for MySQL 5.6 on March 20, 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:

  • XtraBackup 2.0.6 has implemented basic support for MySQL 5.6, Percona Server 5.6 and MariaDB 10.0. Basic support means that these versions are are recognized by XtraBackup, and that backup/restore works as long as no 5.6-specific features are used (such as GTID, remote/transportable tablespaces, separate undo tablespace, 5.6-style buffer pool dump files).

Bugs Fixed:

  • Individual InnoDB tablespaces with size less than 1MB were extended to 1MB on the backup prepare operation. This led to a large increase in disk usage in cases when there are many small InnoDB tablespaces. Bug fixed #950334 (Daniel Frett, Alexey Kopytov).
  • Fixed the issue that caused databases corresponding to inaccessible datadir subdirectories to be ignored by XtraBackup without warning or error messages. This was happening because InnoDB code silently ignored datadir subdirectories it could not open. Bug fixed #664986 (Alexey Kopytov).
  • Under some circumstances XtraBackup could fail to copy a tablespace with a high --parallel option value and a low innodb_open_files value. Bug fixed #870119 (Alexey Kopytov).
  • Fix for the bug #711166 introduced a regression that caused individual partition backups to fail when used with --include option in innobackupex or the --tables option in xtrabackup. Bug fixed #1130627 (Alexey Kopytov).
  • innobackupex didn’t add the file-per-table setting for table-independent backups. Fixed by making XtraBackup auto-enable innodb_file_per_table when the --export option is used. Bug fixed #930062 (Alexey Kopytov).
  • Under some circumstances XtraBackup could fail on a backup prepare with innodb_flush_method=O_DIRECT. Bug fixed #1055547 (Alexey Kopytov).
  • innobackupex did not pass the --tmpdir option to the xtrabackup binary resulting in the server’s tmpdir always being used for temporary files. Bug fixed #1085099 (Alexey Kopytov).
  • XtraBackup for MySQL 5.6 has improved the error reporting for unrecognized server versions. Bug fixed #1087219 (Alexey Kopytov).
  • Fixed the missing rpm dependency for Perl Time::HiRes package that caused innobackupex to fail on minimal CentOS installations. Bug fixed #1121573 (Alexey Bychko).
  • innobackupex would fail when --no-lock and --rsync were used in conjunction. Bug fixed #1123335 (Sergei Glushchenko).
  • Fix for the bug #1055989 introduced a regression that caused xtrabackup_pid file to remain in the temporary dir after execution. Bug fixed #1114955 (Alexey Kopytov).
  • Unnecessary debug messages have been removed from the XtraBackup output. Bug fixed #1131084 (Alexey Kopytov).

Other bug fixes: bug fixed #1153334 (Alexey Kopytov), bug fixed #1098498 (Laurynas Biveinis), bug fixed #1132763 (Laurynas Biveinis), bug fixed #1142229 (Laurynas Biveinis), bug fixed #1130581 (Laurynas Biveinis).

Release notes with all the bugfixes for Percona XtraBackup 2.0.6 for MySQL 5.6 are available in our online documentation. Bugs can be reported on the launchpad bug tracker.

Comments

  1. Kevin Pettit says:

    In innobackupex, you pick the executable based on the MySQL version, but no xtrabackup_56 is included in the release?

    -bash-3.2$ tar -tvf percona-xtrabackup-2.0.6-521.tar.gz
    drwxr-xr-x root/root 0 2013-03-19 17:12:12 percona-xtrabackup-2.0.6/
    drwxr-xr-x root/root 0 2013-03-19 17:29:37 percona-xtrabackup-2.0.6/bin/
    -rwxr-xr-x root/root 108823 2013-03-19 17:29:37 percona-xtrabackup-2.0.6/bin/innobackupex
    -rwxr-xr-x root/root 10641245 2013-03-19 17:29:37 percona-xtrabackup-2.0.6/bin/xtrabackup_51
    -rwxr-xr-x root/root 2258560 2013-03-19 17:29:37 percona-xtrabackup-2.0.6/bin/xbstream
    -rwxr-xr-x root/root 15693986 2013-03-19 17:17:00 percona-xtrabackup-2.0.6/bin/xtrabackup_55
    -rwxr-xr-x root/root 12530688 2013-03-19 17:24:45 percona-xtrabackup-2.0.6/bin/xtrabackup
    lrwxrwxrwx root/root 0 2013-03-19 17:29:37 percona-xtrabackup-2.0.6/bin/innobackupex-1.5.1 -> innobackupex
    drwxr-xr-x root/root 0 2013-03-19 17:29:38 percona-xtrabackup-2.0.6/share/
    drwxr-xr-x root/root 0 2013-03-19 17:12:12 percona-xtrabackup-2.0.6/share/doc/
    drwxr-xr-x root/root 0 2013-03-19 17:29:37 percona-xtrabackup-2.0.6/share/doc/percona-xtrabackup/

    sub set_xtrabackup_version {
    # Based on MySQL version choose correct binary
    # MySQL 5.0.* – xtrabackup_51
    # MySQL 5.1.* – xtrabackup_51
    # MySQL 5.1.* with InnoDB plugin – xtrabackup
    # MariaDB 5.1.* – xtrabackup
    # MariaDB 5.2.* – xtrabackup
    # MariaDB 5.3.* – xtrabackup
    # Percona Server 5.0 – xtrabackup_51
    # Percona Server 5.1 – xtrabackup
    # Percona Server 5.5 – xtrabackup_55
    # Percona Server 5.6 – xtrabackup_56
    # MySQL 5.5.* – xtrabackup_55
    # MySQL 5.6.* – xtrabackup_56
    # MariaDB 5.5.* – xtrabackup_55
    # MariaDB 10.0.* – xtrabackup_56

  2. Alexey Kopytov says:

    Kevin,

    Unfortunately xtrabackup_56 is missing from 2.0.6 tarballs due to a bug in packaging scripts. Which is https://bugs.launchpad.net/bugs/1158948

    It is included in RPM and .deb packages.

Speak Your Mind

*