This section explains how to configure a multi-source replication topology, and provides details about configuring masters and slaves. Such a topology requires at least two masters and one slave configured.
Masters in a multi-source replication topology can be configured to use either global transaction identifier (GTID) based replication, or binary log position-based replication. See Section 2.3.4, “Setting Up Replication Using GTIDs” for how to configure a master using GTID based replication. See Section 2.2.1, “Setting the Replication Master Configuration” for how to configure a master using file position based replication.
Slaves in a multi-source replication topology require
TABLE based repositories. Multi-source
replication is not compatible with
repositories. The type of repository being used by
mysqld can be configured either at startup,
To configure the type of repository used by a replication slave at startup, start mysqld with the following options:
To modify an existing replication slave that is using a
FILE repository to use
TABLE repositories, convert the existing
replication repositories dynamically by running the following
STOP SLAVE; SET GLOBAL master_info_repository = 'TABLE'; SET GLOBAL relay_log_info_repository = 'TABLE';