Debian Codegraph @

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

raw
1 # Test for @@wsrep_gtid_mode and @@wsrep_gtid_domain_id variables
2 #
3 # When @@wsrep_gtid_mode=ON, all DDL/DML commands and transactions that
4 # are meant to be replicated over Galera cluster nodes are tagged with
5 # galera gtid_domain_id (@@wsrep_gtid_domain_id), while others are tagged
6 # with the local domain_id (@@gtid_domain_id).
7
8 --source include/galera_cluster.inc
9 --source include/have_innodb.inc
10
11 --echo # On node_1
12 --connection node_1
13 # print initial GTIDs
14 source include/print_gtid.inc;
15
16 --echo # On node_2
17 --connection node_2
18 # print initial GTIDs
19 source include/print_gtid.inc;
20
21 --echo # On node_1
22 --connection node_1
23 CREATE TABLE t1(i INT) ENGINE=INNODB;
24 CREATE TABLE t2(i INT) ENGINE=MEMORY;
25 INSERT INTO t1 VALUES(1);
26 SELECT * FROM t1;
27 SELECT * FROM t2;
28 source include/print_gtid.inc;
29
30 --echo # On node_2
31 --connection node_2
32 SELECT * FROM t1;
33 source include/print_gtid.inc;
34
35 --echo # On node_1
36 --connection node_1
37 INSERT INTO t2 VALUES(1);
38 SELECT * FROM t2;
39 source include/print_gtid.inc;
40
41 --echo # On node_2
42 --connection node_2
43 SELECT * FROM t2;
44 source include/print_gtid.inc;
45
46 --echo # On node_1
47 --connection node_1
48 # Cleanup
49 DROP TABLE t1, t2;
50
51 --echo #cleanup
52 --connection node_1
53 set global wsrep_on=OFF;
54 reset master;
55 set global wsrep_on=ON;
56
57 --connection node_2
58 set global wsrep_on=OFF;
59 reset master;
60 set global wsrep_on=ON;
61
62 --connection node_2
63 CALL mtr.add_suppression("Ignoring server id .* for non bootstrap node");
64
65 --source include/galera_end.inc
66 --echo # End of test