Debian Codegraph @

mysql-test/suite/galera/t/galera_as_master_large.test

raw
1 --echo #
2 --echo # MDEV-9044 : Getting binlog corruption on my Galera cluster (10.1.8)
3 --echo # making it impossible to async slave.
4 --echo #
5
6 --source include/have_innodb.inc
7 --source include/galera_cluster.inc
8
9 --connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3
10 --disable_query_log
11 --eval CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_USER='root', MASTER_SSL_VERIFY_SERVER_CERT=0, MASTER_PORT=$NODE_MYPORT_1;
12 --enable_query_log
13 START SLAVE;
14
15 --connection node_1
16
17 SELECT @@GLOBAL.BINLOG_CACHE_SIZE;
18 CREATE TABLE t1 (c1 INTEGER PRIMARY KEY, c2 VARCHAR(12000)) ENGINE=INNODB;
19 CREATE TABLE t2 (c1 INTEGER PRIMARY KEY) ENGINE=INNODB;
20
21 START TRANSACTION;
22 INSERT INTO t1 VALUES(1, REPEAT('-', 10000));
23 COMMIT;
24 INSERT INTO t2 VALUES(1);
25 save_master_pos;
26
27 --connection node_2
28 SELECT c1, LENGTH(c2) FROM t1;
29 SELECT * FROM t2;
30
31 --connection node_3
32 sync_with_master;
33
34 SELECT c1, LENGTH(c2) FROM t1;
35 SELECT * FROM t2;
36
37 --echo # Cleanup
38 --connection node_1
39 DROP TABLE t1, t2;
40 save_master_pos;
41
42 --connection node_3
43 sync_with_master;
44
45 STOP SLAVE;
46 RESET SLAVE ALL;