1include/rpl_init.inc [topology=1->2->1] 2# 3# For now we'll only have 1->2 running 4# 5# Server 1 6# Stop replication 2->1 7connection server_1; 8include/stop_slave.inc 9# 10# Server 2 11# Use GTID for replication 1->2 12connection server_2; 13include/stop_slave.inc 14change master to master_use_gtid=slave_pos; 15include/start_slave.inc 16# 17# Create some 0-1-* and 0-2-* events in binlog of server 2 18connection server_1; 19create table t1 (i int) engine=InnoDB; 20insert into t1 values (1); 21connection server_2; 22create table t2 (i int) engine=InnoDB; 23connection server_1; 24insert into t1 values (2); 25connection server_2; 26insert into t2 values (1); 27# 28# All events are present in the binlog of server 2 29include/show_binlog_events.inc 30Log_name Pos Event_type Server_id End_log_pos Info 31slave-bin.000001 # Gtid # # GTID #-#-# 32slave-bin.000001 # Query # # use `test`; create table t1 (i int) engine=InnoDB 33slave-bin.000001 # Gtid # # BEGIN GTID #-#-# 34slave-bin.000001 # Query # # use `test`; insert into t1 values (1) 35slave-bin.000001 # Xid # # COMMIT /* XID */ 36slave-bin.000001 # Gtid # # GTID #-#-# 37slave-bin.000001 # Query # # use `test`; create table t2 (i int) engine=InnoDB 38slave-bin.000001 # Gtid # # BEGIN GTID #-#-# 39slave-bin.000001 # Query # # use `test`; insert into t1 values (2) 40slave-bin.000001 # Xid # # COMMIT /* XID */ 41slave-bin.000001 # Gtid # # BEGIN GTID #-#-# 42slave-bin.000001 # Query # # use `test`; insert into t2 values (1) 43slave-bin.000001 # Xid # # COMMIT /* XID */ 44# 45# Server 1 46# Start replication 2->1 using GTID, 47connection server_1; 48change master to master_use_gtid=slave_pos; 49include/start_slave.inc 50select * from t1 order by i; 51i 521 532 54select * from t2 order by i; 55i 561 57connection server_2; 58select * from t1 order by i; 59i 601 612 62select * from t2 order by i; 63i 641 65connection server_1; 66drop table t1; 67connection server_2; 68drop table t2; 69include/rpl_end.inc 70