Debian Codegraph @

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