16.1.5.3 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.
Use the 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 16.1.3.3, “GTID Auto-Positioning”). The MASTER_AUTO_POSITION
option is set to specify the use of auto-positioning.
For example, to add source1
and source2
as sources to the replica, use the mysql client to issue the CHANGE MASTER TO
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";
For the full syntax of the CHANGE MASTER TO
statement and other available options, see Section 13.4.2.1, “CHANGE MASTER TO Statement”.