I have to migrate MySQL server to a different data center so I would like to create another MySQL slave server in new DC and then promote it to a master later on. I previously used LVM snapshots and Percona XtraBackup for this purpose. However, this time I have optimized the MySQL configuration file that prevents me from using these methods.
Old server (backup): innodb_log_file_size = 256M innodb_log_files_in_group = 3 New server (restore): innodb_log_file_size = 512M innodb_log_files_in_group = 2
The XtraBackup script and LVM snapshots copy the whole directory structure so the MySQL server won't start because there is a different size for InnoDB logs.
Is there any solution to avoid a downtime in this case? I can't use mysqldumps because there are around 8000 databases. That being the case, I would have to take the server down for a couple of hours.
I was also thinking to use the old settings with XtraBackup and then change it once the new server is promoted to a master - less downtime but I'm not sure if this will work?