Debian Codegraph @

mysql-test/suite/rpl/t/rpl_parallel_multi_db.test

raw
1 #
2 # WL#5569 MTS
3 #
4 # The test verifies correctness of Query event parallelization when
5 # a DML Query modifies multiple databases.
6 #
7
8 --source include/set_privilege_checks_user_as_system_user.inc
9 --source include/master-slave.inc
10 --source include/have_binlog_format_statement.inc
11 --source include/no_valgrind_without_big.inc
12
13
14 # restart in Parallel
15
16 let $workers= 4;
17
18 connection slave;
19
20 source include/stop_slave.inc;
21 set @save.replica_parallel_workers= @@global.replica_parallel_workers;
22 eval set @@global.replica_parallel_workers= $workers;
23 source include/start_slave.inc;
24
25
26 let $dbs= 8;
27 let $tables= 8;
28 let $queries= `select $dbs*$tables * 4`;
29
30 #
31 # 1. Case of multi-update
32 #
33
34 connection master;
35
36 --disable_query_log
37 call mtr.add_suppression('.*Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT.*');
38 --enable_query_log
39
40 # create & populate
41
42 let $n= $dbs;
43 while ($n)
44 {
45 eval create database d$n;
46 let $m= $tables;
47 while ($m)
48 {
49 eval create table d$n.t$m (a int);
50 eval select round(rand()*$tables) into @var;
51 eval insert into d$n.t$m values (@var);
52 dec $m;
53 }
54 dec $n;
55 }
56
57
58 # operate to check consistency in the end
59
60 let $k= $queries;
61
62 --disable_query_log
63 --disable_warnings
64 while ($k)
65 {
66 let $tables_in_query= `select 2 * (1 + floor(rand()*$dbs))`;
67 let $i= $tables_in_query;
68 let $table_list= ;
69 let $set_list= ;
70 while ($i)
71 {
72 let $n1= `select floor(rand()*$dbs + 1)`;
73 let $m1= `select floor(rand()*$tables + 1)`;
74 let $n2= `select floor(rand()*$dbs + 1)`;
75 let $m2= `select floor(rand()*$tables + 1)`;
76 let $table_list= $table_list d$n1.t$m1 as t_$i, ;
77 let $set_list= $set_list t_$i.a= ;
78 dec $i;
79
80 let $table_list= $table_list d$n2.t$m2 as t_$i, ;
81 let $set_list= $set_list t_$i.a + round(rand(10)), ;
82
83 dec $i;
84 }
85 let $n1= `select floor(rand()*$dbs + 1)`;
86 let $m1= `select floor(rand()*$tables + 1)`;
87 let $n2= `select floor(rand()*$dbs + 1)`;
88 let $m2= `select floor(rand()*$tables + 1)`;
89
90 ## --disable_warnings
91
92 eval update $table_list d$n1.t$m1 as t_1_$i, d$n2.t$m2 as t_2_$i
93 set $set_list t_1_$i.a=t_2_$i.a + round(rand(10));
94 ## --enable_warnings
95
96 dec $k;
97 }
98 --enable_warnings
99 --enable_query_log
100
101 --source include/sync_slave_sql_with_master.inc
102
103 #
104 # 2. Case of invoked routines
105 #
106
107 # A. Functions
108
109 # create functions & run load
110 let $n= $dbs;
111 # n'th db func is defined through n-1'th except n == 1
112 let $n1= $n;
113 dec $n1;
114
115 connection master;
116
117 --disable_query_log
118
119 while ($n1)
120 {
121 let $m= `select floor(rand()*$tables) + 1`;
122
123 delimiter |;
124
125 eval create function `d$n`.`func` (a int) returns int
126 begin
127 insert into `d$n`.`t$m` values (`d$n1`.`func`(1));
128 return 1;
129 end|
130
131 delimiter ;|
132
133 dec $n;
134 dec $n1;
135 }
136
137 delimiter |;
138
139 eval create function `d1`.`func` (a int) returns int
140 begin
141 insert into `d1`.`t$m` values (0);
142 return 1;
143 end|
144
145 delimiter ;|
146
147
148 # invoke...
149
150 let $k= $queries;
151
152 while ($k)
153 {
154 let $n= `select floor(rand()*$dbs) + 1`;
155 let $m= `select floor(rand()*$tables) + 1`;
156 let $n1= $n;
157 dec $n1;
158 if ($n1)
159 {
160 eval insert into d$n.t$m values (`d$n1`.`func`(1));
161 }
162 dec $k;
163 }
164
165 --enable_query_log
166
167 --source include/sync_slave_sql_with_master.inc
168
169 # B. Triggers
170
171 connection master;
172
173 # create triggers & run load
174 let $n= $dbs;
175 # n'th db tables won't have any trigger to avoid circular dependency
176 let $n1= $n;
177 dec $n1;
178
179 --disable_query_log
180 while ($n1)
181 {
182 let $m= $tables;
183
184 while ($m)
185 {
186 eval create trigger `d$n1`.`trg_t$m` before insert on `d$n1`.`t$m` for each row insert into `d$n`.`t$m` values(1);
187 dec $m;
188 }
189 dec $n;
190 dec $n1;
191 }
192 --enable_query_log
193
194 # invoke...
195
196 let $k= $queries;
197
198 --disable_query_log
199 --disable_warnings
200 while ($k)
201 {
202 let $n= `select floor(rand()*$dbs + 1)`;
203 let $m= `select floor(rand()*$tables + 1)`;
204 eval insert into d$n.t$n values (2);
205 dec $k;
206 }
207 --enable_warnings
208 --enable_query_log
209
210
211 --source include/sync_slave_sql_with_master.inc
212
213 #
214 # Consistency check
215 #
216
217 let $n = $dbs;
218 while($n)
219 {
220 let $m= $tables;
221 while ($m)
222 {
223 let $diff_tables=master:d$n.t$m, slave:d$n.t$m;
224 source include/diff_tables.inc;
225 dec $m;
226 }
227 dec $n;
228 }
229
230 #
231 # Clean-up of the regular case tests
232 #
233
234 connection master;
235
236 --disable_query_log
237
238 let $n= $dbs;
239 while ($n)
240 {
241 eval drop database d$n;
242 dec $n;
243 }
244
245 --enable_query_log
246
247 --source include/sync_slave_sql_with_master.inc
248
249 #
250 # Over MAX_DBS_IN_QUERY_MTS
251 #
252
253 let $dbs= 20;
254 let $queries= `select $dbs* 4`;
255
256 connection master;
257
258 let $n= $dbs;
259 let $m= 1;
260 while ($n)
261 {
262 eval create database d$n;
263 eval create table d$n.t$m (a int);
264 eval select round(rand()*$tables) into @var;
265 eval insert into d$n.t$m values (@var);
266
267 dec $n;
268 }
269
270 --disable_query_log
271 --disable_warnings
272
273 let $k= $queries;
274
275 while ($k)
276 {
277 let $tables_in_query= `select 2 * (1 + floor(rand()*$dbs))`;
278 let $i= $tables_in_query;
279 let $table_list= ;
280 let $set_list= ;
281 while ($i)
282 {
283 let $n1= `select floor(rand()*$dbs + 1)`;
284 let $m1= 1;
285 let $n2= `select floor(rand()*$dbs + 1)`;
286 let $m2= 1;
287 let $table_list= $table_list d$n1.t$m1 as t_$i, ;
288 let $set_list= $set_list t_$i.a= ;
289 dec $i;
290
291 let $table_list= $table_list d$n2.t$m2 as t_$i, ;
292 let $set_list= $set_list t_$i.a + round(rand(10)), ;
293
294 dec $i;
295 }
296 let $n1= `select floor(rand()*$dbs + 1)`;
297 let $m1= 1;
298 let $n2= `select floor(rand()*$dbs + 1)`;
299 let $m2= 1;
300
301 eval update $table_list d$n1.t$m1 as t_1_$i, d$n2.t$m2 as t_2_$i
302 set $set_list t_1_$i.a=t_2_$i.a + round(rand(10));
303 dec $k;
304 }
305 --enable_warnings
306 --enable_query_log
307
308 --source include/sync_slave_sql_with_master.inc
309
310 # Todo: to impelement a stress test for sync_slave_with_master
311 # specifically in parallel mode.
312 # The following lines are left as extra reminder.
313 #
314 #--disable_query_log
315 #--disable_result_log
316 #select sleep(1);
317 #--enable_result_log
318 #--enable_query_log
319
320 #
321 # Consistency check
322 #
323
324 let $n = $dbs;
325 let $m= 1;
326 while($n)
327 {
328 let $diff_tables=master:d$n.t$m, slave:d$n.t$m;
329 source include/diff_tables.inc;
330 dec $n;
331 }
332
333 #
334 # The final clean-up
335 #
336
337 connection master;
338
339 --disable_query_log
340
341 let $n= $dbs;
342 while ($n)
343 {
344 eval drop database d$n;
345 dec $n;
346 }
347
348 --enable_query_log
349
350 --source include/sync_slave_sql_with_master.inc
351
352 --disable_warnings
353 set @@global.replica_parallel_workers= @save.replica_parallel_workers;
354 --enable_warnings
355
356 --source include/rpl_end.inc
357