188.8.131.52 Resetting Multi-Source Replicas
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 clause to reset only a specific channel.
To reset all currently configured replication channels:
To reset only a named channel, use a
RESET SLAVE FOR CHANNEL "source_1";
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.