I used replication to migrate all data to a new server, and then I commented out master_host,master_port etc(basically all lines related to master) in my.cnf, I issued stop slave.
However I after restarted mysqld, the replication process is running again! how to stop it for good.
Mysql – thesql stop slave forever
MySQLreplication
Related Topic
- Mysql – Master master replication in thesql
- Mysql – Automated failover strategy for master-slave Mysql replication – why would this not work
- Mysql – Setup a thesql replication, but new data are not updated
- Mysql – How to reset thesql’s replication settings completely, without reinstalling it
- MySQL master-slave replication not updating
Best Answer
The proper way to do this is
stop slave; reset slave;
The 'reset slave' is the part that will wipe the config and keep it from reconnecting.