Debian Codegraph @

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

raw
1 #
2 # Test that Galera works with binary log checksums.
3 # The galera_binlog_checksum-master.opt file is used to enable checksums.
4 #
5
6 --source include/galera_cluster.inc
7 --source include/have_innodb.inc
8
9 CREATE TABLE t1 (f1 INT PRIMARY KEY) ENGINE=InnoDB;
10
11 INSERT INTO t1 VALUES (1);
12
13 --connection node_2
14 SELECT COUNT(*) = 1 FROM t1;
15
16 --connection node_1
17 UPDATE t1 SET f1 = 2 WHERE f1 = 1;
18
19 --connection node_2
20 SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 2;
21
22 DROP TABLE t1;
23
24 --echo #
25 --echo # MDEV-11149: wsrep_replicate_mysaim: DML fails when binlog checksum
26 --echo # enabled
27 --echo #
28
29 --connection node_1
30 SET @@global.wsrep_mode = REPLICATE_MYISAM;
31
32 CREATE TABLE t1 (i INT NOT NULL PRIMARY KEY) ENGINE=MYISAM;
33 INSERT INTO t1 VALUES(1);
34
35 --connection node_2
36 SELECT * FROM t1;
37
38 --connection node_1
39 DROP TABLE t1;
40
41 SET @@global.wsrep_mode=DEFAULT;
42
43 --echo # End of tests.