Mysql – How to change MySql Master-Master Replication to Master-Slave Replication


I currently have MySql Master-Master replication set-up with Read_only on Master2.
There were lot of sync issues so I've stopped replication from Master2 to Master1 by stopping the Slave in Master1. Master1 is currently replicating to Master2 with no issues.
Is this enough or is there another best way to revert to Master-Slave replication.
Should I run RESET SLAVE on Master1 to completely stop Replication from Master2 to Master1.

Best Answer

On a basic level, what you have done is enough, but there is a risk it could be re-enabled by mistake as long as the Binary logs exist on master2.

So, if this is just a temporary thing then running RESET SLAVE will remove the master_log_file and read_master_log_pos values, thus preventing replication from starting again by mistake, but maintaining the other values for future use.

If this is going to be permanent, then RESET SLAVE ALL will remove all the replication information (include host, port, user, password etc).