16.1.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
clause to reset only a specific channel. channel
To reset all currently configured replication channels:
RESET SLAVE;
To reset only a named channel, use a
FOR CHANNEL
clause:channel
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 Section 13.4.2.4, “RESET SLAVE Statement”.