Debian Codegraph @

mysql-test/suite/rpl/r/rpl_gtid_mdev4473.result

raw
1 include/rpl_init.inc [topology=1->2,1->3]
2 connection server_1;
3 create table t1 (n int);
4 insert into t1 values (1);
5 insert into t1 values (2);
6 connection server_3;
7 include/stop_slave.inc
8 include/wait_for_slave_to_stop.inc
9 connection server_2;
10 include/stop_slave.inc
11 include/wait_for_slave_to_stop.inc
12 reset slave all;
13 connection server_1;
14 CHANGE MASTER TO master_host = '127.0.0.1', master_port = SERVER_MYPORT_2,
15 master_user='root', master_ssl_verify_server_cert=0,
16 MASTER_USE_GTID=SLAVE_POS, master_demote_to_slave=1;
17 include/start_slave.inc
18 include/wait_for_slave_to_start.inc
19 connection server_2;
20 flush logs;
21 insert into t1 values (3);
22 insert into t1 values (4);
23 flush logs;
24 connection server_3;
25 CHANGE MASTER TO master_host = '127.0.0.1', master_port = SERVER_MYPORT_2,
26 MASTER_USE_GTID=SLAVE_POS;
27 include/start_slave.inc
28 select * from t1 order by n;
29 n
30 1
31 2
32 3
33 4
34 show binary logs;
35 Log_name File_size
36 master-bin.000001 #
37 include/show_binlog_events.inc
38 Log_name Pos Event_type Server_id End_log_pos Info
39 master-bin.000001 # Gtid # # GTID #-#-#
40 master-bin.000001 # Query # # use `test`; create table t1 (n int)
41 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
42 master-bin.000001 # Query # # use `test`; insert into t1 values (1)
43 master-bin.000001 # Query # # COMMIT
44 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
45 master-bin.000001 # Query # # use `test`; insert into t1 values (2)
46 master-bin.000001 # Query # # COMMIT
47 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
48 master-bin.000001 # Query # # use `test`; insert into t1 values (3)
49 master-bin.000001 # Query # # COMMIT
50 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
51 master-bin.000001 # Query # # use `test`; insert into t1 values (4)
52 master-bin.000001 # Query # # COMMIT
53 connection server_1;
54 include/stop_slave.inc
55 include/wait_for_slave_to_stop.inc
56 reset slave all;
57 connection server_2;
58 CHANGE MASTER TO master_host = '127.0.0.1', master_port = SERVER_MYPORT_1,
59 master_user = 'root', MASTER_USE_GTID=SLAVE_POS, master_demote_to_slave=1;
60 include/start_slave.inc
61 connection server_3;
62 include/stop_slave.inc
63 CHANGE MASTER TO master_host = '127.0.0.1', master_port = SERVER_MYPORT_1,
64 MASTER_USE_GTID=SLAVE_POS;
65 include/start_slave.inc
66 connection server_1;
67 drop table t1;
68 include/rpl_end.inc