Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 35.1Mb
PDF (A4) - 35.2Mb
Man Pages (TGZ) - 256.4Kb
Man Pages (Zip) - 361.2Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

16.1.5.5 Starting Multi-Source Replicas

Once you have added channels for all of the sources, issue aSTART SLAVE statement to start replication. When you have enabled multiple channels on a replica, you can choose to either start all channels, or select a specific channel to start. For example, to start the two channels separately, use themysql client to issue the following statements:

mysql> START SLAVE FOR CHANNEL "source_1";mysql> START SLAVE FOR CHANNEL "source_2";

For the full syntax of theSTART SLAVE command and other available options, seeSection 13.4.2.5, “START SLAVE Statement”.

To verify that both channels have started and are operating correctly, you can issueSHOW SLAVE STATUS statements on the replica, for example:

mysql> SHOW SLAVE STATUS FOR CHANNEL "source_1"\Gmysql> SHOW SLAVE STATUS FOR CHANNEL "source_2"\G