MySQL Enterprise Backup 8.0.12 is the latest release for MySQL Enterprise Backup. It only supports MySQL Server 8.0.12. For earlier versions of MySQL 8.0, use the MySQL Enterprise Backup version with the same version number as the server. For MySQL server 5.7, please use MySQL Enterprise Backup 4.1, and for MySQL Server 5.6 and 5.5, please use MySQL Enterprise Backup 3.12.
Important Change: Starting from release 8.0.12, the storage engine of the
mysql.backup_historytable on a backed-up server has switched from CSV to InnoDB, and a new column for server UUIDs has been added to the table. See Backup History Table Update for the new user privileges required by mysqlbackup due to this change.
Important Change: When working with a Group Replication setup, mysqlbackup now makes the backup history available to all members of the server group by making sure that the
backup_historytable is updated on a primary node after each mysqlbackup operation. See Using MySQL Enterprise Backup with Group Replication for details.
With the implementation of this feature, the new user privilege of
performance_schema.replication_group_membersis now required by mysqlbackup to work with any server, even when it does not belong to a Group Replication setup. See Grant MySQL Privileges to Backup Administrator for details.
OAuth is now supported for Oracle Cloud Storage client authentication. Two new options,
--cloud-oauth-token, have been introduced for the purpose. See Cloud Storage Options for details.
The maximum value that could be set for the
--safe-slave-backup-timeoutoption was 2700 (seconds), which automatically replaced any larger value. With this fix, there is no longer a maximum limit, even though a high value is not recommended; see the description of
--safe-slave-backup-timeoutfor details. (Bug #27883020)
Restoring an incrementation backup on top of a data directory restored using a compressed backup failed. It was because mysqlbackup did not set
backup_variables.txtfile inside the restored data directory. (Bug #27787988)
When mysqlbackup performed sanity checks on InnoDB tablespaces and found a space ID mismatch for an FSP header and a page header, the name of the problematic tablespace was not given in the error report. (Bug #27752703)
If an ALTER TABLE statement was executed on the server before an incremental backup was taken, a server restored with the backup on which the incremental backup was applied (using the
apply-incremental-backupcommand) could not be started, as the
.ibdfile of the altered table was missing in the restored data. (Bug #27735134)
After a server has been restored using an incremental backup created with the
--incremental-with-redo-log-onlyoption, it could not be started. (Bug #27722525)
mysqlbackup issued a warning whenever the number of files specified in the system variable
innodb_data_file_pathof the server to be backed up exceeded 100. With this fix, a warning is issued only if the number of InnoDB data files to be opened exceeds the number specified by the system variable
innodb_open_files. (Bug #27701402)
Backups failed for a server that had been started with a value for
--innodb_log_file_sizedifferent from the one the server was initiated with. (Bug #27571663)
apply-incremental-backupoperation failed when individual tablespaces with relative file paths were involved. (Bug #27278876)
In a Group Replication setting for MySQL servers, when changes were made to one group member and a backup was taken on another, the relay log for the replication applier was missing from the backup, so that the restored server could not be started. (Bug #25534078)
When a compressed backup was restored with the
--innodb_data_home_diroption pointing to a restore location outside of the data directory,
.ibdfiles were still being copied into the data directory, causing an exception to be thrown at the attempt to start the restored server. (Bug #24826986)