10bet网址
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr)- 41.9Mb
PDF (A4)- 42.0Mb
Man Pages (TGZ)- 266.4Kb
Man Pages (Zip)- 376.1Kb
Info (Gzip)- 4.0Mb
Info (Zip)- 4.0Mb
Excerpts from this Manual

17.1.5.5 Starting Multi-Source Replicas

Once you have added channels for all of the replication sources, issue aSTART REPLICA(or before MySQL 8.0.22,START SLAVE)语句开始复制。当你在abled 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 themysqlclient 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 theSTART REPLICAcommand and other available options, seeSection 13.4.2.8, “START REPLICA Statement”.

To verify that both channels have started and are operating correctly, you can issueSHOW REPLICA STATUSstatements 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