diff options
Diffstat (limited to 'mysql-test/suite/rpl/r/rpl_gtid_mdev4473.result')
| -rw-r--r-- | mysql-test/suite/rpl/r/rpl_gtid_mdev4473.result | 67 |
1 files changed, 67 insertions, 0 deletions
diff --git a/mysql-test/suite/rpl/r/rpl_gtid_mdev4473.result b/mysql-test/suite/rpl/r/rpl_gtid_mdev4473.result new file mode 100644 index 00000000..9524dafb --- /dev/null +++ b/mysql-test/suite/rpl/r/rpl_gtid_mdev4473.result @@ -0,0 +1,67 @@ +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=SLAVE_POS, master_demote_to_slave=1; +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=SLAVE_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=SLAVE_POS, master_demote_to_slave=1; +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=SLAVE_POS; +include/start_slave.inc +connection server_1; +drop table t1; +include/rpl_end.inc |