Migration from MySQL 5.5 (FreeBSD 9.1) to MySQL 8.0 using Percona XtraBackup 2.4

MySQL & MariaDB Percona XtraBackup
,
1

Hello!

I am planning to migrate a database from a server running MySQL 5.5 (InnoDB) to a new version, MySQL 8.0. For this purpose, I intend to use Percona XtraBackup 2.4 . Below are the details of my current configuration:

Current Configuration:
Operating System: FreeBSD 9.1
MySQL Version: 5.5.40
Table Type: InnoDB
Backup will be performed using Percona XtraBackup 2.4 .
Goal:
To transfer the data to a new server with MySQL 8.0 and set up replication between the old and new servers for a smooth transition.

Questions:
Is it possible to successfully perform such a migration using Percona XtraBackup 2.4? Are there any known limitations or issues when migrating from MySQL 5.5 to MySQL 8.0?
What additional steps are recommended to minimize the risk of data loss or format incompatibilities?
Considering that the operating system, FreeBSD 9.1, is outdated, could this affect the functionality of Percona XtraBackup or the migration process itself?
I would appreciate any advice or recommendations to optimize the migration process.

Thank you!

2

I would not recommend this, and this does not follow established best-practices. Jumping that many versions is not supported via binary upgrade (ie: xtrabackup). You should upgrade using a logical backup (ie: mydumper).

Create a new MySQL 8, restore the logical backup, then set up replication.

1 Like
3

I would also advise to move to 5.7 first and check query behaviour and performance
Then while on 5.7 run https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-shell-utilities-upgrade.html as there are many high impact changes as well

1 Like