This is just a quick note to self as I needed to stop replication on one of the MySQL slaves today.
Steps:
- Shut down master and slave
- Change slave’s my.cnf config file by adding skip-slave-status somewhere below the [mysqld] block
- Check if this works, by bring up the slave
- Connect to the server, and do show slave status\G
- If the replication has stopped the first line should just show Slave_IO_State: If it’s still replicating it will show: Slave_IO_State: Connecting to master