184.108.40.206 Adding GTID-Based Sources to a Multi-Source Replica
These steps assume you have enabled GTIDs for transactions on the replication source servers using
gtid_mode=ON, created a replication user, ensured that the replica is using
TABLE based replication repositories, and provisioned the replica with data from the sources if appropriate.
CHANGE MASTER TO statement to configure a replication channel for each source on the replica (see Section 16.2.3, “Replication Channels”). The
FOR CHANNEL clause is used to specify the channel. For GTID-based replication, GTID auto-positioning is used to synchronize with the source (see Section 220.127.116.11, “GTID Auto-Positioning”). The
MASTER_AUTO_POSITION option is set to specify the use of auto-positioning.
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";