How to reset/clear and MySQL Replication

It’s always a concern where we need to disconnect a slave from it’s master. One of the key things to protect your data integrity is to make sure that the disconnected slave is permanently disconnected from its old master. If not, it may get writes from the old master, which can cause all kinds of data corruption.

How to reset/clear and MySQL replicationwe can use RESET SLAVE ALL to remove all replication-related configuration:

Note: All relay log files will be deleted, even if they have not been completely executed by the slave SQL thread. (This is a condition likely to exist on a replication slave if you have issued a STOP SLAVE statement or if the slave is highly loaded.)

Here i’m going to explain, step’s to reset/clear MySQL (Master-Slave) replication in MySQL 5.5 and Above.

First Connect to the Slave Server.
How to reset/clear and MySQL ReplicationStop the Slave server, Using below commands.
How to reset/clear and MySQL ReplicationUse the below command to reset the slave configuration.
How to reset/clear and MySQL ReplicationNow, check the slave status, its shows empty.
How to reset/clear and MySQL Replication
That’s it. Now, you have successfully cleared the mysql replication and now slave server is isolated from the master server.

<<Click here to see all posts>>

If you found any of the information on this page helpful in anyway then please consider sharing this content with your favorite social network or by leaving your thoughts in the comment section. Thanks!

Leave a Reply

Your email address will not be published. Required fields are marked *

Prove You Are Human Time limit is exhausted. Please reload CAPTCHA.