Not the answer you need?
Register and ask your own question!

Migrating from Percona server to PXC

jhbremerjhbremer EntrantCurrent User Role Beginner
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?

Comments

  • Timur SolodovnikovTimur Solodovnikov Entrant Current User Role Beginner
    jhbremer wrote: »
    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):

    1.
    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
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.