To stop master-slave replication with MySQL, do I need to issue any commands to master?
I have two mySQL databases set up as master-slave. D开发者_如何转开发o I need to issue a command to the master to stop this replication?
From previous posts I understand that I have to issue the following commands to slave:
stop slave
reset slave
And add skip-slave-start to my.cnf
This question : https://stackoverflow.com/questions/91814/how-do-i-completely-disable-mysql-replication
Addresses master-master. I'd like a similar answer for master-slave config please. Thanks in advance!
Till bin-log
is enabled on master and server-id
is set, it can be a master to any slave as I know. You can set server-id of master to 0 for disabling replication from master side.
Check article on mysql dev
If you only want to stop replication from the master to the slave, you don't have to do anything on the master. The master can chug along happily.
Though you should note that the master will still have binary log going, but you'll probably want that. : )
精彩评论