Documentation Home
MySQL 9.4 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 41.2Mb
PDF (A4) - 41.3Mb
Man Pages (TGZ) - 262.8Kb
Man Pages (Zip) - 368.8Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb


19.1.5.6 Stopping Multi-Source Replicas

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 CHANNELchannel clause to stop only a specific channel.

  • To stop all currently configured replication channels:

    mysql> STOP REPLICA;

  • To stop only a named channel, use aFOR CHANNELchannel clause:

    mysql> STOP REPLICA FOR CHANNEL "source_1";

For the full syntax of theSTOP REPLICA statement and other available options, seeSection 15.4.2.5, “STOP REPLICA Statement”.