多源复制

多个主复制到一个从



多源复制

1：从服务器配置
#vi /etc/my.cnf
[mysqld]
master-info-repository=TABLE
relay-log-info-repository=TABLE


2：配置过mysql复制的机器,清理master

mysql> reset master;



3：从服务器配置复制连接(基于GTID)
mysql> change master to master_host='192.168.31.3', master_user='repl', master_password='www.c1688.CC',master_auto_position=1 for channel 'master03';
mysql> change master to master_host='192.168.31.4', master_user='repl', master_password='www.c1688.CC',master_auto_position=1 for channel 'master04';




4:启动线程（两种启动方式）
mysql> start slave;                    
mysql> start slave thread_types;
  启动命名通道线程
mysql> start slave thread_types for channel 'master03';
mysql> start slave thread_types for channel 'master04';