Debian Codegraph @

mysql-test/suite/galera_3nodes/r/galera_gtid_2_cluster.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 cluster 1 node 1
5 SHOW STATUS LIKE 'wsrep_cluster_size';
6 Variable_name Value
7 wsrep_cluster_size 3
8 connection node_2;
9 cluster 1 node 2
10 SHOW STATUS LIKE 'wsrep_cluster_size';
11 Variable_name Value
12 wsrep_cluster_size 3
13 connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3;
14 connection node_3;
15 cluster 1 node 3
16 SHOW STATUS LIKE 'wsrep_cluster_size';
17 Variable_name Value
18 wsrep_cluster_size 3
19 connect node_4, 127.0.0.1, root, , test, $NODE_MYPORT_4;
20 connection node_4;
21 cluster 2 node 1
22 SHOW STATUS LIKE 'wsrep_cluster_size';
23 Variable_name Value
24 wsrep_cluster_size 3
25 connect node_5, 127.0.0.1, root, , test, $NODE_MYPORT_5;
26 connection node_5;
27 cluster 2 node 2
28 SHOW STATUS LIKE 'wsrep_cluster_size';
29 Variable_name Value
30 wsrep_cluster_size 3
31 connect node_6, 127.0.0.1, root, , test, $NODE_MYPORT_6;
32 connection node_6;
33 cluster 2 node 3
34 SHOW STATUS LIKE 'wsrep_cluster_size';
35 Variable_name Value
36 wsrep_cluster_size 3
37 connection node_1;
38 --- ignore_server_ids=(12,13)
39 start slave;
40 include/wait_for_slave_to_start.inc
41 select @@gtid_binlog_state;
42 @@gtid_binlog_state
43
44 select @@gtid_slave_pos;
45 @@gtid_slave_pos
46
47 connection node_4;
48 --- ignore_server_ids=(22,23)
49 start slave;
50 include/wait_for_slave_to_start.inc
51 select @@gtid_binlog_state;
52 @@gtid_binlog_state
53
54 select @@gtid_slave_pos;
55 @@gtid_slave_pos
56
57 cluster 1 node 1
58 connection node_1;
59 create table t1 (cluster_domain_id int ,node_server_id int, seq_no int);
60 insert into t1 values (1, 11, 2);
61 select @@gtid_binlog_state;
62 @@gtid_binlog_state
63 1-11-2
64 #wait for sync cluster 1 and 2
65 connection node_1;
66 include/save_master_gtid.inc
67 connection node_4;
68 include/sync_with_master_gtid.inc
69 cluster 2 node 1
70 connection node_4;
71 select @@gtid_binlog_state;
72 @@gtid_binlog_state
73 1-11-2
74 insert into t1 values (2, 21, 1);
75 select @@gtid_binlog_state;
76 @@gtid_binlog_state
77 1-11-2,2-21-1
78 #wait for sync cluster 1 and 2
79 connection node_1;
80 include/save_master_gtid.inc
81 connection node_4;
82 include/sync_with_master_gtid.inc
83 select * from t1 order by 1, 2, 3;
84 cluster_domain_id node_server_id seq_no
85 1 11 2
86 2 21 1
87 cluster 1 node 2
88 connection node_2;
89 select @@gtid_binlog_state;
90 @@gtid_binlog_state
91 1-11-2,2-21-1
92 insert into t1 values (1, 12, 3);
93 select @@gtid_binlog_state;
94 @@gtid_binlog_state
95 1-11-3,2-21-1
96 #wait for sync cluster 1 and 2
97 connection node_1;
98 include/save_master_gtid.inc
99 connection node_4;
100 include/sync_with_master_gtid.inc
101 select * from t1 order by 1, 2, 3;
102 cluster_domain_id node_server_id seq_no
103 1 11 2
104 1 12 3
105 2 21 1
106 cluster 1 node 3
107 connection node_3;
108 select @@gtid_binlog_state;
109 @@gtid_binlog_state
110 1-11-3,2-21-1
111 insert into t1 values (1, 13, 4);
112 select @@gtid_binlog_state;
113 @@gtid_binlog_state
114 1-11-4,2-21-1
115 #wait for sync cluster 1 and 2
116 connection node_1;
117 include/save_master_gtid.inc
118 connection node_4;
119 include/sync_with_master_gtid.inc
120 select * from t1 order by 1, 2, 3;
121 cluster_domain_id node_server_id seq_no
122 1 11 2
123 1 12 3
124 1 13 4
125 2 21 1
126 cluster 2 node 2
127 connection node_5;
128 select @@gtid_binlog_state;
129 @@gtid_binlog_state
130 1-11-4,2-21-1
131 insert into t1 values (2, 22, 2);
132 select @@gtid_binlog_state;
133 @@gtid_binlog_state
134 1-11-4,2-21-2
135 #wait for sync cluster 2 and 1
136 connection node_4;
137 include/save_master_gtid.inc
138 connection node_1;
139 include/sync_with_master_gtid.inc
140 select * from t1 order by 1, 2, 3;
141 cluster_domain_id node_server_id seq_no
142 1 11 2
143 1 12 3
144 1 13 4
145 2 21 1
146 2 22 2
147 cluster 2 node 3
148 connection node_6;
149 select @@gtid_binlog_state;
150 @@gtid_binlog_state
151 1-11-4,2-21-2
152 insert into t1 values (2, 23, 3);
153 select @@gtid_binlog_state;
154 @@gtid_binlog_state
155 1-11-4,2-21-3
156 #wait for sync cluster 2 and 1
157 connection node_4;
158 include/save_master_gtid.inc
159 connection node_1;
160 include/sync_with_master_gtid.inc
161 select * from t1 order by 1, 2, 3;
162 cluster_domain_id node_server_id seq_no
163 1 11 2
164 1 12 3
165 1 13 4
166 2 21 1
167 2 22 2
168 2 23 3
169 # check other nodes are consistent
170 connection node_2;
171 select @@gtid_binlog_state;
172 @@gtid_binlog_state
173 1-11-4,2-21-3
174 select * from t1 order by 1, 2, 3;
175 cluster_domain_id node_server_id seq_no
176 1 11 2
177 1 12 3
178 1 13 4
179 2 21 1
180 2 22 2
181 2 23 3
182 connection node_3;
183 select @@gtid_binlog_state;
184 @@gtid_binlog_state
185 1-11-4,2-21-3
186 select * from t1 order by 1, 2, 3;
187 cluster_domain_id node_server_id seq_no
188 1 11 2
189 1 12 3
190 1 13 4
191 2 21 1
192 2 22 2
193 2 23 3
194 connection node_5;
195 select @@gtid_binlog_state;
196 @@gtid_binlog_state
197 1-11-4,2-21-3
198 select * from t1 order by 1, 2, 3;
199 cluster_domain_id node_server_id seq_no
200 1 11 2
201 1 12 3
202 1 13 4
203 2 21 1
204 2 22 2
205 2 23 3
206 connection node_6;
207 select @@gtid_binlog_state;
208 @@gtid_binlog_state
209 1-11-4,2-21-3
210 select * from t1 order by 1, 2, 3;
211 cluster_domain_id node_server_id seq_no
212 1 11 2
213 1 12 3
214 1 13 4
215 2 21 1
216 2 22 2
217 2 23 3
218 cluster 1 node 1
219 connection node_1;
220 select @@gtid_binlog_state;
221 @@gtid_binlog_state
222 1-11-4,2-21-3
223 drop table t1;
224 stop slave;
225 reset slave;
226 Warnings:
227 Note 4190 RESET SLAVE is implicitly changing the value of 'Using_Gtid' from 'Current_Pos' to 'Slave_Pos'
228 cluster 2 node 1
229 connection node_4;
230 stop slave;
231 reset slave;
232 Warnings:
233 Note 4190 RESET SLAVE is implicitly changing the value of 'Using_Gtid' from 'Current_Pos' to 'Slave_Pos'
234 cluster 1 node 1
235 connection node_1;
236 change master to master_use_gtid=no, ignore_server_ids=();
237 set global wsrep_on=OFF;
238 reset master;
239 set global wsrep_on=ON;
240 set global GTID_SLAVE_POS="";
241 cluster 2 node 1
242 connection node_4;
243 change master to master_use_gtid=no, ignore_server_ids=();
244 set global wsrep_on=OFF;
245 reset master;
246 set global wsrep_on=ON;
247 set global GTID_SLAVE_POS="";
248 connection node_2;
249 set global wsrep_on=OFF;
250 reset master;
251 set global wsrep_on=ON;
252 connection node_3;
253 set global wsrep_on=OFF;
254 reset master;
255 set global wsrep_on=ON;
256 connection node_5;
257 set global wsrep_on=OFF;
258 reset master;
259 set global wsrep_on=ON;
260 connection node_6;
261 set global wsrep_on=OFF;
262 reset master;
263 set global wsrep_on=ON;
264 connection node_1;
265 --- ignore_server_ids=(12,13)
266 start slave;
267 include/wait_for_slave_to_start.inc
268 select @@gtid_binlog_state;
269 @@gtid_binlog_state
270
271 select @@gtid_slave_pos;
272 @@gtid_slave_pos
273
274 connection node_4;
275 --- ignore_server_ids=(22,23)
276 start slave;
277 include/wait_for_slave_to_start.inc
278 select @@gtid_binlog_state;
279 @@gtid_binlog_state
280
281 select @@gtid_slave_pos;
282 @@gtid_slave_pos
283
284 cluster 1 node 1
285 connection node_1;
286 create table t1 (cluster_domain_id int ,node_server_id int, seq_no int);
287 insert into t1 values (1, 11, 2);
288 select @@gtid_binlog_state;
289 @@gtid_binlog_state
290 1-11-7
291 #wait for sync cluster 1 and 2
292 connection node_1;
293 include/save_master_gtid.inc
294 connection node_4;
295 include/sync_with_master_gtid.inc
296 cluster 2 node 1
297 connection node_4;
298 insert into t1 values (2, 21, 1);
299 select @@gtid_binlog_state;
300 @@gtid_binlog_state
301 1-11-7,2-21-4
302 #wait for sync cluster 1 and 2
303 connection node_1;
304 include/save_master_gtid.inc
305 connection node_4;
306 include/sync_with_master_gtid.inc
307 select * from t1 order by 1, 2, 3;
308 cluster_domain_id node_server_id seq_no
309 1 11 2
310 2 21 1
311 cluster 1 node 2
312 connection node_2;
313 select @@gtid_binlog_state;
314 @@gtid_binlog_state
315 1-11-7,2-21-4
316 insert into t1 values (1, 12, 3);
317 select @@gtid_binlog_state;
318 @@gtid_binlog_state
319 1-11-8,2-21-4
320 #wait for sync cluster 1 and 2
321 connection node_1;
322 include/save_master_gtid.inc
323 connection node_4;
324 include/sync_with_master_gtid.inc
325 select * from t1 order by 1, 2, 3;
326 cluster_domain_id node_server_id seq_no
327 1 11 2
328 1 12 3
329 2 21 1
330 cluster 1 node 3
331 connection node_3;
332 select @@gtid_binlog_state;
333 @@gtid_binlog_state
334 1-11-8,2-21-4
335 insert into t1 values (1, 13, 4);
336 select @@gtid_binlog_state;
337 @@gtid_binlog_state
338 1-11-9,2-21-4
339 #wait for sync cluster 1 and 2
340 connection node_1;
341 include/save_master_gtid.inc
342 connection node_4;
343 include/sync_with_master_gtid.inc
344 select * from t1 order by 1, 2, 3;
345 cluster_domain_id node_server_id seq_no
346 1 11 2
347 1 12 3
348 1 13 4
349 2 21 1
350 cluster 2 node 2
351 connection node_5;
352 select @@gtid_binlog_state;
353 @@gtid_binlog_state
354 1-11-9,2-21-4
355 insert into t1 values (2, 22, 2);
356 select @@gtid_binlog_state;
357 @@gtid_binlog_state
358 1-11-9,2-21-5
359 #wait for sync cluster 2 and 1
360 connection node_4;
361 include/save_master_gtid.inc
362 connection node_1;
363 include/sync_with_master_gtid.inc
364 select * from t1 order by 1, 2, 3;
365 cluster_domain_id node_server_id seq_no
366 1 11 2
367 1 12 3
368 1 13 4
369 2 21 1
370 2 22 2
371 cluster 2 node 3
372 connection node_6;
373 select @@gtid_binlog_state;
374 @@gtid_binlog_state
375 1-11-9,2-21-5
376 insert into t1 values (2, 23, 3);
377 select @@gtid_binlog_state;
378 @@gtid_binlog_state
379 1-11-9,2-21-6
380 #wait for sync cluster 2 and 1
381 connection node_4;
382 include/save_master_gtid.inc
383 connection node_1;
384 include/sync_with_master_gtid.inc
385 select * from t1 order by 1, 2, 3;
386 cluster_domain_id node_server_id seq_no
387 1 11 2
388 1 12 3
389 1 13 4
390 2 21 1
391 2 22 2
392 2 23 3
393 # check other nodes are consistent
394 connection node_2;
395 select @@gtid_binlog_state;
396 @@gtid_binlog_state
397 1-11-9,2-21-6
398 select * from t1 order by 1, 2, 3;
399 cluster_domain_id node_server_id seq_no
400 1 11 2
401 1 12 3
402 1 13 4
403 2 21 1
404 2 22 2
405 2 23 3
406 connection node_3;
407 select @@gtid_binlog_state;
408 @@gtid_binlog_state
409 1-11-9,2-21-6
410 select * from t1 order by 1, 2, 3;
411 cluster_domain_id node_server_id seq_no
412 1 11 2
413 1 12 3
414 1 13 4
415 2 21 1
416 2 22 2
417 2 23 3
418 connection node_5;
419 select @@gtid_binlog_state;
420 @@gtid_binlog_state
421 1-11-9,2-21-6
422 select * from t1 order by 1, 2, 3;
423 cluster_domain_id node_server_id seq_no
424 1 11 2
425 1 12 3
426 1 13 4
427 2 21 1
428 2 22 2
429 2 23 3
430 connection node_6;
431 select @@gtid_binlog_state;
432 @@gtid_binlog_state
433 1-11-9,2-21-6
434 select * from t1 order by 1, 2, 3;
435 cluster_domain_id node_server_id seq_no
436 1 11 2
437 1 12 3
438 1 13 4
439 2 21 1
440 2 22 2
441 2 23 3
442 cluster 1 node 1
443 connection node_1;
444 select @@gtid_binlog_state;
445 @@gtid_binlog_state
446 1-11-9,2-21-6
447 drop table t1;
448 stop slave;
449 change master to master_use_gtid=no, ignore_server_ids=();
450 set global wsrep_on=OFF;
451 reset master;
452 set global wsrep_on=ON;
453 set global GTID_SLAVE_POS="";
454 cluster 2 node 1
455 connection node_4;
456 stop slave;
457 change master to master_use_gtid=no, ignore_server_ids=();
458 set global wsrep_on=OFF;
459 reset master;
460 set global wsrep_on=ON;
461 set global GTID_SLAVE_POS="";
462 connection node_2;
463 set global wsrep_on=OFF;
464 reset master;
465 set global wsrep_on=ON;
466 connection node_3;
467 set global wsrep_on=OFF;
468 reset master;
469 set global wsrep_on=ON;
470 connection node_5;
471 set global wsrep_on=OFF;
472 reset master;
473 set global wsrep_on=ON;
474 connection node_6;
475 set global wsrep_on=OFF;
476 reset master;
477 set global wsrep_on=ON;