http://www.linuxidc.com/Linux/2013-05/84785p2.htm http://www.linuxidc.com/Linux/2013-04/82712.htm mysql主从: 主my.cnf: binlog-format=ROW log-slave-updates=true gtid-mode=on enforce-gtid-consistency=true master-info-repository=TABLE relay-log-info-repository=TABLE sync-master-info=1 slave-parallel-workers=2 binlog-checksum=CRC32 master-verify-checksum=1 slave-sql-verify-checksum=1 binlog-rows-query-log_events=1 server-id=11 report-port=33061 log-bin=master-bin.log report-host=master.trade2cn.com innodb_flush_log_at_trx_commit=1 sync_binlog=1 从my.cnf: binlog-format=ROW log-slave-updates=true gtid-mode=on enforce-gtid-consistency=true master-info-repository=TABLE relay-log-info-repository=TABLE sync-master-info=1 slave-parallel-workers=2 binlog-checksum=CRC32 master-verify-checksum=1 slave-sql-verify-checksum=1 binlog-rows-query-log_events=1 server-id=12 report-port=33062 log-bin=slave-bin.log report-host=slave.trade2cn.com innodb_flush_log_at_trx_commit=1 sync_binlog=1 启动mysql服务器,在主从服务器查看是否启动gtid功能 主mysql->show global variables like '%gtid%';