MySQL Enterprise Backup 3.12.0 has been released

sreedhar sreedhargadda <[email protected]> Mon, 16 Mar 2015 22:19:47 +0530
Newsgroups gmane.comp.db.mysql.announce,gmane.comp.db.mysql.general,gmane.comp.db.mysql.packagers
Organization Oracle Corporation
Message-ID <[email protected]>
Dear MySQL users,

MySQL Enterprise Backup v3.12.0, a new version of the online MySQL backup
tool, is now available for download from the My Oracle Support (MOS) website
as our latest GA release. This release will be available on eDelivery (OSDC)
after the next upload cycle. MySQL Enterprise Backup is a commercial
extension to the MySQL family of products.

A brief summary of the changes in MySQL Enterprise Backup (MEB)
version 3.12.0 is given below.

Functionality Added or Changed               (2015-03-16)

      * MySQL Enterprise Backup now supports cloud backup and
        restore using OpenStack Object Storage ("Swift") 1.0.
        Authentication can be handled either through Swift's own
        TempAuth authentication system or the OpenStack Identity
        Service (Keystone) 2.0. A number of new command options
        have been introduced to support OpenStack Object Storage;
        see Cloud Storage Options
        (http://dev.mysql.com/doc/mysql-enterprise-backup/3.12/en 
<http://dev.mysql.com/doc/mysql-enterprise-backup/3.12/en/backup-cloud-options.html>
/backup-cloud-options.html 
<http://dev.mysql.com/doc/mysql-enterprise-backup/3.12/en/backup-cloud-options.html>), 
for details.

      * MySQL Enterprise Backup now supports table renaming when
        a single table is restored from a backup created using
        transportable tablespace (TTS). See the
        description for the --rename option for details.

      * The --skip-binlog and --skip-relaylog options can now be
        used to skip the copying back of the binary log and relay
        log onto the server during a restore. This is
        particularly useful for users who do not want those logs
        appearing in the restored server's data directory, as
        that is always the location to which mysqlbackup will
        restore them, regardless of their original locations on
        the backed-up server. (Bug #19887998)

      * MySQL Enterprise Backup no longer writes to the
        incremental_base_lsn column in the mysql.backup_history
        table when creating an incremental backup, as the column
        is no longer used by mysqlbackup. Note that the column
        will eventually be dropped from the table in future
        releases of MySQL Enterprise Backup. (Bug #19548604)

      * The --force option can now be used during the restore of
        a full backup to overwrite existing data in a non-empty
        target directory. See the description for the --force
        option for details. (Bug #19266491)

      * The binary log file and relay log files (in the case of a
        slave server) are now compressed when they are being
        included in a compressed backup and decompressed during a
        restore. (Bug #19149210)

    Bugs Fixed

      * Near the end of the second phase of an optimistic backup,
        mysqlbackup rescanned the tables that had already been
        copied in the first, optimistic phase of the backup, and
        tried to copy again any of those tables that had been
        modified since they were first copied; this attempt to
        overwrite the already-copied table by a recopying caused
        a file creation error. With this fix, any such table
        changes are rightfully ignored, as the changes have been
        recorded in the redo log already and will be taken care
        of later by the apply-log operation. (Bug #20583014)

      * Performing a backup-and-apply-log and then a
        copy-back-and-apply-log caused the redo log files to be
        skipped during the restore process and thus missing on
        the restored server. This was because in this non-typical
        sequence of operations, the apply-log step (by which the
        redo log is usually copied) in the
        copy-back-and-apply-log step was skipped, as an apply-log
        operation had already been performed by the
        backup-and-apply-log step. This fix makes sure the
        copying of the redo log files is not skipped in that
        situation. (Bug #20583014)

      * If an incremental image backup contained a large number
        of pages from a single table, the restore of the
        incremental backup using the copy-back-and-apply-log
        command might fail. (Bug #20492274)

      * After a RESET SLAVE statement was executed on a slave
        server, a subsequent backup for the slave server failed
        with an error, as mysqlbackup could not copy the relay
        log file from the server. This was becuase mysqlbackup
        could not detect the location of the current relay log
        after the slave reset, and the this fix makes sure
        mysqlbackup knows how to do that. (Bug #20180440, Bug
        #75074)

      * During the restore of an offline image backup, the
        master.info and relay-log.info files were sometimes not
        copied into the data directory on the target server. (Bug
        #19973192)
        References: This bug is a regression of Bug #19883801.

      * Offline backups failed unless the --skip-binlog option
        was used, because the default action of copying the
        binary log failed. With this fix, the binary log can now
        be successfully included in an offline backup. (Bug
        #19941735)
        References: This bug is a regression of Bug #19883801.

      * When creating a full backup with the --no-locking option,
        mysqlbackup failed to write the binary log information to
        the backup history table and the backup_variables.txt
        file. The result was that when creating an incremental
        backup based on the full backup, the attempt to copy the
        binary log files from the server into the incremental
        backup (which has been the default behavior of MySQL
        Enterprise Backup since 3.11.0) would fail, causing the
        incremental backup to stop. With this fix, the binary log
        information is no longer missing after the full backup,
        so the incremental backup no longer fails." (Bug
        #19915713)

      * If a binary log file on the server got removed as a
        backup was taking place, the backup failed, as
        mysqlbackup could not find the binary log file it wanted
        to copy into the backup. With the fix, mysqlbackup
        continues to finish the backup operation even if some
        binary log files have been deleted, except for the case
        of an incremental backup (for which the backup is still
        going to fail).
        Also, with this fix, only the binary log files listed in
        the binary log index file are copied back to a server
        during a restore, so that purged binary log files, even
        backed up, are not restored. (Bug #19849326)

      * When mysqlbackup encountered a corrupted .frm file during
        a backup, it threw an error, tried to continue with the
        backup, and then hung eventually. With this fix,
        mysqlbackup just gives a warning message ("WARNING: An
        error occurred while adding manifest information for
        backup"), and then continues with the backup as usual.
        (Bug #19608231)

      * On Windows platforms, when symbolic links were involved
        in the file path arguments for options like --backup-dir
        or --backup-image, mysqlbackup failed with an error. With
        this fix, mysqlbackup works in the situation as long as
        the arguments do not involve dangling symbolic links, in
        which case mysqlbackup throws an error instead of
        creating any directory or file under any
        symbolically-linked locations. (Bug #19608231)

      * When trying to restore a non-TTS backup to a running
        server, mysqlbackup overwrote the data on the server
        without giving any warning. This fix makes mysqlbackup
        terminate the restore of a non-TTS full backup with an
        error whenever it finds the target data directory to be
        non-empty, and then issue a message that the --force
        option should be used if the user wants the original data
        to be overwritten.
        Note
        For overwriting the data directory during the restore of
        a full backup using the --force option, users are
        recommended to use the copy-back command, preceded by an
        apply-log operation, instead of using the one-step
        copy-back-and-apply-log command.
        (Bug #19266491)

      * Compression information displayed after the second phrase
        of a compressed, optimistic backup was only for the
        second phase of the backup. With this fix, the
        information now reflects the total compression performed
        for the whole process, including both the first and
        second phases. (Bug #19200562)

      * The list-image operation on cloud backups failed. This
        was because the operation requires transfer of data
        without buffering, but mysqlbackup was transferring data
        in buffered mode by default. This fix makes mysqlbackup
        download data for the operation without buffering---which
        is possible as long as the cloud proxy supports HTTP
        range hearers. (Bug #19162974)

      * When restoring an incremental backup using the
        copy-back-and-apply-log subcommand on Windows platforms,
        the operation failed when long file paths were used in
        the command-line options. (Bug #18448617)

You can also find more information on the contents of this release in 
the change log:
http://dev.mysql.com/doc/mysql-enterprise-backup/3.12/en/meb-news.html

The complete manual for MEB 3.12.0 is at
http://dev.mysql.com/doc/mysql-enterprise-backup/3.12/en/index.html

The tool is available for download from Oracle Software Delivery
Cloud (http://edelivery.oracle.com/).

You can also download the binaries from MOS, https://support.oracle.com
Choose the "Patches & Updates" tab, and then use the "Product or Family
(Advanced Search)" feature. If you haven't looked at MEB recently,
please do so now and let us know how MEB works for you.

Your feedback is greatly appreciated!

Please report any problems you have at https://bug.oraclecorp.com/
for the product "MySQL Enterprise Backup"

Thanks,

On behalf MySQL RE team at Oracle

Sreedhar S