Restore a 5.7 backup to an 8.0 cluster¶
Use Percona XtraBackup to back up the source server data and restore the data to a target server, and then upgrade the server to a different version of Percona XtraDB Cluster.
Restore a database with a different server version¶
Review Upgrade Percona XtraDB cluster.
Upgrade the nodes one at a time. The primary node should be the last node to be upgraded. The following steps are required on each node.
Back up the data on the source server.
Install the same database version as the source server on the target server.
Restore with a
copy-backoperation on the target server.
Start the database server on the target server.
Do a slow shutdown of the database server with the
SET GLOBAL innodb_fast_shutdown=0statement. This shutdown type flushes InnoDB operations before completing and may take longer.
Install the new database server version on the target server.
Start the new database server version on the restored data directory.
Perform any other upgrade steps as necessary.
To ensure the upgrade was successful, check the data.