Documentation Home
MySQL Replication
Related Documentation Download this Excerpt
PDF (US Ltr) - 1.4Mb
PDF (A4) - 1.4Mb
HTML Download (TGZ) - 327.9Kb
HTML Download (Zip) - 334.2Kb


MySQL Replication  /  ...  /  Resetting Multi-Source Replicas

2.5.7 Resetting Multi-Source Replicas

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

  • To reset all currently configured replication channels:

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

    RESET SLAVE FOR CHANNEL "source_1";

For GTID-based replication, note that RESET SLAVE has no effect on the replica's GTID execution history. If you want to clear this, issue RESET 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, issue RESET SLAVE ALL.

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