REPLICA statement can be used to reset a multi-source
replica. By default, if you use the
REPLICA 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:
mysql> RESET SLAVE; Or from MySQL 8.0.22: mysql> RESET REPLICA;
To reset only a named channel, use a
mysql> RESET SLAVE FOR CHANNEL "source_1"; Or from MySQL 8.0.22: mysql> RESET REPLICA FOR CHANNEL "source_1";
For GTID-based replication, note that
REPLICA has no effect on the replica's GTID execution
history. If you want to clear this, issue
RESET MASTER on the replica.
REPLICA 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,
For the full syntax of the
command and other available options, see
Section 22.214.171.124, “RESET REPLICA Statement”.