2017年1月1日 星期日

completely disable MySQL replication

REF: http://dba.stackexchange.com/questions/21119/how-do-i-completely-disable-mysql-replication

* also 'flush slave' or 'slave stop' or 'reset master'

On the slave server(s):
  1. Run "stop slave" to stop replication.
  2. Run "reset slave" to tell the slave server to forget it's position in the binary log retrieved from the master server.
  3. Add "skip-slave-start" to my.cnf to prevent replication from starting when you restart MySQL.

沒有留言:

張貼留言