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