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

Migrating to Percona 5.7 from a Mysql 5.7 InnoDB Cluster

RoyBattyRoyBatty EntrantInactive User Role Novice
Can an innodb cluster continue to run while one at a time replacing each server with Percona? I presume being a drop-in replacement that percona is able to do innodb clustering after the migration is completed?

What should I know about converting it to an XtraDB Cluster afterwards?

Thanks!

Comments

  • przemekprzemek Percona Support Engineer Percona Staff Role
    Are you using MySQL Group Replication currently? From what I understand, you plan to first replace the MySQL binaries to equivalent Percona Server binaries? If so, yes, that should work and a PS node should work fine together with vanilla MySQL nodes in one Group Replication cluster. However, such setup is not well tested solution I am afraid, so best to test such migration prior trying on production.
    When it comes to PXC (and Galera replicaiton) - that's completely different solution and there is no simple in-place migration path from GR to PXC. In that case, I would suggest creating new PXC cluster, import data from existing InnoDB Cluster (GR) to it, and start async replication from one to another first.
  • RoyBattyRoyBatty Entrant Inactive User Role Novice
    Yes, I think you've got the picture. There's currently a GR setup that would likely be one-at-a-time replaced with their equivalent Percona server binaries. and then attempt to migrate the GR cluster over to a PXC cluster... but if it's a better plan to start replicating the GR cluster over to a PXC cluster am I actually gaining anything by upgrading it to Percona first or just creating extra work and a possibility of extra headaches for myself with an unnecessary step?

    Do the Percona binaries have innodb cluster improvements in stability/durability over the Mysql release?

    Thanks!
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.