Xtrabackup tool compactivity for MySQL version upgrade

MySQL & MariaDB Percona XtraBackup
1

Hi Team,

We are in the process of upgrading the MySQL community version from 5.7 to 8.0 latest. We are planning to use Percona xtrabackup tool to copy the data from 5.7 to 8.0 servers. Let me know the possibilities to use this tool for this purpose. Can we take the backup from MySQL 5.7 server with xtrabqckup2.4 and restore that backup file in 8.0 server using xtrabackup8.0 version ?

Thanks,
Sujith VG.

2

Hello Sujith,

No, you can not restore backup from PXB 2.4 using PXB 8.0. you would need PXB 2.4 to restore.

PXB 2.4 backup + PXB 2.4 prepare + PXB 2.4 restore will give you a 5.7 data dir which you can upgrade to 8.0 using the standard approach.