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.

Downgrading is not supported.

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-back operation 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=0 statement. 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.

Get expert help¶

If you need assistance, visit the community forum for comprehensive and free database knowledge, or contact our Percona Database Experts for professional support and services.

Community Forum Get a Percona Expert

Last update: 2023-09-12