Debian Codegraph @

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

raw
1 #
2 # MDEV-9044 : Getting binlog corruption on my Galera cluster (10.1.8)
3 # making it impossible to async slave.
4 #
5 connection node_2;
6 connection node_1;
7 connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3;
8 START SLAVE;
9 connection node_1;
10 SELECT @@GLOBAL.BINLOG_CACHE_SIZE;
11 @@GLOBAL.BINLOG_CACHE_SIZE
12 8192
13 CREATE TABLE t1 (c1 INTEGER PRIMARY KEY, c2 VARCHAR(12000)) ENGINE=INNODB;
14 CREATE TABLE t2 (c1 INTEGER PRIMARY KEY) ENGINE=INNODB;
15 START TRANSACTION;
16 INSERT INTO t1 VALUES(1, REPEAT('-', 10000));
17 COMMIT;
18 INSERT INTO t2 VALUES(1);
19 connection node_2;
20 SELECT c1, LENGTH(c2) FROM t1;
21 c1 LENGTH(c2)
22 1 10000
23 SELECT * FROM t2;
24 c1
25 1
26 connection node_3;
27 SELECT c1, LENGTH(c2) FROM t1;
28 c1 LENGTH(c2)
29 1 10000
30 SELECT * FROM t2;
31 c1
32 1
33 # Cleanup
34 connection node_1;
35 DROP TABLE t1, t2;
36 connection node_3;
37 STOP SLAVE;
38 RESET SLAVE ALL;