# Migrate MySQL Master-Slave to Percona XtraDB Cluster

**URL:** <https://forums.percona.com/t/migrate-mysql-master-slave-to-percona-xtradb-cluster/5386>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [February 1, 2017, 2:52pm UTC](https://forums.percona.com/t/migrate-mysql-master-slave-to-percona-xtradb-cluster/5386 "2017-02-01T14:52:41Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![dfresh](https://avatars.discourse-cdn.com/v4/letter/d/ec9cab/32.png) [@dfresh](https://forums.percona.com/u/dfresh)\
**Post date:** [February 1, 2017, 2:52pm UTC](https://forums.percona.com/t/migrate-mysql-master-slave-to-percona-xtradb-cluster/5386/1 "2017-02-01T14:52:41Z")

</div>

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:

```auto
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?

---

<div class="post-metadata">

**Author:** ![jrivera](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jrivera/32/13_2.png) [@jrivera](https://forums.percona.com/u/jrivera)\
**Post date:** [February 5, 2017, 2:01am UTC](https://forums.percona.com/t/migrate-mysql-master-slave-to-percona-xtradb-cluster/5386/2 "2017-02-05T02:01:58Z")

</div>

You can change pxc\_strict\_mode to PERMISSIVE before loading the dump file, please be aware of the consequences if you change that variable though - [url][https://www.percona.com/doc/percona-xtradb-cluster/5.7/features/pxc-strict-mode.html[/url]](https://www.percona.com/doc/percona-xtradb-cluster/5.7/features/pxc-strict-mode.html%5B/url%5D)