Migrating from Percona server to PXC

[jhbremer]

Hi - I’m looking to migrate a Percona server (currently master->slave->slave setup on version 5.5) to PXC. My questions are in regards to the MySQL datadir: can I simply uninstall Percona Server (using yum for example) and install PXC on the machines I’m migrating? Will the /var/lib/mysql remain intact?

I’ve tested this in a dev environment and it seemed to work fine (even going from Percona server 5.5 to PXC 5.7). All the data was intact after migration. I was wondering if there was anything I should be concerned about. Also would it be more prudent to install 5.5, then upgrade PXC to 5.6 and then 5.7?

[Timur_Solodovnikov]

@jhbremer;48977

Hi - I’m looking to migrate a Percona server (currently master->slave->slave setup on version 5.5) to PXC. My questions are in regards to the MySQL datadir: can I simply uninstall Percona Server (using yum for example) and install PXC on the machines I’m migrating? Will the /var/lib/mysql remain intact?

I’ve tested this in a dev environment and it seemed to work fine (even going from Percona server 5.5 to PXC 5.7). All the data was intact after migration. I was wondering if there was anything I should be concerned about. Also would it be more prudent to install 5.5, then upgrade PXC to 5.6 and then 5.7?

PXC can work as standalone Percona server with native replication. Replacing binaries will work.

about migration: I would work by plan below(of cource should be tested on staging):

upgrade to 5.6 slave2, start replication
upgrade to 5.6 slave1, start replication
upgrade to 5.6 master
2.
upgrade to 5.7 slave2, start replication
upgrade to 5.7 slave1, start replication
upgrade to 5.7 master
3. Promote master to PXC
4. Join slave2 to cluster
5. Join Slave1 to cluster