MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0
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
Section 13.4.2.7, “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