Documentation Home
MySQL Replication
Related Documentation Download this Excerpt
PDF (US Ltr) - 1.5Mb
PDF (A4) - 1.5Mb
HTML Download (TGZ) - 354.4Kb
HTML Download (Zip) - 360.7Kb


MySQL Replication  /  ...  /  Starting Multi-Source Replicas

2.5.5 Starting Multi-Source Replicas

Once you have added channels for all of the replication sources, issue a START REPLICA | 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 the mysql client to issue the following statements:

mysql> START SLAVE FOR CHANNEL "source_1";
mysql> START SLAVE FOR CHANNEL "source_2";
Or from MySQL 8.0.22:
mysql> START REPLICA FOR CHANNEL "source_1";
mysql> START REPLICA FOR CHANNEL "source_2";

For the full syntax of the START REPLICA | SLAVE command and other available options, see START REPLICA | SLAVE Statement.

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

mysql> SHOW SLAVE STATUS FOR CHANNEL "source_1"\G
mysql> SHOW SLAVE STATUS FOR CHANNEL "source_2"\G
Or from MySQL 8.0.22:
mysql> SHOW REPLICA STATUS FOR CHANNEL "source_1"\G
mysql> SHOW REPLICA STATUS FOR CHANNEL "source_2"\G