Debian Codegraph @

mysql-test/suite/rpl/t/rpl_gtid_mdev4474.test

raw
1 --source include/have_innodb.inc
2 --source include/have_binlog_format_mixed_or_statement.inc
3 --let $rpl_topology=1->2->1
4 --source include/rpl_init.inc
5
6 --echo #
7 --echo # For now we'll only have 1->2 running
8
9 --echo #
10 --echo # Server 1
11 --echo # Stop replication 2->1
12 --connection server_1
13 --source include/stop_slave.inc
14
15 --echo #
16 --echo # Server 2
17 --echo # Use GTID for replication 1->2
18 --connection server_2
19 --source include/stop_slave.inc
20 change master to master_use_gtid=slave_pos;
21 --source include/start_slave.inc
22
23 --echo #
24 --echo # Create some 0-1-* and 0-2-* events in binlog of server 2
25
26 --connection server_1
27 create table t1 (i int) engine=InnoDB;
28 insert into t1 values (1);
29 --save_master_pos
30
31 --connection server_2
32 --sync_with_master
33 create table t2 (i int) engine=InnoDB;
34 --save_master_pos
35
36 --connection server_1
37 insert into t1 values (2);
38 --save_master_pos
39
40 --connection server_2
41 --sync_with_master
42 insert into t2 values (1);
43 --save_master_pos
44
45 --echo #
46 --echo # All events are present in the binlog of server 2
47
48 --source include/show_binlog_events.inc
49
50 --echo #
51 --echo # Server 1
52 --echo # Start replication 2->1 using GTID,
53
54 --connection server_1
55 change master to master_use_gtid=slave_pos;
56 --source include/start_slave.inc
57 --sync_with_master
58
59 select * from t1 order by i;
60 select * from t2 order by i;
61
62 --connection server_2
63 select * from t1 order by i;
64 select * from t2 order by i;
65
66 --connection server_1
67 drop table t1;
68
69 --connection server_2
70 drop table t2;
71
72 --source include/rpl_end.inc