MySQL 5.7 Reference Manual
MySQL 5.7 Release Notes
These steps assume that you have enabled binary logging on the
replication source server using
--log-bin, the replica is using
TABLE based replication metadata repositories,
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 source on the replica
(see Section 5.2, “Replication Channels”). The FOR
CHANNEL clause is used to specify the channel. 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_LOG_FILE='source1-bin.000006', MASTER_LOG_POS=628 FOR CHANNEL "source_1";
mysql> CHANGE MASTER TO MASTER_HOST="source2", MASTER_USER="ted", MASTER_PASSWORD="password", \
MASTER_LOG_FILE='source2-bin.000018', MASTER_LOG_POS=104 FOR CHANNEL "source_2";
For the full syntax of the CHANGE MASTER
TO statement and other available options, see
CHANGE MASTER TO Statement.