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!