This section assumes you have enabled GTID based transactions on
the master using
enabled a replication user, and ensured that the slave is using
TABLE based replication repositories. Use the
CHANGE MASTER TO statement to add
a new master to a channel by using a
clause. For more
information on replication channels, see
Section 5.3, “Replication Channels”
For example, to add a new master with the host name
master1 using port
3451 to a channel called
CHANGE MASTER TO MASTER_HOST='master1', MASTER_USER='rpl', MASTER_PORT=3451, MASTER_PASSWORD='', \ MASTER_AUTO_POSITION = 1 FOR CHANNEL 'master-1';
Multi-source replication is compatible with auto-positioning. See CHANGE MASTER TO Syntax for more information.
Repeat this process for each extra master that you want to add to a channel, changing the host name, port and channel as appropriate.