Debian Codegraph @

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

raw
1 #
2 # Test Galera as a replica to a MariaDB async replication
3 #
4 # MariaDB
5 # primary ---async replication--->galera node_2 (replica)<----galera replication---> galera node1
6 #
7 # Test outline:
8 #
9 # - Create user for async replication
10 # - Create table and some data in primary
11 # - Verify that table and data is replicated to galera nodes
12 # - Verify that mysql.gtid_slave_pos has some rows in all Galera nodes
13 # - Verify that gtid_slave_pos, gtid_binlog_pos and gtid_current_pos are
14 # same in all Galera nodes
15 # - Verify that we can shutdown and restart Galera replica (node #2)
16 # - Verify that gtid_slave_pos, gtid_binlog_pos and gtid_current_pos are
17 # same in all Galera nodes
18 # - Verify that mysql.gtid_slave_pos table has limited amount of rows
19 # - Veruft that ddl works (drop table)
20 #
21 # Similar test is done so that new rows are added to table in
22 # primary while async replica (node #2) is down.
23 #
24 # The galera/galera_2node_slave.cnf describes the setup of the nodes
25 #
26 --source include/force_restart.inc
27 --source include/galera_cluster.inc
28 --source include/have_innodb.inc
29
30 # In this test we mark node #2 as replica
31 --connect replica, 127.0.0.1, root, , test, $NODE_MYPORT_2
32
33 # As node #3 is not a Galera node, and galera_cluster.inc does not open connetion to it
34 # we open the primary connection her
35 --connect primary, 127.0.0.1, root, , test, $NODE_MYPORT_3
36
37 create user repl@'%' identified by 'repl';
38 grant all on *.* to repl@'%';
39 ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
40
41 --let $node_1 = node_1
42 --let $node_2 = replica
43 --let $node_3 = primary
44 --source include/auto_increment_offset_save.inc
45
46 --connection replica
47 --disable_query_log
48 --eval CHANGE MASTER TO master_host='127.0.0.1', master_user='repl', master_password='repl', master_ssl_verify_server_cert=0, master_port=$NODE_MYPORT_3, master_use_gtid=slave_pos;
49 --enable_query_log
50 START SLAVE;
51
52 --connection primary
53 CREATE TABLE t1 (id bigint auto_increment primary key, msg varchar(100)) engine=innodb;
54
55 --echo # Intentionally generate 1k GTID-events
56 --let $inserts=1000
57 --let $count=0
58 --disable_query_log
59 while($count < $inserts)
60 {
61 --eval insert into t1 values (NULL,'test1')
62 --inc $count
63 }
64 --enable_query_log
65
66 SELECT COUNT(*) AS EXPECT_1000 FROM t1;
67
68 --connection replica
69 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
70 --source include/wait_condition.inc
71
72 --let $wait_condition = SELECT COUNT(*) = 1000 FROM t1;
73 --source include/wait_condition.inc
74
75 --let $wait_condition = SELECT COUNT(*) < 1000 FROM mysql.gtid_slave_pos;
76 --source include/wait_condition.inc
77 SELECT COUNT(*) > 0 AS EXPECT_1 FROM mysql.gtid_slave_pos;
78 SELECT COUNT(*) < 1000 AS EXPECT_1 FROM mysql.gtid_slave_pos;
79 SELECT @@gtid_slave_pos,@@gtid_binlog_pos,@@gtid_current_pos;
80 SELECT COUNT(*) AS EXPECT_1000 FROM t1;
81
82 --connection node_1
83 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
84 --source include/wait_condition.inc
85
86 --let $wait_condition = SELECT COUNT(*) = 1000 FROM t1;
87 --source include/wait_condition.inc
88
89 --let $wait_condition = SELECT COUNT(*) < 1000 FROM mysql.gtid_slave_pos;
90 --source include/wait_condition.inc
91 SELECT COUNT(*) > 0 AS EXPECT_1 FROM mysql.gtid_slave_pos;
92 SELECT COUNT(*) < 1000 AS EXPECT_1 FROM mysql.gtid_slave_pos;
93 SELECT @@gtid_slave_pos,@@gtid_binlog_pos,@@gtid_current_pos;
94 SELECT COUNT(*) AS EXPECT_1000 FROM t1;
95
96 --connection replica
97 --echo # Verify that graceful shutdown succeeds in replica.
98 --source include/shutdown_mysqld.inc
99 --echo # Force SST
100 --remove_file $MYSQLTEST_VARDIR/mysqld.2/data/grastate.dat
101
102 --connection node_1
103 --echo # Waiting until replica is not part of cluster anymore
104 --let $wait_condition = SELECT VARIABLE_VALUE = 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
105 --source include/wait_condition.inc
106 --let $wait_condition = SELECT VARIABLE_VALUE = 'Primary' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
107 --source include/wait_condition.inc
108
109 --connection replica
110 --echo # Start replica again
111 --source include/start_mysqld.inc
112
113 --echo # Wait until replica is back on cluster
114 --let $wait_condition = SELECT VARIABLE_VALUE = 'Primary' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
115 --source include/wait_condition.inc
116 --let $wait_condition = SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
117 --source include/wait_condition.inc
118 --let $wait_condition = SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready';
119 --source include/wait_condition.inc
120
121 --let $wait_condition = SELECT COUNT(*) < 1000 FROM mysql.gtid_slave_pos;
122 --source include/wait_condition.inc
123 SELECT COUNT(*) > 0 AS EXPECT_1 FROM mysql.gtid_slave_pos;
124 SELECT COUNT(*) < 1000 AS EXPECT_1 FROM mysql.gtid_slave_pos;
125 SELECT @@gtid_slave_pos,@@gtid_binlog_pos,@@gtid_current_pos;
126 SELECT COUNT(*) AS EXPECT_1000 FROM t1;
127
128 --connection node_1
129 --let $wait_condition = SELECT COUNT(*) < 1000 FROM mysql.gtid_slave_pos;
130 --source include/wait_condition.inc
131 SELECT COUNT(*) > 0 AS EXPECT_1 FROM mysql.gtid_slave_pos;
132 SELECT COUNT(*) < 1000 AS EXPECT_1 FROM mysql.gtid_slave_pos;
133 SELECT @@gtid_slave_pos,@@gtid_binlog_pos,@@gtid_current_pos;
134 SELECT COUNT(*) AS EXPECT_1000 FROM t1;
135
136 --connection primary
137 SELECT COUNT(*) AS EXPECT_1000 FROM t1;
138
139 #
140 # Cleanup
141 #
142 drop table t1;
143
144 --connection replica
145 --let $wait_condition = SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
146 --source include/wait_condition.inc
147
148 --connection node_1
149 --let $wait_condition = SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
150 --source include/wait_condition.inc
151
152 #
153 # Case 2 : While slave is down add writes to master
154 #
155
156 --connection primary
157 CREATE TABLE t1 (id bigint auto_increment primary key, msg varchar(100)) engine=innodb;
158 --echo # Intentionally generate 1k GTID-events
159 --let $inserts=1000
160 --let $count=0
161 --disable_query_log
162 while($count < $inserts)
163 {
164 --eval insert into t1 values (NULL,'test1')
165 --inc $count
166 }
167 --enable_query_log
168 SELECT COUNT(*) AS EXPECT_1000 FROM t1;
169
170 --connection replica
171 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
172 --source include/wait_condition.inc
173
174 --let $wait_condition = SELECT COUNT(*) = 1000 FROM t1;
175 --source include/wait_condition.inc
176
177 --let $wait_condition = SELECT COUNT(*) < 1000 FROM mysql.gtid_slave_pos;
178 --source include/wait_condition.inc
179 SELECT COUNT(*) > 0 AS EXPECT_1 FROM mysql.gtid_slave_pos;
180 SELECT COUNT(*) < 1000 AS EXPECT_1 FROM mysql.gtid_slave_pos;
181 SELECT @@gtid_slave_pos,@@gtid_binlog_pos,@@gtid_current_pos;
182 SELECT COUNT(*) AS EXPECT_1000 FROM t1;
183
184 --connection node_1
185 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
186 --source include/wait_condition.inc
187
188 --let $wait_condition = SELECT COUNT(*) = 1000 FROM t1;
189 --source include/wait_condition.inc
190
191 --let $wait_condition = SELECT COUNT(*) < 1000 FROM mysql.gtid_slave_pos;
192 --source include/wait_condition.inc
193 SELECT COUNT(*) > 0 AS EXPECT_1 FROM mysql.gtid_slave_pos;
194 SELECT COUNT(*) < 1000 AS EXPECT_1 FROM mysql.gtid_slave_pos;
195 SELECT @@gtid_slave_pos,@@gtid_binlog_pos,@@gtid_current_pos;
196
197 --connection replica
198 --echo # Verify that graceful shutdown succeeds in replica.
199 --source include/shutdown_mysqld.inc
200 --echo # Force SST
201 --remove_file $MYSQLTEST_VARDIR/mysqld.2/data/grastate.dat
202
203 --connection node_1
204 --echo # Waiting until replica is not part of cluster anymore
205 --let $wait_condition = SELECT VARIABLE_VALUE = 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
206 --source include/wait_condition.inc
207 --let $wait_condition = SELECT VARIABLE_VALUE = 'Primary' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
208 --source include/wait_condition.inc
209
210 --echo # Add writes to primary
211 --connection primary
212 --echo # Intentionally generate 1k GTID-events
213 --let $inserts=1000
214 --let $count=0
215 --disable_query_log
216 while($count < $inserts)
217 {
218 --eval insert into t1 values (NULL,'test1')
219 --inc $count
220 }
221 --enable_query_log
222
223 SELECT COUNT(*) AS EXPECT_2000 FROM t1;
224
225 --connection replica
226 --echo # Start replica again
227 --source include/start_mysqld.inc
228
229 --echo # Wait until replica is back on cluster
230 --let $wait_condition = SELECT VARIABLE_VALUE = 'Primary' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
231 --source include/wait_condition.inc
232 --let $wait_condition = SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
233 --source include/wait_condition.inc
234 --let $wait_condition = SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready';
235 --source include/wait_condition.inc
236
237 --let $wait_condition = SELECT COUNT(*) = 2000 FROM t1;
238 --source include/wait_condition.inc
239 --let $wait_condition = SELECT COUNT(*) < 1000 FROM mysql.gtid_slave_pos;
240 --source include/wait_condition.inc
241 SELECT COUNT(*) > 0 AS EXPECT_1 FROM mysql.gtid_slave_pos;
242 SELECT COUNT(*) < 1000 AS EXPECT_1 FROM mysql.gtid_slave_pos;
243 SELECT @@gtid_slave_pos,@@gtid_binlog_pos,@@gtid_current_pos;
244 SELECT COUNT(*) AS EXPECT_2000 FROM t1;
245
246 --connection node_1
247 --let $wait_condition = SELECT COUNT(*) = 2000 FROM t1;
248 --source include/wait_condition.inc
249 --let $wait_condition = SELECT COUNT(*) < 1000 FROM mysql.gtid_slave_pos;
250 --source include/wait_condition.inc
251 SELECT COUNT(*) > 0 AS EXPECT_1 FROM mysql.gtid_slave_pos;
252 SELECT COUNT(*) < 1000 AS EXPECT_1 FROM mysql.gtid_slave_pos;
253 SELECT @@gtid_slave_pos,@@gtid_binlog_pos,@@gtid_current_pos;
254 SELECT COUNT(*) AS EXPECT_2000 FROM t1;
255
256 --connection primary
257 SELECT COUNT(*) AS EXPECT_2000 FROM t1;
258
259 #
260 # Cleanup
261 #
262 drop table t1;
263
264 --connection replica
265 --let $wait_condition = SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
266 --source include/wait_condition.inc
267
268 --connection node_1
269 --let $wait_condition = SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
270 --source include/wait_condition.inc
271
272 --connection replica
273 STOP SLAVE;
274 RESET SLAVE ALL;
275
276 --connection primary
277 RESET MASTER;
278
279 --source include/auto_increment_offset_restore.inc
280
281 --connection node_1
282 --disconnect primary
283 --disconnect replica
284
285 --source include/galera_end.inc
286 --echo # End of test