Movatterモバイル変換

These steps assume you have enabled GTIDs for transactions on the sources usinggtid_mode=ON, created a replication user, ensured that the replica is usingTABLE based replication applier metadata repositories, and provisioned the replica with data from the sources if appropriate.

Use theCHANGE REPLICATION SOURCE TO statement (from MySQL 8.0.23) orCHANGE MASTER TO statement (before MySQL 8.0.23) to configure a replication channel for each source on the replica (seeSection 19.2.2, “Replication Channels”). TheFOR CHANNEL clause is used to specify the channel. For GTID-based replication, GTID auto-positioning is used to synchronize with the source (seeSection 19.1.3.3, “GTID Auto-Positioning”). TheSOURCE_AUTO_POSITION |MASTER_AUTO_POSITION option is set to specify the use of auto-positioning.

For example, to addsource1 andsource2 as sources to the replica, use themysql client to issue the statement twice on the replica, like this:

mysql> CHANGE MASTER TO MASTER_HOST="source1", MASTER_USER="ted", \MASTER_PASSWORD="password", MASTER_AUTO_POSITION=1 FOR CHANNEL "source_1";mysql> CHANGE MASTER TO MASTER_HOST="source2", MASTER_USER="ted", \MASTER_PASSWORD="password", MASTER_AUTO_POSITION=1 FOR CHANNEL "source_2";Or from MySQL 8.0.23:mysql> CHANGE REPLICATION SOURCE TO SOURCE_HOST="source1", SOURCE_USER="ted", \SOURCE_PASSWORD="password", SOURCE_AUTO_POSITION=1 FOR CHANNEL "source_1";mysql> CHANGE REPLICATION SOURCE TO SOURCE_HOST="source2", SOURCE_USER="ted", \SOURCE_PASSWORD="password", SOURCE_AUTO_POSITION=1 FOR CHANNEL "source_2";

To make the replica replicate only databasedb1 fromsource1, and only databasedb2 fromsource2, use themysql client to issue theCHANGE REPLICATION FILTER statement for each channel, like this:

mysql> CHANGE REPLICATION FILTER REPLICATE_WILD_DO_TABLE = ('db1.%') FOR CHANNEL "source_1";mysql> CHANGE REPLICATION FILTER REPLICATE_WILD_DO_TABLE = ('db2.%') FOR CHANNEL "source_2";

For the full syntax of theCHANGE REPLICATION FILTER statement and other available options, seeSection 15.4.2.2, “CHANGE REPLICATION FILTER Statement”.