Creating a Asynchronous replica from an existing PXC

Our current setup is Mysql Server 5.5 as MASTER --> asynchronous replication --> 3 Node PXC. We are using the PXC as read only replicas right now. The PXC is receiving all updates via asynchronous replication from the existing MASTER.

I need to create a new Asynchronous slave in our office, which we use for reporting but I want it’s Master to be one of the cluster members and not the existing master as that master will be shutdown once we migrate writes to the PXC.

I haven’t seen any documentation on this setup or how to create a asynchronous replica from an existing PXC. Of note, I have an existing replica from the old master already in the office. I would love to essentially use a change master statement if possible and not recreate it from scratch as it is quite large.

Any idea how to get this done?

Many thanks.


The PXC node you want to master from obviously needs log-bin, log-slave-updates and everything else you’d normally do to setup a master.

Making a slave of it is just like making a slave of any other node: clone the master, build the slave. If you backup a cluster node, be sure it do it in a way that doesn’t invoke flow control on the cluster:

If you are migrating an existing slave of MASTER to become a slave of a PXC node without re-clone, you’d need to:

a) stop writes on MASTER, wait for PXC to catch up
b) CHANGE MASTER on slave to new PXC node’s current master binlog position
c) restart writes on MASTER

If you can’t stop writes on the MASTER, then you’ll probably have to reclone your slave.

how to configure Mysql Server 5.5 as MASTER asynchronous replication with 3 Node of PXC.

Pretty much the same way, except you setup one one in the cluster as a slave to your master with CHANGE MASTER TO. The slave in question needs log-slave-updates to replicate changes it sees from the master to the rest of the cluster.

Jay, do you happen to know if there there an existing write up on how to accomplish this with PXC? I have one stack set by Marco, but looking to set up a second set of stacks as well.

No jay i don’t want like this i need suppose i have one existing mysql server that working fine now i configure the PXC and its also working fine …but i need to configure the this that is… i need from EXISTING Mysql server data----to------PXC…thats means Existing mysql server is working in front end and pxc will work on back end…it means all entries come in existing mysql and its will diliver to pxc…is is possiable…

can you please reply for above mention problem/…

Fine, you just backup the existing mysql server and restore that on your first cluster node (the node you bootstrap). After the cluster is setup, one node in the cluster must replicate from the existing master (standard async mysql replication) as I mentioned above.

This is very similar to any HOWTO you may find on the internet about setting up a mysql slave. I cannot write you a full set of steps here.

when i am putting the the master entries in my.cnf file of pxc node the service cannot be up…here it is my.cnf file



Path to Galera library


Cluster connection URL contains IPs of node#1, node#2 and node#3


In order for Galera to work correctly binlog format should be ROW


MyISAM storage engine has only experimental support


This is a recommended tuning variable for performance


This changes how InnoDB autoincrement locks are managed and is a requirement for Galera


Node #3 address


Cluster name


SST method


#Authentication for SST method


server-id = 2

relay-log = /var/lib/mysql/mysql-relay-bin
relay-log-index = /var/lib/mysql/mysql-relay-bin.index
log-error = /var/lib/mysql/mysql.err
master-info-file = /var/lib/mysql/
relay-log-info-file = /var/lib/mysql/
log-bin = mysql-bin

can we change the data location DIR…if yes how?

please reply