Setting up a new MySQL 5.5 (Percona) Slave by Simpy cloning an existing slave

It’s a bit more involved than simply cloning and being done with it, but it’s not too bad. The problem really only happen if you change the host name of the cloned server. This is specifically with Percona XtraDB 5.6.15-rel63.0.

– clone the VM

– nano /etc/my.cnf
– change the serverid to something different, just in case

– nano /var/lib/mysql/auto.cnf
– change the server-uuid somehow (just change any ol’ “a” to “b”… this is a guid, it’s arbitrary anyways). If you don’t, you’ll get this message spamming the logs: “Slave: received end packet from server, apparent master shutdown:”

– nano /var/lib/mysql/relay-log.inf
– change the name of the relay-bin file name (in my case it was still pointed at the previous host name.

Restart the mysql service and then check the error log here: /var/log/mysqld.log (or wherever your install has logs)

I think that’s everything… Hope it helps.

This pointed me in the right direction with the “received end packet….” thing: http://www.megalinux.net/solution-received-end-packet-from-server-apparent-master-shutdown/