Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3;
4 START SLAVE;
5 connection node_1;
6 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
7 INSERT INTO t1 VALUES(1);
8 # Disable binary logging for current session
9 SET SQL_LOG_BIN=OFF;
10 CREATE TABLE t2 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
11 INSERT INTO t2 VALUES(1);
12 INSERT INTO t1 VALUES(2);
13 CREATE TABLE test.t3 AS SELECT * from t1;
14 SET SQL_LOG_BIN=ON;
15 INSERT INTO t1 VALUES(3);
16 CREATE TABLE test.t4 AS SELECT * from t1;
17 connection node_2;
18 SELECT * FROM t1;
19 f1
20 1
21 2
22 3
23 SELECT * FROM t2;
24 f1
25 1
26 SELECT * FROM t3;
27 f1
28 1
29 2
30 SELECT * FROM t4;
31 f1
32 1
33 2
34 3
35 connection node_3;
36 SHOW TABLES;
37 Tables_in_test
38 t1
39 t4
40 SELECT * FROM t1;
41 f1
42 1
43 3
44 SELECT * FROM t4;
45 f1
46 1
47 2
48 3
49 # Cleanup
50 connection node_1;
51 DROP TABLE t1, t4;
52 SET SQL_LOG_BIN=OFF;
53 DROP TABLE t2, t3;
54 connection node_3;
55 BINLOG_POSITIONS_MATCH
56 1
57 STOP SLAVE;
58 RESET SLAVE ALL;
59 CALL mtr.add_suppression('You need to use --log-bin to make --binlog-format work');
60 connection node_1;
61 set global wsrep_on=OFF;
62 RESET MASTER;
63 set global wsrep_on=ON;