Debian Codegraph @

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

raw
1 #
2 # Test wsrep_on = OFF. Some events will not be replicated
3 #
4
5 --source include/galera_cluster.inc
6 --source include/have_innodb.inc
7
8 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
9 INSERT INTO t1 VALUES (1);
10 SET SESSION wsrep_on = FALSE;
11
12 # This statement will not be replicated
13 INSERT INTO t1 VALUES (2);
14
15 --connection node_2
16 SELECT COUNT(*) = 1 FROM t1;
17
18 --connection node_1
19 SET GLOBAL wsrep_on = TRUE;
20 INSERT INTO t1 VALUES (3);
21
22 --connection node_2
23 SELECT COUNT(*) = 2 FROM t1;
24
25 # Middle insert is not replicated
26 SELECT COUNT(*) = 0 FROM t1 WHERE f1 = 2;
27
28 # Final insert is replicated
29 SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 3;
30
31 DROP TABLE t1;
32
33 --connection node_1
34 --let $wait_condition = SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
35 --source include/wait_condition.inc
36
37 #
38 # Test that variable wsrep_on cannot be changed while in
39 # active transaction.
40 #
41
42 --connection node_1
43 START TRANSACTION;
44 --error ER_CANT_DO_THIS_DURING_AN_TRANSACTION
45 SET SESSION wsrep_on=OFF;
46 --error ER_CANT_DO_THIS_DURING_AN_TRANSACTION
47 SET GLOBAL wsrep_on=OFF;
48 COMMIT;
49
50
51 #
52 # Test that @@global.wsrep_on does not affect the value of
53 # @@session.wsrep_on of current sessions
54 #
55
56 --connection node_1
57 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY);
58 START TRANSACTION;
59 INSERT INTO t1 VALUES (1);
60
61 --connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
62 --connection node_1a
63 SET GLOBAL wsrep_on = OFF;
64
65 --connection node_1
66 SHOW SESSION VARIABLES LIKE 'wsrep_on';
67 SHOW GLOBAL VARIABLES LIKE 'wsrep_on';
68 INSERT INTO t1 VALUES (2);
69 COMMIT;
70
71 --connection node_2
72 SET SESSION wsrep_sync_wait = 15;
73 SELECT * FROM t1;
74
75 --connection node_1a
76 SET GLOBAL wsrep_on = ON;
77 DROP TABLE t1;
78
79 --connection node_2
80 --let $wait_condition = SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
81 --source include/wait_condition.inc
82
83
84 #
85 # New connections inherit @@session.wsrep_on from @@global.wsrep_on
86 #
87
88 --connection node_1
89 SET GLOBAL wsrep_on = OFF;
90
91 --connect node_1b, 127.0.0.1, root, , test, $NODE_MYPORT_1;
92 --connection node_1b
93 SHOW SESSION VARIABLES LIKE 'wsrep_on';
94 SHOW GLOBAL VARIABLES LIKE 'wsrep_on';
95 CREATE TABLE t2 (f1 INTEGER);
96 DROP TABLE t2;
97
98 SET GLOBAL wsrep_on = ON;
99 SHOW SESSION VARIABLES LIKE 'wsrep_on';
100
101 --disconnect node_1b
102
103 --connection node_2
104 --let $wait_condition = SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't2';
105 --source include/wait_condition.inc
106
107
108 #
109 # Can't set @@session.wsrep_on = ON, while @@global.wsrep_on = OFF
110 #
111
112 --connection node_1
113 SET GLOBAL wsrep_on = OFF;
114 --error ER_WRONG_ARGUMENTS
115 SET SESSION wsrep_on = ON;
116
117 SET GLOBAL wsrep_on = ON;
118 SET SESSION wsrep_on = ON;
119
120
121 #
122 # @@global.wsrep_on = OFF followed by @@global.wsrep_on = ON
123 # in a new connection
124 #
125
126 --connection node_1
127 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY);
128 SET GLOBAL wsrep_on = OFF;
129 --connect node_1b, 127.0.0.1, root, , test, $NODE_MYPORT_1;
130 --connection node_1b
131 SHOW SESSION VARIABLES LIKE 'wsrep_on';
132 SHOW GLOBAL VARIABLES LIKE 'wsrep_on';
133 SET GLOBAL wsrep_on = ON;
134 START TRANSACTION;
135 INSERT INTO t1 VALUES(1);
136 COMMIT;
137
138 SELECT * FROM t1;
139
140 --connection node_2
141 SELECT * FROM t1;
142
143 DROP TABLE t1;
144
145 --connection node_1
146 --let $wait_condition = SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
147 --source include/wait_condition.inc
148
149 #
150 # Test single statement, multi statement, and
151 # TOI tansactions while @@session.wsrep_on = OFF
152 # and then same @@global.wsrep_on = OFF.
153 # Notice, the combination @@global.wsrep_on = OFF
154 # and @@session.wsrep_on = ON is not not possible,
155 # (as tested above in this test case)
156 #
157
158 --connection node_1
159 SET SESSION wsrep_on = OFF;
160 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY);
161 INSERT INTO t1 VALUES (1);
162 START TRANSACTION;
163 INSERT INTO t1 VALUES (2);
164 COMMIT;
165 DROP TABLE t1;
166 --connection node_2
167 SHOW TABLES;
168 --connection node_1
169 SET SESSION wsrep_on = ON;
170
171 SET GLOBAL wsrep_on = OFF;
172 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY);
173 INSERT INTO t1 VALUES (1);
174 START TRANSACTION;
175 INSERT INTO t1 VALUES (2);
176 COMMIT;
177 --connection node_2
178 SHOW TABLES;
179 --connection node_1
180 DROP TABLE t1;
181 SET GLOBAL wsrep_on = ON;
182
183 --connection node_2
184 --let $wait_condition = SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
185 --source include/wait_condition.inc