MySQL 8.0 Release Notes
MySQL 8.0 Source Code Documentation
TheSTOP REPLICA
statement can be used to stop a multi-source replica. By default, if you use theSTOP REPLICA
statement on a multi-source replica all channels are stopped. Optionally, use theFOR 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 theSTOP REPLICA
command and other available options, seeSection 13.4.2.10, “STOP REPLICA Statement”.