Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 35.1Mb
PDF (A4) - 35.2Mb
Man Pages (TGZ) - 256.4Kb
Man Pages (Zip) - 361.2Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

MySQL 5.7 Reference Manual  / ...  / Replication  / Configuring Replication  / MySQL Multi-Source Replication  /  Resetting Multi-Source Replicas

16.1.5.7 Resetting Multi-Source Replicas

TheRESET SLAVE statement can be used to reset a multi-source replica. By default, if you use theRESET SLAVE statement on a multi-source replica all channels are reset. Optionally, use theFOR CHANNELchannel clause to reset only a specific channel.

  • To reset all currently configured replication channels:

    RESET SLAVE;

  • To reset only a named channel, use aFOR CHANNELchannel clause:

    RESET SLAVE FOR CHANNEL "source_1";

For GTID-based replication, note thatRESET SLAVE has no effect on the replica's GTID execution history. If you want to clear this, issueRESET MASTER on the replica.

RESET SLAVE makes the replica forget its replication position, and clears the relay log, but it does not change any replication connection parameters, such as the source's host name. If you want to remove these for a channel, issueRESET SLAVE ALL.

For the full syntax of theRESET SLAVE command and other available options, seeSection 13.4.2.3, “RESET SLAVE Statement”.