Monday, August 27, 2012

Steps to take to reset slave and delete old connect info alt. break master-master seup.


On the slave server(s): 
alt.
on the Master when you want to break a master-master replication setup:

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.

Done.

No comments:

Post a Comment