Re: How to disable replication for master/slave

[Rick James]

> virtualize this environment with only one server
What do you mean?

To stop replication:
STOP SLAVE;
(on slave)
Assuming nothing else is disrupted, START SLAVE will have replication continue where it left off, and the Slave will soon be caught up.

The Master does not care if the Slave(s) are stopped.
Turning off log_bin would prevent the Master from writing out stuff that the Slave needs.

> take an image of the master
Stop mysqld. At that point mysql's directory can be copied to another machine. If this is to make a Slave, there are a few more steps:
* makes sure server_id (in my.cnf) is different on each machine
* turn on log_bin (on Master)
* run CHANGE MASTER on the Slave (after starting it up).
* (Read the online pages about replication; I may have forgotten something).

Those pages are far more verbose than I have been. But I have given you about all that is relevant.