HiveBrain v1.2.0
Get Started
← Back to all entries
snippetsqlCritical

How do I completely disable MySQL replication

Submitted by: @import:stackexchange-dba··
0
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; (Use RESET 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.