Can I create Percona XtraDB Cluster on existing standalone MySQL database (non-Percona)?

MySQL & MariaDB Percona XtraDB Cluster 8.x
2

Hello @M00n1 ,
Welcome to Percona! Yes, you can do this. Percona MySQL is a drop-in replacement for Community MySQL. Here’s what you need to do:

  1. Stop existing mysql
  2. Remove mysql packages (this does not remove data)
  3. install Percona XtraDB Cluster package for same exact version you were running
  4. Configure wsrep parameters in my.cnf
  5. Start PXC on this node in bootstrap mode
  6. create node2. install pxc packages. configure my.cnf. start mysql normally. it will join node1 and sync the dataset.
  7. repeat for node3
2 Likes