snippetsqlCritical
How do I completely disable MySQL replication
Viewed 0 times
completelydisablereplicationmysqlhow
Problem
I am running dual master MySQL replication and now want to move to a single database with no replication. How do I completely disable replication on both databases?
Solution
To completely disable replication with a master-master setup, you should do the following on each slave:
STOP SLAVE;
RESET SLAVE;(UseRESET SLAVE ALL;for MySQL 5.5.16 and later)
- Edit the my.cnf and remove any information (if present) which refers to "master-..." or "replicate-..." options. You may not have anything in the my.cnf, since replication can be setup dynamically as well.
- Restart mysqld.
Context
StackExchange Database Administrators Q#21119, answer score: 104
Revisions (0)
No revisions yet.