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

Migrate MySQL Master-Slave to Percona XtraDB Cluster

dfreshdfresh EntrantInactive User Role Supporter
I've found some variations on the ways to migrate MySQL to XtraDB out there, but none of them seem to be what I'm trying to do. I have a current MySQL 5.5 master-slave configuration and a 3 node 5.7 XtraDB cluster for POC. Connectivity from the existing MySQL DB nodes to the POC XtraDB nodes isn't an option. Of course trying to import a mysqldump failed with:
ERROR 1105 (HY000) at line 53: Percona-XtraDB-Cluster prohibits use of LOCK TABLE/FLUSH TABLE <table> WITH READ LOCK with pxc_strict_mode = ENFORCING

What options are there to migrate data from an existing MySQL setup to XtraDB if direct connectivity for replication isn't an option?


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.