Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 39.2Mb
PDF (A4) - 39.2Mb
PDF (RPM) - 38.5Mb
HTML Download (TGZ) - 10.9Mb
HTML Download (Zip) - 11.0Mb
HTML Download (RPM) - 9.6Mb
Man Pages (TGZ) - 223.6Kb
Man Pages (Zip) - 331.5Kb
Info (Gzip) - 3.6Mb
Info (Zip) - 3.6Mb
Excerpts from this Manual

MySQL 5.7 Reference Manual  /  ...  /  Resetting Multi-Source Replication Slaves Resetting Multi-Source Replication Slaves

The RESET SLAVE statement can be used to reset a multi-source replication slave. By default, if you use the RESET SLAVE statement on a multi-source replication slave all channels are reset. Optionally, use the FOR CHANNEL channel clause to reset only a specific channel.

  • To reset all currently configured replication channels:

  • To reset only a named channel, use a FOR CHANNEL channel clause:


For GTID-based replication, note that RESET SLAVE has no effect on the slave's GTID execution history. If you want to clear this, issue RESET MASTER on the slave.

RESET SLAVE makes the slave forget its replication position, and clears the relay log, but it does not change any replication connection parameters, such as the master host. If you want to remove these for a channel, issue RESET SLAVE ALL.

For the full syntax of the RESET SLAVE command and other available options, see Section, “RESET SLAVE Statement”.