Debian Codegraph @

mysql-test/suite/rpl/r/rpl_row_img_sequence_noblob.result

raw
1 include/rpl_init.inc [topology=1->2->3]
2 connection server_1;
3 connection server_2;
4 connection server_3;
5 connection server_1;
6 #
7 # binlog_row_image=NOBLOB should write all columns to the binary logs
8 #
9 CON: 'server_1', IMG: 'NOBLOB', RESTART SLAVE: 'N'
10 connection server_1;
11 SET SESSION binlog_row_image= 'NOBLOB';
12 SET GLOBAL binlog_row_image= 'NOBLOB';
13 FLUSH TABLES;
14 SHOW VARIABLES LIKE 'binlog_row_image';
15 Variable_name Value
16 binlog_row_image NOBLOB
17 CON: 'server_2', IMG: 'NOBLOB', RESTART SLAVE: 'Y'
18 connection server_2;
19 SET SESSION binlog_row_image= 'NOBLOB';
20 SET GLOBAL binlog_row_image= 'NOBLOB';
21 include/stop_slave.inc
22 include/start_slave.inc
23 FLUSH TABLES;
24 SHOW VARIABLES LIKE 'binlog_row_image';
25 Variable_name Value
26 binlog_row_image NOBLOB
27 CON: 'server_3', IMG: 'NOBLOB', RESTART SLAVE: 'Y'
28 connection server_3;
29 SET SESSION binlog_row_image= 'NOBLOB';
30 SET GLOBAL binlog_row_image= 'NOBLOB';
31 include/stop_slave.inc
32 include/start_slave.inc
33 FLUSH TABLES;
34 SHOW VARIABLES LIKE 'binlog_row_image';
35 Variable_name Value
36 binlog_row_image NOBLOB
37 connection server_1;
38 ### engines: MyISAM, MyISAM, MyISAM
39 # Create sequences with specific engines per server
40 connection server_1;
41 SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
42 include/save_master_gtid.inc
43 connection server_2;
44 SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
45 include/sync_with_master_gtid.inc
46 connection server_3;
47 SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
48 include/sync_with_master_gtid.inc
49 # Pt.1 Ensure SETVAL replicates and binlogs correctly
50 connection server_1;
51 SELECT SETVAL(s1, 10);
52 SETVAL(s1, 10)
53 10
54 include/save_master_gtid.inc
55 # Validate SETVAL replicated correctly to other servers
56 connection server_3;
57 include/sync_with_master_gtid.inc
58 include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
59 # Validate server_1 binlogged SETVAL with the correct columns
60 connection server_1;
61 FLUSH LOGS;
62 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
63 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
64 # Verifying all expected column ids appear in binlog event output..
65 # ..success
66 # Verifying only expected column ids appear in binlog event output..
67 # ..success
68 # Validate server_2 binlogged SETVAL with the correct columns
69 connection server_2;
70 FLUSH LOGS;
71 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
72 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
73 # Verifying all expected column ids appear in binlog event output..
74 # ..success
75 # Verifying only expected column ids appear in binlog event output..
76 # ..success
77 # Validate server_3 binlogged SETVAL with the correct columns
78 connection server_3;
79 FLUSH LOGS;
80 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
81 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
82 # Verifying all expected column ids appear in binlog event output..
83 # ..success
84 # Verifying only expected column ids appear in binlog event output..
85 # ..success
86 # Pt.2 Ensure NEXTVAL replicates and binlogs correctly
87 connection server_1;
88 SELECT NEXTVAL(s1);
89 NEXTVAL(s1)
90 11
91 include/save_master_gtid.inc
92 # Validate NEXTVAL replicated correctly to other servers
93 connection server_3;
94 include/sync_with_master_gtid.inc
95 include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
96 # Validate server_1 binlogged NEXTVAL with the correct columns
97 connection server_1;
98 FLUSH LOGS;
99 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
100 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
101 # Verifying all expected column ids appear in binlog event output..
102 # ..success
103 # Verifying only expected column ids appear in binlog event output..
104 # ..success
105 # Validate server_2 binlogged NEXTVAL with the correct columns
106 connection server_2;
107 FLUSH LOGS;
108 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
109 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
110 # Verifying all expected column ids appear in binlog event output..
111 # ..success
112 # Verifying only expected column ids appear in binlog event output..
113 # ..success
114 # Validate server_3 binlogged NEXTVAL with the correct columns
115 connection server_3;
116 FLUSH LOGS;
117 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
118 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
119 # Verifying all expected column ids appear in binlog event output..
120 # ..success
121 # Verifying only expected column ids appear in binlog event output..
122 # ..success
123 # Cleanup
124 connection server_1;
125 DROP TABLE s1;
126 include/save_master_gtid.inc
127 connection server_3;
128 include/sync_with_master_gtid.inc
129 ### engines: MyISAM, MyISAM, InnoDB
130 # Create sequences with specific engines per server
131 connection server_1;
132 SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
133 include/save_master_gtid.inc
134 connection server_2;
135 SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
136 include/sync_with_master_gtid.inc
137 connection server_3;
138 SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
139 include/sync_with_master_gtid.inc
140 # Pt.1 Ensure SETVAL replicates and binlogs correctly
141 connection server_1;
142 SELECT SETVAL(s1, 10);
143 SETVAL(s1, 10)
144 10
145 include/save_master_gtid.inc
146 # Validate SETVAL replicated correctly to other servers
147 connection server_3;
148 include/sync_with_master_gtid.inc
149 include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
150 # Validate server_1 binlogged SETVAL with the correct columns
151 connection server_1;
152 FLUSH LOGS;
153 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
154 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
155 # Verifying all expected column ids appear in binlog event output..
156 # ..success
157 # Verifying only expected column ids appear in binlog event output..
158 # ..success
159 # Validate server_2 binlogged SETVAL with the correct columns
160 connection server_2;
161 FLUSH LOGS;
162 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
163 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
164 # Verifying all expected column ids appear in binlog event output..
165 # ..success
166 # Verifying only expected column ids appear in binlog event output..
167 # ..success
168 # Validate server_3 binlogged SETVAL with the correct columns
169 connection server_3;
170 FLUSH LOGS;
171 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
172 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
173 # Verifying all expected column ids appear in binlog event output..
174 # ..success
175 # Verifying only expected column ids appear in binlog event output..
176 # ..success
177 # Pt.2 Ensure NEXTVAL replicates and binlogs correctly
178 connection server_1;
179 SELECT NEXTVAL(s1);
180 NEXTVAL(s1)
181 11
182 include/save_master_gtid.inc
183 # Validate NEXTVAL replicated correctly to other servers
184 connection server_3;
185 include/sync_with_master_gtid.inc
186 include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
187 # Validate server_1 binlogged NEXTVAL with the correct columns
188 connection server_1;
189 FLUSH LOGS;
190 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
191 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
192 # Verifying all expected column ids appear in binlog event output..
193 # ..success
194 # Verifying only expected column ids appear in binlog event output..
195 # ..success
196 # Validate server_2 binlogged NEXTVAL with the correct columns
197 connection server_2;
198 FLUSH LOGS;
199 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
200 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
201 # Verifying all expected column ids appear in binlog event output..
202 # ..success
203 # Verifying only expected column ids appear in binlog event output..
204 # ..success
205 # Validate server_3 binlogged NEXTVAL with the correct columns
206 connection server_3;
207 FLUSH LOGS;
208 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
209 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
210 # Verifying all expected column ids appear in binlog event output..
211 # ..success
212 # Verifying only expected column ids appear in binlog event output..
213 # ..success
214 # Cleanup
215 connection server_1;
216 DROP TABLE s1;
217 include/save_master_gtid.inc
218 connection server_3;
219 include/sync_with_master_gtid.inc
220 ### engines: MyISAM, InnoDB, MyISAM
221 # Create sequences with specific engines per server
222 connection server_1;
223 SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
224 include/save_master_gtid.inc
225 connection server_2;
226 SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
227 include/sync_with_master_gtid.inc
228 connection server_3;
229 SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
230 include/sync_with_master_gtid.inc
231 # Pt.1 Ensure SETVAL replicates and binlogs correctly
232 connection server_1;
233 SELECT SETVAL(s1, 10);
234 SETVAL(s1, 10)
235 10
236 include/save_master_gtid.inc
237 # Validate SETVAL replicated correctly to other servers
238 connection server_3;
239 include/sync_with_master_gtid.inc
240 include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
241 # Validate server_1 binlogged SETVAL with the correct columns
242 connection server_1;
243 FLUSH LOGS;
244 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
245 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
246 # Verifying all expected column ids appear in binlog event output..
247 # ..success
248 # Verifying only expected column ids appear in binlog event output..
249 # ..success
250 # Validate server_2 binlogged SETVAL with the correct columns
251 connection server_2;
252 FLUSH LOGS;
253 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
254 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
255 # Verifying all expected column ids appear in binlog event output..
256 # ..success
257 # Verifying only expected column ids appear in binlog event output..
258 # ..success
259 # Validate server_3 binlogged SETVAL with the correct columns
260 connection server_3;
261 FLUSH LOGS;
262 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
263 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
264 # Verifying all expected column ids appear in binlog event output..
265 # ..success
266 # Verifying only expected column ids appear in binlog event output..
267 # ..success
268 # Pt.2 Ensure NEXTVAL replicates and binlogs correctly
269 connection server_1;
270 SELECT NEXTVAL(s1);
271 NEXTVAL(s1)
272 11
273 include/save_master_gtid.inc
274 # Validate NEXTVAL replicated correctly to other servers
275 connection server_3;
276 include/sync_with_master_gtid.inc
277 include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
278 # Validate server_1 binlogged NEXTVAL with the correct columns
279 connection server_1;
280 FLUSH LOGS;
281 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
282 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
283 # Verifying all expected column ids appear in binlog event output..
284 # ..success
285 # Verifying only expected column ids appear in binlog event output..
286 # ..success
287 # Validate server_2 binlogged NEXTVAL with the correct columns
288 connection server_2;
289 FLUSH LOGS;
290 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
291 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
292 # Verifying all expected column ids appear in binlog event output..
293 # ..success
294 # Verifying only expected column ids appear in binlog event output..
295 # ..success
296 # Validate server_3 binlogged NEXTVAL with the correct columns
297 connection server_3;
298 FLUSH LOGS;
299 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
300 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
301 # Verifying all expected column ids appear in binlog event output..
302 # ..success
303 # Verifying only expected column ids appear in binlog event output..
304 # ..success
305 # Cleanup
306 connection server_1;
307 DROP TABLE s1;
308 include/save_master_gtid.inc
309 connection server_3;
310 include/sync_with_master_gtid.inc
311 ### engines: MyISAM, InnoDB, InnoDB
312 # Create sequences with specific engines per server
313 connection server_1;
314 SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
315 include/save_master_gtid.inc
316 connection server_2;
317 SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
318 include/sync_with_master_gtid.inc
319 connection server_3;
320 SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
321 include/sync_with_master_gtid.inc
322 # Pt.1 Ensure SETVAL replicates and binlogs correctly
323 connection server_1;
324 SELECT SETVAL(s1, 10);
325 SETVAL(s1, 10)
326 10
327 include/save_master_gtid.inc
328 # Validate SETVAL replicated correctly to other servers
329 connection server_3;
330 include/sync_with_master_gtid.inc
331 include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
332 # Validate server_1 binlogged SETVAL with the correct columns
333 connection server_1;
334 FLUSH LOGS;
335 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
336 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
337 # Verifying all expected column ids appear in binlog event output..
338 # ..success
339 # Verifying only expected column ids appear in binlog event output..
340 # ..success
341 # Validate server_2 binlogged SETVAL with the correct columns
342 connection server_2;
343 FLUSH LOGS;
344 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
345 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
346 # Verifying all expected column ids appear in binlog event output..
347 # ..success
348 # Verifying only expected column ids appear in binlog event output..
349 # ..success
350 # Validate server_3 binlogged SETVAL with the correct columns
351 connection server_3;
352 FLUSH LOGS;
353 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
354 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
355 # Verifying all expected column ids appear in binlog event output..
356 # ..success
357 # Verifying only expected column ids appear in binlog event output..
358 # ..success
359 # Pt.2 Ensure NEXTVAL replicates and binlogs correctly
360 connection server_1;
361 SELECT NEXTVAL(s1);
362 NEXTVAL(s1)
363 11
364 include/save_master_gtid.inc
365 # Validate NEXTVAL replicated correctly to other servers
366 connection server_3;
367 include/sync_with_master_gtid.inc
368 include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
369 # Validate server_1 binlogged NEXTVAL with the correct columns
370 connection server_1;
371 FLUSH LOGS;
372 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
373 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
374 # Verifying all expected column ids appear in binlog event output..
375 # ..success
376 # Verifying only expected column ids appear in binlog event output..
377 # ..success
378 # Validate server_2 binlogged NEXTVAL with the correct columns
379 connection server_2;
380 FLUSH LOGS;
381 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
382 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
383 # Verifying all expected column ids appear in binlog event output..
384 # ..success
385 # Verifying only expected column ids appear in binlog event output..
386 # ..success
387 # Validate server_3 binlogged NEXTVAL with the correct columns
388 connection server_3;
389 FLUSH LOGS;
390 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
391 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
392 # Verifying all expected column ids appear in binlog event output..
393 # ..success
394 # Verifying only expected column ids appear in binlog event output..
395 # ..success
396 # Cleanup
397 connection server_1;
398 DROP TABLE s1;
399 include/save_master_gtid.inc
400 connection server_3;
401 include/sync_with_master_gtid.inc
402 ### engines: InnoDB, MyISAM, MyISAM
403 # Create sequences with specific engines per server
404 connection server_1;
405 SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
406 include/save_master_gtid.inc
407 connection server_2;
408 SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
409 include/sync_with_master_gtid.inc
410 connection server_3;
411 SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
412 include/sync_with_master_gtid.inc
413 # Pt.1 Ensure SETVAL replicates and binlogs correctly
414 connection server_1;
415 SELECT SETVAL(s1, 10);
416 SETVAL(s1, 10)
417 10
418 include/save_master_gtid.inc
419 # Validate SETVAL replicated correctly to other servers
420 connection server_3;
421 include/sync_with_master_gtid.inc
422 include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
423 # Validate server_1 binlogged SETVAL with the correct columns
424 connection server_1;
425 FLUSH LOGS;
426 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
427 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
428 # Verifying all expected column ids appear in binlog event output..
429 # ..success
430 # Verifying only expected column ids appear in binlog event output..
431 # ..success
432 # Validate server_2 binlogged SETVAL with the correct columns
433 connection server_2;
434 FLUSH LOGS;
435 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
436 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
437 # Verifying all expected column ids appear in binlog event output..
438 # ..success
439 # Verifying only expected column ids appear in binlog event output..
440 # ..success
441 # Validate server_3 binlogged SETVAL with the correct columns
442 connection server_3;
443 FLUSH LOGS;
444 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
445 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
446 # Verifying all expected column ids appear in binlog event output..
447 # ..success
448 # Verifying only expected column ids appear in binlog event output..
449 # ..success
450 # Pt.2 Ensure NEXTVAL replicates and binlogs correctly
451 connection server_1;
452 SELECT NEXTVAL(s1);
453 NEXTVAL(s1)
454 11
455 include/save_master_gtid.inc
456 # Validate NEXTVAL replicated correctly to other servers
457 connection server_3;
458 include/sync_with_master_gtid.inc
459 include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
460 # Validate server_1 binlogged NEXTVAL with the correct columns
461 connection server_1;
462 FLUSH LOGS;
463 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
464 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
465 # Verifying all expected column ids appear in binlog event output..
466 # ..success
467 # Verifying only expected column ids appear in binlog event output..
468 # ..success
469 # Validate server_2 binlogged NEXTVAL with the correct columns
470 connection server_2;
471 FLUSH LOGS;
472 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
473 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
474 # Verifying all expected column ids appear in binlog event output..
475 # ..success
476 # Verifying only expected column ids appear in binlog event output..
477 # ..success
478 # Validate server_3 binlogged NEXTVAL with the correct columns
479 connection server_3;
480 FLUSH LOGS;
481 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
482 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
483 # Verifying all expected column ids appear in binlog event output..
484 # ..success
485 # Verifying only expected column ids appear in binlog event output..
486 # ..success
487 # Cleanup
488 connection server_1;
489 DROP TABLE s1;
490 include/save_master_gtid.inc
491 connection server_3;
492 include/sync_with_master_gtid.inc
493 ### engines: InnoDB, MyISAM, InnoDB
494 # Create sequences with specific engines per server
495 connection server_1;
496 SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
497 include/save_master_gtid.inc
498 connection server_2;
499 SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
500 include/sync_with_master_gtid.inc
501 connection server_3;
502 SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
503 include/sync_with_master_gtid.inc
504 # Pt.1 Ensure SETVAL replicates and binlogs correctly
505 connection server_1;
506 SELECT SETVAL(s1, 10);
507 SETVAL(s1, 10)
508 10
509 include/save_master_gtid.inc
510 # Validate SETVAL replicated correctly to other servers
511 connection server_3;
512 include/sync_with_master_gtid.inc
513 include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
514 # Validate server_1 binlogged SETVAL with the correct columns
515 connection server_1;
516 FLUSH LOGS;
517 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
518 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
519 # Verifying all expected column ids appear in binlog event output..
520 # ..success
521 # Verifying only expected column ids appear in binlog event output..
522 # ..success
523 # Validate server_2 binlogged SETVAL with the correct columns
524 connection server_2;
525 FLUSH LOGS;
526 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
527 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
528 # Verifying all expected column ids appear in binlog event output..
529 # ..success
530 # Verifying only expected column ids appear in binlog event output..
531 # ..success
532 # Validate server_3 binlogged SETVAL with the correct columns
533 connection server_3;
534 FLUSH LOGS;
535 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
536 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
537 # Verifying all expected column ids appear in binlog event output..
538 # ..success
539 # Verifying only expected column ids appear in binlog event output..
540 # ..success
541 # Pt.2 Ensure NEXTVAL replicates and binlogs correctly
542 connection server_1;
543 SELECT NEXTVAL(s1);
544 NEXTVAL(s1)
545 11
546 include/save_master_gtid.inc
547 # Validate NEXTVAL replicated correctly to other servers
548 connection server_3;
549 include/sync_with_master_gtid.inc
550 include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
551 # Validate server_1 binlogged NEXTVAL with the correct columns
552 connection server_1;
553 FLUSH LOGS;
554 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
555 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
556 # Verifying all expected column ids appear in binlog event output..
557 # ..success
558 # Verifying only expected column ids appear in binlog event output..
559 # ..success
560 # Validate server_2 binlogged NEXTVAL with the correct columns
561 connection server_2;
562 FLUSH LOGS;
563 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
564 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
565 # Verifying all expected column ids appear in binlog event output..
566 # ..success
567 # Verifying only expected column ids appear in binlog event output..
568 # ..success
569 # Validate server_3 binlogged NEXTVAL with the correct columns
570 connection server_3;
571 FLUSH LOGS;
572 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
573 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
574 # Verifying all expected column ids appear in binlog event output..
575 # ..success
576 # Verifying only expected column ids appear in binlog event output..
577 # ..success
578 # Cleanup
579 connection server_1;
580 DROP TABLE s1;
581 include/save_master_gtid.inc
582 connection server_3;
583 include/sync_with_master_gtid.inc
584 ### engines: InnoDB, InnoDB, MyISAM
585 # Create sequences with specific engines per server
586 connection server_1;
587 SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
588 include/save_master_gtid.inc
589 connection server_2;
590 SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
591 include/sync_with_master_gtid.inc
592 connection server_3;
593 SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=MyISAM;
594 include/sync_with_master_gtid.inc
595 # Pt.1 Ensure SETVAL replicates and binlogs correctly
596 connection server_1;
597 SELECT SETVAL(s1, 10);
598 SETVAL(s1, 10)
599 10
600 include/save_master_gtid.inc
601 # Validate SETVAL replicated correctly to other servers
602 connection server_3;
603 include/sync_with_master_gtid.inc
604 include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
605 # Validate server_1 binlogged SETVAL with the correct columns
606 connection server_1;
607 FLUSH LOGS;
608 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
609 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
610 # Verifying all expected column ids appear in binlog event output..
611 # ..success
612 # Verifying only expected column ids appear in binlog event output..
613 # ..success
614 # Validate server_2 binlogged SETVAL with the correct columns
615 connection server_2;
616 FLUSH LOGS;
617 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
618 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
619 # Verifying all expected column ids appear in binlog event output..
620 # ..success
621 # Verifying only expected column ids appear in binlog event output..
622 # ..success
623 # Validate server_3 binlogged SETVAL with the correct columns
624 connection server_3;
625 FLUSH LOGS;
626 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
627 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
628 # Verifying all expected column ids appear in binlog event output..
629 # ..success
630 # Verifying only expected column ids appear in binlog event output..
631 # ..success
632 # Pt.2 Ensure NEXTVAL replicates and binlogs correctly
633 connection server_1;
634 SELECT NEXTVAL(s1);
635 NEXTVAL(s1)
636 11
637 include/save_master_gtid.inc
638 # Validate NEXTVAL replicated correctly to other servers
639 connection server_3;
640 include/sync_with_master_gtid.inc
641 include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
642 # Validate server_1 binlogged NEXTVAL with the correct columns
643 connection server_1;
644 FLUSH LOGS;
645 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
646 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
647 # Verifying all expected column ids appear in binlog event output..
648 # ..success
649 # Verifying only expected column ids appear in binlog event output..
650 # ..success
651 # Validate server_2 binlogged NEXTVAL with the correct columns
652 connection server_2;
653 FLUSH LOGS;
654 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
655 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
656 # Verifying all expected column ids appear in binlog event output..
657 # ..success
658 # Verifying only expected column ids appear in binlog event output..
659 # ..success
660 # Validate server_3 binlogged NEXTVAL with the correct columns
661 connection server_3;
662 FLUSH LOGS;
663 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
664 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
665 # Verifying all expected column ids appear in binlog event output..
666 # ..success
667 # Verifying only expected column ids appear in binlog event output..
668 # ..success
669 # Cleanup
670 connection server_1;
671 DROP TABLE s1;
672 include/save_master_gtid.inc
673 connection server_3;
674 include/sync_with_master_gtid.inc
675 ### engines: InnoDB, InnoDB, InnoDB
676 # Create sequences with specific engines per server
677 connection server_1;
678 SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
679 include/save_master_gtid.inc
680 connection server_2;
681 SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
682 include/sync_with_master_gtid.inc
683 connection server_3;
684 SET STATEMENT sql_log_bin=0 FOR create sequence s1 cache=0 engine=InnoDB;
685 include/sync_with_master_gtid.inc
686 # Pt.1 Ensure SETVAL replicates and binlogs correctly
687 connection server_1;
688 SELECT SETVAL(s1, 10);
689 SETVAL(s1, 10)
690 10
691 include/save_master_gtid.inc
692 # Validate SETVAL replicated correctly to other servers
693 connection server_3;
694 include/sync_with_master_gtid.inc
695 include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
696 # Validate server_1 binlogged SETVAL with the correct columns
697 connection server_1;
698 FLUSH LOGS;
699 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
700 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
701 # Verifying all expected column ids appear in binlog event output..
702 # ..success
703 # Verifying only expected column ids appear in binlog event output..
704 # ..success
705 # Validate server_2 binlogged SETVAL with the correct columns
706 connection server_2;
707 FLUSH LOGS;
708 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
709 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
710 # Verifying all expected column ids appear in binlog event output..
711 # ..success
712 # Verifying only expected column ids appear in binlog event output..
713 # ..success
714 # Validate server_3 binlogged SETVAL with the correct columns
715 connection server_3;
716 FLUSH LOGS;
717 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
718 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
719 # Verifying all expected column ids appear in binlog event output..
720 # ..success
721 # Verifying only expected column ids appear in binlog event output..
722 # ..success
723 # Pt.2 Ensure NEXTVAL replicates and binlogs correctly
724 connection server_1;
725 SELECT NEXTVAL(s1);
726 NEXTVAL(s1)
727 11
728 include/save_master_gtid.inc
729 # Validate NEXTVAL replicated correctly to other servers
730 connection server_3;
731 include/sync_with_master_gtid.inc
732 include/diff_tables.inc [server_1:test.s1,server_2:test.s1,server_3:test.s1]
733 # Validate server_1 binlogged NEXTVAL with the correct columns
734 connection server_1;
735 FLUSH LOGS;
736 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
737 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
738 # Verifying all expected column ids appear in binlog event output..
739 # ..success
740 # Verifying only expected column ids appear in binlog event output..
741 # ..success
742 # Validate server_2 binlogged NEXTVAL with the correct columns
743 connection server_2;
744 FLUSH LOGS;
745 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
746 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
747 # Verifying all expected column ids appear in binlog event output..
748 # ..success
749 # Verifying only expected column ids appear in binlog event output..
750 # ..success
751 # Validate server_3 binlogged NEXTVAL with the correct columns
752 connection server_3;
753 FLUSH LOGS;
754 include/ensure_binlog_row_event_columns.inc [(1,2,3,4,5,6,7,8)]
755 # MYSQL_BINLOG mysqld_datadir/binlog_filename -vv > assert_file
756 # Verifying all expected column ids appear in binlog event output..
757 # ..success
758 # Verifying only expected column ids appear in binlog event output..
759 # ..success
760 # Cleanup
761 connection server_1;
762 DROP TABLE s1;
763 include/save_master_gtid.inc
764 connection server_3;
765 include/sync_with_master_gtid.inc
766 CON: 'server_1', IMG: 'FULL', RESTART SLAVE: 'N'
767 connection server_1;
768 SET SESSION binlog_row_image= 'FULL';
769 SET GLOBAL binlog_row_image= 'FULL';
770 FLUSH TABLES;
771 SHOW VARIABLES LIKE 'binlog_row_image';
772 Variable_name Value
773 binlog_row_image FULL
774 CON: 'server_2', IMG: 'FULL', RESTART SLAVE: 'Y'
775 connection server_2;
776 SET SESSION binlog_row_image= 'FULL';
777 SET GLOBAL binlog_row_image= 'FULL';
778 include/stop_slave.inc
779 include/start_slave.inc
780 FLUSH TABLES;
781 SHOW VARIABLES LIKE 'binlog_row_image';
782 Variable_name Value
783 binlog_row_image FULL
784 CON: 'server_3', IMG: 'FULL', RESTART SLAVE: 'Y'
785 connection server_3;
786 SET SESSION binlog_row_image= 'FULL';
787 SET GLOBAL binlog_row_image= 'FULL';
788 include/stop_slave.inc
789 include/start_slave.inc
790 FLUSH TABLES;
791 SHOW VARIABLES LIKE 'binlog_row_image';
792 Variable_name Value
793 binlog_row_image FULL
794 connection server_3;
795 include/rpl_end.inc
796 # End of tests