Hi all.
I have a MariaDB (10.7.3) Galera cluster with multiple masters and three nodes and I want to migrate to a Percona XtraDB cluster. What is the easiest way to do this with minimal downtime?
Since MariaDB and MySQL/PXC having big differences especially around 10.0,10.2 which make it nearly hard to use as a direct drop-in-replacement so the better way to do such migration would be using the logical way (mydumper, mysqldump) or the MySQL shell utilities which comes with parallel processings like mydumper to fasten the overall process.
Based on method you choose for the logical backup/restore you can also try building a temporary async replication (MariaDB => MySQL/PXC) for the cut-over activity if it allows.
You might find this blogpost - Migrating From MariaDB to Percona Server for MySQL 8: The Security Witchcraft useful.
Well you need a through testing of all the process for a couple of times in order to decide the final path as the changes between both the versions are quite huge.
Moreover, you should be reading this before planning for the upgrade.
- List item
- List item
Ohhh. Thanks a lot for the information!!! I will read all now!!!
@anil.joshi , hi again.
I tried to add MySQL XTRADB node to running MariaDB galera cluster as slave using gtid.
After successful configuration and startup I get the following error on the slave server: “The replication receiver thread cannot start because the source has GTID_MODE = OFF and this server has GTID_MODE = ON.”
But on the master server I have the GTID mode enabled, though in maria it is called wsrep_gtid_mode.
I assume I’m running into the problem described in this thread: Integrate replication to percona operator pxc cluster frm existing mysql cluster
Am I correct in understanding that this cannot be done using asynchronous replication in my current configuration?
Thanks.