Related Documentation Download this Manual
PDF (US Ltr) - 40.0Mb
PDF (A4) - 40.1Mb
Man Pages (TGZ) - 259.0Kb
Man Pages (Zip) - 366.2Kb
Info (Gzip) - 4.0Mb
Info (Zip) - 4.0Mb
PDF (A4) - 40.1Mb
Man Pages (TGZ) - 259.0Kb
Man Pages (Zip) - 366.2Kb
Info (Gzip) - 4.0Mb
Info (Zip) - 4.0Mb
MySQL 9.0 Reference Manual / ... / Replication / Configuring Replication / MySQL Multi-Source Replication / Starting Multi-Source Replicas
Once you have added channels for all of the replication sources, issue aSTART REPLICA 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 REPLICA FOR CHANNEL "source_1";mysql> START REPLICA FOR CHANNEL "source_2"; For the full syntax of theSTART REPLICA statement and other available options, seeSection 15.4.2.4, “START REPLICA Statement”.
To verify that both channels have started and are operating correctly, you can issueSHOW REPLICA STATUS statements on the replica, for example:
mysql> SHOW REPLICA STATUS FOR CHANNEL "source_1"\Gmysql> SHOW REPLICA STATUS FOR CHANNEL "source_2"\GRelated Documentation Download this Manual
PDF (US Ltr) - 40.0Mb
PDF (A4) - 40.1Mb
Man Pages (TGZ) - 259.0Kb
Man Pages (Zip) - 366.2Kb
Info (Gzip) - 4.0Mb
Info (Zip) - 4.0Mb
PDF (A4) - 40.1Mb
Man Pages (TGZ) - 259.0Kb
Man Pages (Zip) - 366.2Kb
Info (Gzip) - 4.0Mb
Info (Zip) - 4.0Mb