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
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 host name) or replication filters. If you want to remove
these for a channel, issue
RESET SLAVE ALL.