MySQL Multi-Source Replication實測
一、測試環境 OS: Oracle Linux-6.5 RAM: 4G mysql-5.7.7-rc-linux-glibc2.5-x86_64 二、架構 圖2-1 架構圖 三、建置設定 設定my.cnf ### Master-3306 ### server-id=3306 relay-log-info-repository=table master-info-repository=table gtid-mode=on log-slave-updates = 1 enforce-gtid-consistency = true log-bin=ol65-bin binlog_format = mixed binlog_row_image = minimal ### Master-3322 ### server-id=3322 relay-log-info-repository=table master-info-repository=table gtid-mode=on log-slave-updates = 1 enforce-gtid-consistency = true log-bin=ol65-bin binlog_format = mixed binlog_row_image = minimal ### Slave-3377 ### server-id=3377 master-info-repository = TABLE relay-log-info-repository = TABLE gtid-mode = ON enforce-gtid-consistency = true log-slave-updates = ON log-bin ...