Debian Codegraph @

mysql-test/suite/galera/r/galera_gtid_slave.result

raw
1 connection node_2;
2 connection node_1;
3 connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3;
4 connection node_2;
5 START SLAVE;
6 connection node_3;
7 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
8 CREATE TABLE t2 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
9 INSERT INTO t1 VALUES(1);
10 begin;
11 insert into t2 values(21);
12 insert into t2 values(22);
13 commit;
14 SELECT @@global.gtid_binlog_state;
15 @@global.gtid_binlog_state
16 2-3-4
17 connection node_2;
18 INSERT INTO t1 VALUES(2);
19 INSERT INTO t1 VALUES(3);
20 SELECT @@global.gtid_binlog_state;
21 @@global.gtid_binlog_state
22 1-1-2,2-3-4
23 connection node_1;
24 INSERT INTO t1 VALUES(4);
25 SELECT @@global.gtid_binlog_state;
26 @@global.gtid_binlog_state
27 1-1-3,2-3-4
28 connection node_3;
29 DROP TABLE t1,t2;
30 connection node_2;
31 connection node_1;
32 connection node_2;
33 STOP SLAVE;
34 RESET SLAVE ALL;
35 SET GLOBAL wsrep_on=OFF;
36 reset master;
37 SET GLOBAL wsrep_on=ON;
38 connection node_1;
39 SET GLOBAL wsrep_on=OFF;
40 reset master;
41 SET GLOBAL wsrep_on=ON;
42 connection node_3;
43 reset master;
44 connection node_2;
45 CALL mtr.add_suppression("Ignoring server id .* for non bootstrap node");