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.
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.
Stop the Slave server, Using below commands.
Use the below command to reset the slave configuration.
Now, check the slave status, its shows empty.
That’s it. Now, you have successfully cleared the mysql replication and now slave server is isolated from the master server.
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!