Http://www.linuxidc.com/Linux/2013-05/84785p2.htm
Http://www.linuxidc.com/Linux/2013-04/82712.htm
MySQL Master/Slave:
Master 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
From 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
Start the MySQL server and check whether the gtid function is enabled on the Master/Slave server.
Master mysql-> show global variables like '% gtid % ';