Debian Codegraph @

mysql-test/suite/galera_sr/t/mysql-wsrep-features#136.test

raw
1 # SR transactions are not binlogged #136
2
3 --source include/galera_cluster.inc
4
5 --connection node_1
6 SET GLOBAL wsrep_on=OFF;
7 RESET MASTER;
8 SET GLOBAL wsrep_on=ON;
9
10 --connection node_2
11 SET GLOBAL wsrep_on=OFF;
12 RESET MASTER;
13 SET GLOBAL wsrep_on=ON;
14
15 --connection node_1
16 SET SESSION wsrep_trx_fragment_size = 1;
17 SET AUTOCOMMIT=OFF;
18 START TRANSACTION;
19 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
20 INSERT INTO t1 VALUES (1),(2);
21 COMMIT;
22
23 SET SESSION wsrep_trx_fragment_size = 0;
24 INSERT INTO t1 VALUES (3),(4);
25 COMMIT;
26
27 --connection node_1
28 --replace_regex /xid=[0-9]+/xid=###/ /table_id: [0-9]+/table_id: ###/
29 --replace_column 2 <Pos> 5 <End_log_pos>
30 SHOW BINLOG EVENTS IN 'mysqld-bin.000001' FROM 256;
31
32 --connection node_2
33 # Wait for all updates to arrive before dumping binlog
34 SELECT COUNT(*) = 4 FROM t1;
35
36 --replace_regex /xid=[0-9]+/xid=###/ /table_id: [0-9]+/table_id: ###/
37 --replace_column 2 <Pos> 5 <End_log_pos>
38 SHOW BINLOG EVENTS IN 'mysqld-bin.000001' FROM 256;
39
40 --connection node_1
41 DROP TABLE t1;