How to migrate MySQL 5.7 to Percona Server for MySQL 5.7 using Xtrabackup and replication?

MySQL & MariaDB Percona XtraBackup
,
1

Hi everyone,

I’m trying to move a few MySQL 5.7 DBs to new servers and thought its a good time to switch to Percona Servers. I found this link: Migrating from MySQL 5.7 to Percona MySQL 5.7 - #2 by vadimtk

Does this work:

  • Create a new server with MySQL 5.7
  • Restore a copy of master DB using Xtrabackup
  • Start new server as a slave replica
  • Stop replication once the changes are caught up
  • Stop MySQL
  • Install Percona Server
  • Point Percona Server to MySQL data directory
  • Setup Percona Server as Master to Master replica?
  • Point production app to new Percona Server

Thank you for any suggestions.

2

Hello gtg, welcome to Percona forum! the approach works fine but you can restore the backup directly with percona server. There’s no need to go with MySQL first:

  • Create a new server with Percona 5.7
  • Restore a copy of master DB using Xtrabackup
  • Start new server as a slave replica
  • Stop old server
  • Point production app to new Percona Server
3

Hi Ivan,
Thank you for the quick reply. That is good. I will skip installing MySQL.
When I upgrade from Ubuntu 18.04 to 20.04, will Percona server get upgraded to 8 automatically?

4

Hi, Percona Server will not be upgraded as part of OS upgrade. You will need to do that separately.