Debian Codegraph @

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

raw
1 include/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
7 connection server_1;
8 include/stop_slave.inc
9 #
10 # Server 2
11 # Use GTID for replication 1->2
12 connection server_2;
13 include/stop_slave.inc
14 change master to master_use_gtid=slave_pos;
15 include/start_slave.inc
16 #
17 # Create some 0-1-* and 0-2-* events in binlog of server 2
18 connection server_1;
19 create table t1 (i int) engine=InnoDB;
20 insert into t1 values (1);
21 connection server_2;
22 create table t2 (i int) engine=InnoDB;
23 connection server_1;
24 insert into t1 values (2);
25 connection server_2;
26 insert into t2 values (1);
27 #
28 # All events are present in the binlog of server 2
29 include/show_binlog_events.inc
30 Log_name Pos Event_type Server_id End_log_pos Info
31 slave-bin.000001 # Gtid # # GTID #-#-#
32 slave-bin.000001 # Query # # use `test`; create table t1 (i int) engine=InnoDB
33 slave-bin.000001 # Gtid # # BEGIN GTID #-#-#
34 slave-bin.000001 # Query # # use `test`; insert into t1 values (1)
35 slave-bin.000001 # Xid # # COMMIT /* XID */
36 slave-bin.000001 # Gtid # # GTID #-#-#
37 slave-bin.000001 # Query # # use `test`; create table t2 (i int) engine=InnoDB
38 slave-bin.000001 # Gtid # # BEGIN GTID #-#-#
39 slave-bin.000001 # Query # # use `test`; insert into t1 values (2)
40 slave-bin.000001 # Xid # # COMMIT /* XID */
41 slave-bin.000001 # Gtid # # BEGIN GTID #-#-#
42 slave-bin.000001 # Query # # use `test`; insert into t2 values (1)
43 slave-bin.000001 # Xid # # COMMIT /* XID */
44 #
45 # Server 1
46 # Start replication 2->1 using GTID,
47 connection server_1;
48 change master to master_use_gtid=slave_pos;
49 include/start_slave.inc
50 select * from t1 order by i;
51 i
52 1
53 2
54 select * from t2 order by i;
55 i
56 1
57 connection server_2;
58 select * from t1 order by i;
59 i
60 1
61 2
62 select * from t2 order by i;
63 i
64 1
65 connection server_1;
66 drop table t1;
67 connection server_2;
68 drop table t2;
69 include/rpl_end.inc