Documentation Home
MySQL Replication
Related Documentation Download this Excerpt
PDF (US Ltr) - 1.5Mb
PDF (A4) - 1.5Mb
HTML Download (TGZ) - 378.5Kb
HTML Download (Zip) - 392.8Kb


MySQL Replication  /  ...  /  Adding Binary Log Based Replication Masters to a Multi-Source Replication Slave

2.4.4 Adding Binary Log Based Replication Masters to a Multi-Source Replication Slave

These steps assume that binary logging is enabled on the master (which is the default), the slave is using TABLE based replication repositories (which is the default in MySQL 8.0), and that you have enabled a replication user and noted the current binary log position. You need to know the current MASTER_LOG_FILE and MASTER_LOG_POSITION.

Use the CHANGE MASTER TO statement to configure a replication channel for each master on the replication slave (see Section 5.3, “Replication Channels”). The FOR CHANNEL clause is used to specify the channel. For example, to add master1 and master2 as masters to the replication slave, use the mysql client to issue the CHANGE MASTER TO statement twice on the slave, like this:

mysql> CHANGE MASTER TO MASTER_HOST="master1", MASTER_USER="ted", MASTER_PASSWORD="password", \
MASTER_LOG_FILE='master1-bin.000006', MASTER_LOG_POS=628 FOR CHANNEL "master_1";
mysql> CHANGE MASTER TO MASTER_HOST="master2", MASTER_USER="ted", MASTER_PASSWORD="password", \
MASTER_LOG_FILE='master2-bin.000018', MASTER_LOG_POS=104 FOR CHANNEL "master_2";

For the full syntax of the CHANGE MASTER TO statement and other available options, see CHANGE MASTER TO Statement.

To make the replication slave replicate only database db1 from master1, and only database db2 from master2, use the mysql client to issue the CHANGE REPLICATION FILTER statement for each channel, like this:

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

For the full syntax of the CHANGE REPLICATION FILTER statement and other available options, see CHANGE REPLICATION FILTER Statement.