Debian Codegraph @

mysql-test/suite/galera_sr/t/galera_sr_unit_statements.test

raw
1 #
2 # Test wsrep_fragment_unit = statements
3 #
4
5 --source include/galera_cluster.inc
6 --source include/have_innodb.inc
7
8 --connection node_1
9 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
10
11 SET SESSION wsrep_trx_fragment_size = 3;
12 SHOW WARNINGS;
13 SET SESSION wsrep_trx_fragment_unit = 'statements';
14 SHOW WARNINGS;
15
16 --connection node_1
17 SET AUTOCOMMIT=OFF;
18 START TRANSACTION;
19 INSERT INTO t1 VALUES (1);
20
21 --echo # Expect nothing is replicated yet, so far we have 2 statements
22 --connection node_2
23 SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
24 SELECT COUNT(*) AS EXPECT_0 FROM t1;
25 SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log;
26
27 --connection node_1
28 INSERT INTO t1 VALUES (2);
29
30 --echo # Expect 2 rows in t1 and 1 fragment in SR table
31 --connection node_2
32 SELECT COUNT(*) AS EXPECT_2 FROM t1;
33 SELECT COUNT(*) AS EXPECT_1 FROM mysql.wsrep_streaming_log;
34
35 --connection node_1
36 INSERT INTO t1 VALUES (3);
37 INSERT INTO t1 VALUES (4);
38 INSERT INTO t1 VALUES (5);
39
40 --echo # Expect 5 rows in t1 and 2 fragments in SR table
41 --connection node_2
42 SELECT COUNT(*) AS EXPECT_5 FROM t1;
43 SELECT COUNT(*) AS EXPECT_2 FROM mysql.wsrep_streaming_log;
44
45 --connection node_1
46 COMMIT;
47
48 --echo # Expect 5 rows in t1 and empty SR table
49 SELECT COUNT(*) AS EXPECT_5 FROM t1;
50 SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log;
51
52 --connection node_2
53 SELECT COUNT(*) AS EXPECT_5 FROM t1;
54 SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log;
55
56 DROP TABLE t1;