MySQL 8.0 Reference Manual
MySQL 8.0 Release Notes
The STOP REPLICA
statement can be
used to stop a multi-source replica. By default, if you use the
STOP REPLICA
statement on a
multi-source replica all channels are stopped. Optionally, use the
FOR CHANNEL
clause to stop only a specific channel.
channel
To stop all currently configured replication channels:
mysql> STOP SLAVE; Or from MySQL 8.0.22: mysql> STOP REPLICA;
To stop only a named channel, use a
FOR CHANNEL
clause:channel
mysql> STOP SLAVE FOR CHANNEL "source_1"; Or from MySQL 8.0.22: mysql> STOP REPLICA FOR CHANNEL "source_1";
For the full syntax of the STOP
REPLICA
command and other available options, see
STOP REPLICA Statement.