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";
For GTID-based replication, note that
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,
RESET SLAVE ALL.
For the full syntax of the
SLAVE command and other available options, see
Section 18.104.22.168, “RESET SLAVE Statement”.