Cloning a VM to add a new MySQL Slave
- by Ben Holness
I am in the process of adding a new slave to a replicated mysql setup. All of the slave nodes are virtual machines.
If I clone one of the nodes to a new VM, then start it with no networking, stop mysql, change the server-id in my.cnf to a new id and then restart mysql and networking, will it all work correctly, or will mysql get confused because it used to be a different server id?
OS: Ubuntu 10.10
VM Platform: VMWare 5
MySQL : Server version: 5.1.49-1ubuntu8.1-log (Ubuntu)