EVOLUTION-MANAGER

Edit File: rpl_gtid_mdev4473.result

include/rpl_init.inc [topology=1->2,1->3] connection server_1; create table t1 (n int); insert into t1 values (1); insert into t1 values (2); connection server_3; include/stop_slave.inc include/wait_for_slave_to_stop.inc connection server_2; include/stop_slave.inc include/wait_for_slave_to_stop.inc reset slave all; connection server_1; CHANGE MASTER TO master_host = '127.0.0.1', master_port = SERVER_MYPORT_2, master_user='root', MASTER_USE_GTID=CURRENT_POS; include/start_slave.inc include/wait_for_slave_to_start.inc connection server_2; flush logs; insert into t1 values (3); insert into t1 values (4); flush logs; connection server_3; CHANGE MASTER TO master_host = '127.0.0.1', master_port = SERVER_MYPORT_2, MASTER_USE_GTID=CURRENT_POS; include/start_slave.inc select * from t1 order by n; n 1 2 3 4 show binary logs; Log_name File_size master-bin.000001 # include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Gtid # # GTID #-#-# master-bin.000001 # Query # # use `test`; create table t1 (n int) master-bin.000001 # Gtid # # BEGIN GTID #-#-# master-bin.000001 # Query # # use `test`; insert into t1 values (1) master-bin.000001 # Query # # COMMIT master-bin.000001 # Gtid # # BEGIN GTID #-#-# master-bin.000001 # Query # # use `test`; insert into t1 values (2) master-bin.000001 # Query # # COMMIT master-bin.000001 # Gtid # # BEGIN GTID #-#-# master-bin.000001 # Query # # use `test`; insert into t1 values (3) master-bin.000001 # Query # # COMMIT master-bin.000001 # Gtid # # BEGIN GTID #-#-# master-bin.000001 # Query # # use `test`; insert into t1 values (4) master-bin.000001 # Query # # COMMIT connection server_1; include/stop_slave.inc include/wait_for_slave_to_stop.inc reset slave all; connection server_2; CHANGE MASTER TO master_host = '127.0.0.1', master_port = SERVER_MYPORT_1, master_user = 'root', MASTER_USE_GTID=CURRENT_POS; include/start_slave.inc connection server_3; include/stop_slave.inc CHANGE MASTER TO master_host = '127.0.0.1', master_port = SERVER_MYPORT_1, MASTER_USE_GTID=CURRENT_POS; include/start_slave.inc connection server_1; drop table t1; include/rpl_end.inc