|MySQL 5.5+||How To||MySQL||Configuration|
How to Clear/Reset replication in MySQL?
Sometimes it is required to Clear/Reset the existing MySQL Replication before setting up a new configuration.
This can be done using the following steps:
- Issue STOP SLAVE on the Slave node.
- Issue RESET SLAVE on the Slave and then verify that any unwanted data no longer exists on the slave.
- Issue RESET MASTER on the Master node.
- After verifying the setup and getting rid of any unwanted and log files generated, we can start the slave and begin the new configuration.
If you are experiencing issues with ScaleArc or with any of it's features, please contact ScaleArc Support. We are available 24x7 by phone at 855 800 7225 or +1 408 412 7315. For general support inquiries, you can also e-mail us at firstname.lastname@example.org.
2901 Tasman Drive Santa Clara, CA 95054 | Email: email@example.com