Debian Codegraph @

mysql-test/suite/ndb_rpl/r/ndb_rpl_slave_lsu.result

raw
1 include/rpl_init.inc [topology=none]
2 *** Configuring connections ***
3 include/rpl_connect.inc [creating srv_master]
4 include/rpl_connect.inc [creating srv_master1]
5 include/rpl_connect.inc [creating srv_master2]
6 include/rpl_connect.inc [creating srv_slave]
7 include/rpl_connect.inc [creating srv_slave1]
8 include/rpl_connect.inc [creating srv_slave2]
9 *** Waiting for each cluster to startup ***
10 *** Configuring replication via Slave ***
11 [connection srv_slave]
12 include/rpl_change_topology.inc [new topology=1->4]
13 Warnings:
14 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
15 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
16 include/start_slave.inc
17 *** Generating slave cluster originated binloggable changes ***
18 CREATE TABLE bug_45756_slave_logged_1 (a int) engine = NDB;
19 INSERT INTO bug_45756_slave_logged_1 VALUES (1);
20 DROP TABLE bug_45756_slave_logged_1;
21 CREATE TABLE bug_45756_slave_logged_2 (a int) engine = NDB;
22 INSERT INTO bug_45756_slave_logged_2 VALUES (1);
23 DROP TABLE bug_45756_slave_logged_2;
24 CREATE TABLE bug_45756_slave_logged_3 (a int) engine = NDB;
25 INSERT INTO bug_45756_slave_logged_3 VALUES (1);
26 DROP TABLE bug_45756_slave_logged_3;
27 ***Generating slave cluster non-binloggable changes***
28 SET SQL_LOG_BIN= 0;
29 CREATE TABLE bug_45756_slave_not_logged_1 (a int) engine = NDB;
30 INSERT INTO bug_45756_slave_not_logged_1 VALUES (1);
31 DROP TABLE bug_45756_slave_not_logged_1;
32 SET SQL_LOG_BIN= 1;
33 SET SQL_LOG_BIN= 0;
34 CREATE TABLE bug_45756_slave_not_logged_2 (a int) engine = NDB;
35 INSERT INTO bug_45756_slave_not_logged_2 VALUES (1);
36 DROP TABLE bug_45756_slave_not_logged_2;
37 SET SQL_LOG_BIN= 1;
38 SET SQL_LOG_BIN= 0;
39 CREATE TABLE bug_45756_slave_not_logged_3 (a int) engine = NDB;
40 INSERT INTO bug_45756_slave_not_logged_3 VALUES (1);
41 DROP TABLE bug_45756_slave_not_logged_3;
42 SET SQL_LOG_BIN= 1;
43 *** Generating data to be replicated ***
44 CREATE TABLE bug45756_master_logged_1 (a int) engine = NDB;
45 INSERT INTO bug45756_master_logged_1 VALUES (1);
46 DROP TABLE bug45756_master_logged_1;
47 CREATE TABLE bug45756_master_logged_2 (a int) engine = NDB;
48 INSERT INTO bug45756_master_logged_2 VALUES (1);
49 DROP TABLE bug45756_master_logged_2;
50 CREATE TABLE bug45756_master_logged_3 (a int) engine = NDB;
51 INSERT INTO bug45756_master_logged_3 VALUES (1);
52 DROP TABLE bug45756_master_logged_3;
53 *** Generating changes not to be replicated ***
54 SET SQL_LOG_BIN= 0;
55 CREATE TABLE bug45756_master_not_logged_1 (a int) engine = NDB;
56 INSERT INTO bug45756_master_not_logged_1 VALUES (1);
57 DROP TABLE bug45756_master_not_logged_1;
58 SET SQL_LOG_BIN= 1;
59 SET SQL_LOG_BIN= 0;
60 CREATE TABLE bug45756_master_not_logged_2 (a int) engine = NDB;
61 INSERT INTO bug45756_master_not_logged_2 VALUES (1);
62 DROP TABLE bug45756_master_not_logged_2;
63 SET SQL_LOG_BIN= 1;
64 SET SQL_LOG_BIN= 0;
65 CREATE TABLE bug45756_master_not_logged_3 (a int) engine = NDB;
66 INSERT INTO bug45756_master_not_logged_3 VALUES (1);
67 DROP TABLE bug45756_master_not_logged_3;
68 SET SQL_LOG_BIN= 1;
69 *** Checking binlog contents on every server in both clusters ***
70
71
72
73 connection srv_master;
74 show variables like 'server_id';
75 Variable_name Value
76 server_id 1
77 show variables like 'log_bin';
78 Variable_name Value
79 log_bin ON
80 show variables like 'log_replica_updates';
81 Variable_name Value
82 log_replica_updates OFF
83 include/show_binlog_events.inc
84 Log_name Pos Event_type Server_id End_log_pos Info
85 master-bin.000001 # Query 1 # use `test`; CREATE TABLE bug45756_master_logged_1 (a int) engine = NDB
86 master-bin.000001 # Query 1 # BEGIN
87 master-bin.000001 # Table_map 1 # table_id: # (test.bug45756_master_logged_1)
88 master-bin.000001 # Table_map 1 # table_id: # (mysql.ndb_apply_status)
89 master-bin.000001 # Write_rows 1 # table_id: #
90 master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
91 master-bin.000001 # Query 1 # COMMIT
92 master-bin.000001 # Query 1 # use `test`; DROP TABLE `bug45756_master_logged_1` /* generated by server */
93 master-bin.000001 # Query 1 # use `test`; CREATE TABLE bug45756_master_logged_2 (a int) engine = NDB
94 master-bin.000001 # Query 1 # BEGIN
95 master-bin.000001 # Table_map 1 # table_id: # (test.bug45756_master_logged_2)
96 master-bin.000001 # Table_map 1 # table_id: # (mysql.ndb_apply_status)
97 master-bin.000001 # Write_rows 1 # table_id: #
98 master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
99 master-bin.000001 # Query 1 # COMMIT
100 master-bin.000001 # Query 1 # use `test`; drop table `test`.`bug45756_master_logged_2`
101 master-bin.000001 # Query 1 # use `test`; CREATE TABLE bug45756_master_logged_3 (a int) engine = NDB
102 master-bin.000001 # Query 1 # BEGIN
103 master-bin.000001 # Table_map 1 # table_id: # (test.bug45756_master_logged_3)
104 master-bin.000001 # Table_map 1 # table_id: # (mysql.ndb_apply_status)
105 master-bin.000001 # Write_rows 1 # table_id: #
106 master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
107 master-bin.000001 # Query 1 # COMMIT
108 master-bin.000001 # Query 1 # use `test`; drop table `test`.`bug45756_master_logged_3`
109 select 'server id' and 'event type' from mysqlbinlog output
110 binlog_entries
111 server id 1 Query
112 server id 1 Query
113 server id 1 Table_map: `test`.`bug45756_master_logged_1`
114 server id 1 Table_map: `mysql`.`ndb_apply_status`
115 server id 1 Write_rows:
116 server id 1 Write_rows: flags: STMT_END_F
117 server id 1 Query
118 server id 1 Query
119 server id 1 Query
120 server id 1 Query
121 server id 1 Table_map: `test`.`bug45756_master_logged_2`
122 server id 1 Table_map: `mysql`.`ndb_apply_status`
123 server id 1 Write_rows:
124 server id 1 Write_rows: flags: STMT_END_F
125 server id 1 Query
126 server id 1 Query
127 server id 1 Query
128 server id 1 Query
129 server id 1 Table_map: `test`.`bug45756_master_logged_3`
130 server id 1 Table_map: `mysql`.`ndb_apply_status`
131 server id 1 Write_rows:
132 server id 1 Write_rows: flags: STMT_END_F
133 server id 1 Query
134 server id 1 Query
135
136
137
138 connection srv_master1;
139 show variables like 'server_id';
140 Variable_name Value
141 server_id 2
142 show variables like 'log_bin';
143 Variable_name Value
144 log_bin OFF
145 show variables like 'log_replica_updates';
146 Variable_name Value
147 log_replica_updates OFF
148 show binlog events;
149 Log_name Pos Event_type Server_id End_log_pos Info
150
151
152
153 connection srv_master2;
154 show variables like 'server_id';
155 Variable_name Value
156 server_id 3
157 show variables like 'log_bin';
158 Variable_name Value
159 log_bin ON
160 show variables like 'log_replica_updates';
161 Variable_name Value
162 log_replica_updates OFF
163 include/show_binlog_events.inc
164 Log_name Pos Event_type Server_id End_log_pos Info
165 master-bin.000001 # Query 3 # use `test`; CREATE TABLE bug45756_master_logged_1 (a int) engine = NDB
166 master-bin.000001 # Query 3 # BEGIN
167 master-bin.000001 # Table_map 3 # table_id: # (test.bug45756_master_logged_1)
168 master-bin.000001 # Table_map 3 # table_id: # (mysql.ndb_apply_status)
169 master-bin.000001 # Write_rows 3 # table_id: #
170 master-bin.000001 # Write_rows 3 # table_id: # flags: STMT_END_F
171 master-bin.000001 # Query 3 # COMMIT
172 master-bin.000001 # Query 3 # use `test`; drop table `test`.`bug45756_master_logged_1`
173 master-bin.000001 # Query 3 # use `test`; CREATE TABLE bug45756_master_logged_2 (a int) engine = NDB
174 master-bin.000001 # Query 3 # BEGIN
175 master-bin.000001 # Table_map 3 # table_id: # (test.bug45756_master_logged_2)
176 master-bin.000001 # Table_map 3 # table_id: # (mysql.ndb_apply_status)
177 master-bin.000001 # Write_rows 3 # table_id: #
178 master-bin.000001 # Write_rows 3 # table_id: # flags: STMT_END_F
179 master-bin.000001 # Query 3 # COMMIT
180 master-bin.000001 # Query 3 # use `test`; drop table `test`.`bug45756_master_logged_2`
181 master-bin.000001 # Query 3 # use `test`; CREATE TABLE bug45756_master_logged_3 (a int) engine = NDB
182 master-bin.000001 # Query 3 # BEGIN
183 master-bin.000001 # Table_map 3 # table_id: # (test.bug45756_master_logged_3)
184 master-bin.000001 # Table_map 3 # table_id: # (mysql.ndb_apply_status)
185 master-bin.000001 # Write_rows 3 # table_id: #
186 master-bin.000001 # Write_rows 3 # table_id: # flags: STMT_END_F
187 master-bin.000001 # Query 3 # COMMIT
188 master-bin.000001 # Query 3 # use `test`; DROP TABLE `bug45756_master_logged_3` /* generated by server */
189 select 'server id' and 'event type' from mysqlbinlog output
190 binlog_entries
191 server id 3 Query
192 server id 3 Query
193 server id 3 Table_map: `test`.`bug45756_master_logged_1`
194 server id 3 Table_map: `mysql`.`ndb_apply_status`
195 server id 3 Write_rows:
196 server id 3 Write_rows: flags: STMT_END_F
197 server id 3 Query
198 server id 3 Query
199 server id 3 Query
200 server id 3 Query
201 server id 3 Table_map: `test`.`bug45756_master_logged_2`
202 server id 3 Table_map: `mysql`.`ndb_apply_status`
203 server id 3 Write_rows:
204 server id 3 Write_rows: flags: STMT_END_F
205 server id 3 Query
206 server id 3 Query
207 server id 3 Query
208 server id 3 Query
209 server id 3 Table_map: `test`.`bug45756_master_logged_3`
210 server id 3 Table_map: `mysql`.`ndb_apply_status`
211 server id 3 Write_rows:
212 server id 3 Write_rows: flags: STMT_END_F
213 server id 3 Query
214 server id 3 Query
215
216
217
218 connection srv_slave;
219 show variables like 'server_id';
220 Variable_name Value
221 server_id 4
222 show variables like 'log_bin';
223 Variable_name Value
224 log_bin OFF
225 show variables like 'log_replica_updates';
226 Variable_name Value
227 log_replica_updates OFF
228 show binlog events;
229 Log_name Pos Event_type Server_id End_log_pos Info
230
231
232
233 connection srv_slave1;
234 show variables like 'server_id';
235 Variable_name Value
236 server_id 5
237 show variables like 'log_bin';
238 Variable_name Value
239 log_bin ON
240 show variables like 'log_replica_updates';
241 Variable_name Value
242 log_replica_updates OFF
243 include/show_binlog_events.inc
244 Log_name Pos Event_type Server_id End_log_pos Info
245 slave-master-bin.000001 # Query 5 # use `test`; CREATE TABLE bug_45756_slave_logged_1 (a int) engine = NDB
246 slave-master-bin.000001 # Query 5 # BEGIN
247 slave-master-bin.000001 # Table_map 5 # table_id: # (test.bug_45756_slave_logged_1)
248 slave-master-bin.000001 # Table_map 5 # table_id: # (mysql.ndb_apply_status)
249 slave-master-bin.000001 # Write_rows 5 # table_id: #
250 slave-master-bin.000001 # Write_rows 5 # table_id: # flags: STMT_END_F
251 slave-master-bin.000001 # Query 5 # COMMIT
252 slave-master-bin.000001 # Query 5 # use `test`; drop table `test`.`bug_45756_slave_logged_1`
253 slave-master-bin.000001 # Query 5 # use `test`; CREATE TABLE bug_45756_slave_logged_2 (a int) engine = NDB
254 slave-master-bin.000001 # Query 5 # BEGIN
255 slave-master-bin.000001 # Table_map 5 # table_id: # (test.bug_45756_slave_logged_2)
256 slave-master-bin.000001 # Table_map 5 # table_id: # (mysql.ndb_apply_status)
257 slave-master-bin.000001 # Write_rows 5 # table_id: #
258 slave-master-bin.000001 # Write_rows 5 # table_id: # flags: STMT_END_F
259 slave-master-bin.000001 # Query 5 # COMMIT
260 slave-master-bin.000001 # Query 5 # use `test`; DROP TABLE `bug_45756_slave_logged_2` /* generated by server */
261 slave-master-bin.000001 # Query 5 # use `test`; CREATE TABLE bug_45756_slave_logged_3 (a int) engine = NDB
262 slave-master-bin.000001 # Query 5 # BEGIN
263 slave-master-bin.000001 # Table_map 5 # table_id: # (test.bug_45756_slave_logged_3)
264 slave-master-bin.000001 # Table_map 5 # table_id: # (mysql.ndb_apply_status)
265 slave-master-bin.000001 # Write_rows 5 # table_id: #
266 slave-master-bin.000001 # Write_rows 5 # table_id: # flags: STMT_END_F
267 slave-master-bin.000001 # Query 5 # COMMIT
268 slave-master-bin.000001 # Query 5 # use `test`; drop table `test`.`bug_45756_slave_logged_3`
269 select 'server id' and 'event type' from mysqlbinlog output
270 binlog_entries
271 server id 5 Query
272 server id 5 Query
273 server id 5 Table_map: `test`.`bug_45756_slave_logged_1`
274 server id 5 Table_map: `mysql`.`ndb_apply_status`
275 server id 5 Write_rows:
276 server id 5 Write_rows: flags: STMT_END_F
277 server id 5 Query
278 server id 5 Query
279 server id 5 Query
280 server id 5 Query
281 server id 5 Table_map: `test`.`bug_45756_slave_logged_2`
282 server id 5 Table_map: `mysql`.`ndb_apply_status`
283 server id 5 Write_rows:
284 server id 5 Write_rows: flags: STMT_END_F
285 server id 5 Query
286 server id 5 Query
287 server id 5 Query
288 server id 5 Query
289 server id 5 Table_map: `test`.`bug_45756_slave_logged_3`
290 server id 5 Table_map: `mysql`.`ndb_apply_status`
291 server id 5 Write_rows:
292 server id 5 Write_rows: flags: STMT_END_F
293 server id 5 Query
294 server id 5 Query
295
296
297
298 connection srv_slave2;
299 show variables like 'server_id';
300 Variable_name Value
301 server_id 6
302 show variables like 'log_bin';
303 Variable_name Value
304 log_bin ON
305 show variables like 'log_replica_updates';
306 Variable_name Value
307 log_replica_updates ON
308 include/show_binlog_events.inc
309 Log_name Pos Event_type Server_id End_log_pos Info
310 slave-master-bin.000001 # Query 6 # use `test`; CREATE TABLE bug_45756_slave_logged_1 (a int) engine = NDB
311 slave-master-bin.000001 # Query 6 # BEGIN
312 slave-master-bin.000001 # Table_map 6 # table_id: # (test.bug_45756_slave_logged_1)
313 slave-master-bin.000001 # Table_map 6 # table_id: # (mysql.ndb_apply_status)
314 slave-master-bin.000001 # Write_rows 6 # table_id: #
315 slave-master-bin.000001 # Write_rows 6 # table_id: # flags: STMT_END_F
316 slave-master-bin.000001 # Query 6 # COMMIT
317 slave-master-bin.000001 # Query 6 # use `test`; drop table `test`.`bug_45756_slave_logged_1`
318 slave-master-bin.000001 # Query 6 # use `test`; CREATE TABLE bug_45756_slave_logged_2 (a int) engine = NDB
319 slave-master-bin.000001 # Query 6 # BEGIN
320 slave-master-bin.000001 # Table_map 6 # table_id: # (test.bug_45756_slave_logged_2)
321 slave-master-bin.000001 # Table_map 6 # table_id: # (mysql.ndb_apply_status)
322 slave-master-bin.000001 # Write_rows 6 # table_id: #
323 slave-master-bin.000001 # Write_rows 6 # table_id: # flags: STMT_END_F
324 slave-master-bin.000001 # Query 6 # COMMIT
325 slave-master-bin.000001 # Query 6 # use `test`; drop table `test`.`bug_45756_slave_logged_2`
326 slave-master-bin.000001 # Query 6 # use `test`; CREATE TABLE bug_45756_slave_logged_3 (a int) engine = NDB
327 slave-master-bin.000001 # Query 6 # BEGIN
328 slave-master-bin.000001 # Table_map 6 # table_id: # (test.bug_45756_slave_logged_3)
329 slave-master-bin.000001 # Table_map 6 # table_id: # (mysql.ndb_apply_status)
330 slave-master-bin.000001 # Write_rows 6 # table_id: #
331 slave-master-bin.000001 # Write_rows 6 # table_id: # flags: STMT_END_F
332 slave-master-bin.000001 # Query 6 # COMMIT
333 slave-master-bin.000001 # Query 6 # use `test`; DROP TABLE `bug_45756_slave_logged_3` /* generated by server */
334 slave-master-bin.000001 # Query 1 # use `test`; CREATE TABLE bug45756_master_logged_1 (a int) engine = NDB
335 slave-master-bin.000001 # Query 6 # BEGIN
336 slave-master-bin.000001 # Table_map 6 # table_id: # (test.bug45756_master_logged_1)
337 slave-master-bin.000001 # Table_map 6 # table_id: # (mysql.ndb_apply_status)
338 slave-master-bin.000001 # Write_rows 6 # table_id: #
339 slave-master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
340 slave-master-bin.000001 # Query 6 # COMMIT
341 slave-master-bin.000001 # Query 1 # use `test`; drop table `test`.`bug45756_master_logged_1`
342 slave-master-bin.000001 # Query 1 # use `test`; CREATE TABLE bug45756_master_logged_2 (a int) engine = NDB
343 slave-master-bin.000001 # Query 6 # BEGIN
344 slave-master-bin.000001 # Table_map 6 # table_id: # (test.bug45756_master_logged_2)
345 slave-master-bin.000001 # Table_map 6 # table_id: # (mysql.ndb_apply_status)
346 slave-master-bin.000001 # Write_rows 6 # table_id: #
347 slave-master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
348 slave-master-bin.000001 # Query 6 # COMMIT
349 slave-master-bin.000001 # Query 1 # use `test`; drop table `test`.`bug45756_master_logged_2`
350 slave-master-bin.000001 # Query 1 # use `test`; CREATE TABLE bug45756_master_logged_3 (a int) engine = NDB
351 slave-master-bin.000001 # Query 6 # BEGIN
352 slave-master-bin.000001 # Table_map 6 # table_id: # (test.bug45756_master_logged_3)
353 slave-master-bin.000001 # Table_map 6 # table_id: # (mysql.ndb_apply_status)
354 slave-master-bin.000001 # Write_rows 6 # table_id: #
355 slave-master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
356 slave-master-bin.000001 # Query 6 # COMMIT
357 slave-master-bin.000001 # Query 1 # use `test`; drop table `test`.`bug45756_master_logged_3`
358 select 'server id' and 'event type' from mysqlbinlog output
359 binlog_entries
360 server id 6 Query
361 server id 6 Query
362 server id 6 Table_map: `test`.`bug_45756_slave_logged_1`
363 server id 6 Table_map: `mysql`.`ndb_apply_status`
364 server id 6 Write_rows:
365 server id 6 Write_rows: flags: STMT_END_F
366 server id 6 Query
367 server id 6 Query
368 server id 6 Query
369 server id 6 Query
370 server id 6 Table_map: `test`.`bug_45756_slave_logged_2`
371 server id 6 Table_map: `mysql`.`ndb_apply_status`
372 server id 6 Write_rows:
373 server id 6 Write_rows: flags: STMT_END_F
374 server id 6 Query
375 server id 6 Query
376 server id 6 Query
377 server id 6 Query
378 server id 6 Table_map: `test`.`bug_45756_slave_logged_3`
379 server id 6 Table_map: `mysql`.`ndb_apply_status`
380 server id 6 Write_rows:
381 server id 6 Write_rows: flags: STMT_END_F
382 server id 6 Query
383 server id 6 Query
384 server id 1 Query
385 server id 6 Query
386 server id 6 Table_map: `test`.`bug45756_master_logged_1`
387 server id 6 Table_map: `mysql`.`ndb_apply_status`
388 server id 6 Write_rows:
389 server id 1 Write_rows: flags: STMT_END_F
390 server id 6 Query
391 server id 1 Query
392 server id 1 Query
393 server id 6 Query
394 server id 6 Table_map: `test`.`bug45756_master_logged_2`
395 server id 6 Table_map: `mysql`.`ndb_apply_status`
396 server id 6 Write_rows:
397 server id 1 Write_rows: flags: STMT_END_F
398 server id 6 Query
399 server id 1 Query
400 server id 1 Query
401 server id 6 Query
402 server id 6 Table_map: `test`.`bug45756_master_logged_3`
403 server id 6 Table_map: `mysql`.`ndb_apply_status`
404 server id 6 Write_rows:
405 server id 1 Write_rows: flags: STMT_END_F
406 server id 6 Query
407 server id 1 Query
408 include/stop_slave.inc
409 *** Configuring replication via Slave1 ***
410 [connection srv_slave1]
411 include/rpl_change_topology.inc [new topology=1->4,1->5]
412 Warnings:
413 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
414 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
415 include/start_slave.inc
416 *** Generating slave cluster originated binloggable changes ***
417 CREATE TABLE bug_45756_slave_logged_1 (a int) engine = NDB;
418 INSERT INTO bug_45756_slave_logged_1 VALUES (1);
419 DROP TABLE bug_45756_slave_logged_1;
420 CREATE TABLE bug_45756_slave_logged_2 (a int) engine = NDB;
421 INSERT INTO bug_45756_slave_logged_2 VALUES (1);
422 DROP TABLE bug_45756_slave_logged_2;
423 CREATE TABLE bug_45756_slave_logged_3 (a int) engine = NDB;
424 INSERT INTO bug_45756_slave_logged_3 VALUES (1);
425 DROP TABLE bug_45756_slave_logged_3;
426 ***Generating slave cluster non-binloggable changes***
427 SET SQL_LOG_BIN= 0;
428 CREATE TABLE bug_45756_slave_not_logged_1 (a int) engine = NDB;
429 INSERT INTO bug_45756_slave_not_logged_1 VALUES (1);
430 DROP TABLE bug_45756_slave_not_logged_1;
431 SET SQL_LOG_BIN= 1;
432 SET SQL_LOG_BIN= 0;
433 CREATE TABLE bug_45756_slave_not_logged_2 (a int) engine = NDB;
434 INSERT INTO bug_45756_slave_not_logged_2 VALUES (1);
435 DROP TABLE bug_45756_slave_not_logged_2;
436 SET SQL_LOG_BIN= 1;
437 SET SQL_LOG_BIN= 0;
438 CREATE TABLE bug_45756_slave_not_logged_3 (a int) engine = NDB;
439 INSERT INTO bug_45756_slave_not_logged_3 VALUES (1);
440 DROP TABLE bug_45756_slave_not_logged_3;
441 SET SQL_LOG_BIN= 1;
442 *** Generating data to be replicated ***
443 CREATE TABLE bug45756_master_logged_1 (a int) engine = NDB;
444 INSERT INTO bug45756_master_logged_1 VALUES (1);
445 DROP TABLE bug45756_master_logged_1;
446 CREATE TABLE bug45756_master_logged_2 (a int) engine = NDB;
447 INSERT INTO bug45756_master_logged_2 VALUES (1);
448 DROP TABLE bug45756_master_logged_2;
449 CREATE TABLE bug45756_master_logged_3 (a int) engine = NDB;
450 INSERT INTO bug45756_master_logged_3 VALUES (1);
451 DROP TABLE bug45756_master_logged_3;
452 *** Generating changes not to be replicated ***
453 SET SQL_LOG_BIN= 0;
454 CREATE TABLE bug45756_master_not_logged_1 (a int) engine = NDB;
455 INSERT INTO bug45756_master_not_logged_1 VALUES (1);
456 DROP TABLE bug45756_master_not_logged_1;
457 SET SQL_LOG_BIN= 1;
458 SET SQL_LOG_BIN= 0;
459 CREATE TABLE bug45756_master_not_logged_2 (a int) engine = NDB;
460 INSERT INTO bug45756_master_not_logged_2 VALUES (1);
461 DROP TABLE bug45756_master_not_logged_2;
462 SET SQL_LOG_BIN= 1;
463 SET SQL_LOG_BIN= 0;
464 CREATE TABLE bug45756_master_not_logged_3 (a int) engine = NDB;
465 INSERT INTO bug45756_master_not_logged_3 VALUES (1);
466 DROP TABLE bug45756_master_not_logged_3;
467 SET SQL_LOG_BIN= 1;
468 *** Checking binlog contents on every server in both clusters ***
469
470
471
472 connection srv_master;
473 show variables like 'server_id';
474 Variable_name Value
475 server_id 1
476 show variables like 'log_bin';
477 Variable_name Value
478 log_bin ON
479 show variables like 'log_replica_updates';
480 Variable_name Value
481 log_replica_updates OFF
482 include/show_binlog_events.inc
483 Log_name Pos Event_type Server_id End_log_pos Info
484 master-bin.000001 # Query 1 # use `test`; CREATE TABLE bug45756_master_logged_1 (a int) engine = NDB
485 master-bin.000001 # Query 1 # BEGIN
486 master-bin.000001 # Table_map 1 # table_id: # (test.bug45756_master_logged_1)
487 master-bin.000001 # Table_map 1 # table_id: # (mysql.ndb_apply_status)
488 master-bin.000001 # Write_rows 1 # table_id: #
489 master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
490 master-bin.000001 # Query 1 # COMMIT
491 master-bin.000001 # Query 1 # use `test`; DROP TABLE `bug45756_master_logged_1` /* generated by server */
492 master-bin.000001 # Query 1 # use `test`; CREATE TABLE bug45756_master_logged_2 (a int) engine = NDB
493 master-bin.000001 # Query 1 # BEGIN
494 master-bin.000001 # Table_map 1 # table_id: # (test.bug45756_master_logged_2)
495 master-bin.000001 # Table_map 1 # table_id: # (mysql.ndb_apply_status)
496 master-bin.000001 # Write_rows 1 # table_id: #
497 master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
498 master-bin.000001 # Query 1 # COMMIT
499 master-bin.000001 # Query 1 # use `test`; drop table `test`.`bug45756_master_logged_2`
500 master-bin.000001 # Query 1 # use `test`; CREATE TABLE bug45756_master_logged_3 (a int) engine = NDB
501 master-bin.000001 # Query 1 # BEGIN
502 master-bin.000001 # Table_map 1 # table_id: # (test.bug45756_master_logged_3)
503 master-bin.000001 # Table_map 1 # table_id: # (mysql.ndb_apply_status)
504 master-bin.000001 # Write_rows 1 # table_id: #
505 master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
506 master-bin.000001 # Query 1 # COMMIT
507 master-bin.000001 # Query 1 # use `test`; drop table `test`.`bug45756_master_logged_3`
508 select 'server id' and 'event type' from mysqlbinlog output
509 binlog_entries
510 server id 1 Query
511 server id 1 Query
512 server id 1 Table_map: `test`.`bug45756_master_logged_1`
513 server id 1 Table_map: `mysql`.`ndb_apply_status`
514 server id 1 Write_rows:
515 server id 1 Write_rows: flags: STMT_END_F
516 server id 1 Query
517 server id 1 Query
518 server id 1 Query
519 server id 1 Query
520 server id 1 Table_map: `test`.`bug45756_master_logged_2`
521 server id 1 Table_map: `mysql`.`ndb_apply_status`
522 server id 1 Write_rows:
523 server id 1 Write_rows: flags: STMT_END_F
524 server id 1 Query
525 server id 1 Query
526 server id 1 Query
527 server id 1 Query
528 server id 1 Table_map: `test`.`bug45756_master_logged_3`
529 server id 1 Table_map: `mysql`.`ndb_apply_status`
530 server id 1 Write_rows:
531 server id 1 Write_rows: flags: STMT_END_F
532 server id 1 Query
533 server id 1 Query
534
535
536
537 connection srv_master1;
538 show variables like 'server_id';
539 Variable_name Value
540 server_id 2
541 show variables like 'log_bin';
542 Variable_name Value
543 log_bin OFF
544 show variables like 'log_replica_updates';
545 Variable_name Value
546 log_replica_updates OFF
547 show binlog events;
548 Log_name Pos Event_type Server_id End_log_pos Info
549
550
551
552 connection srv_master2;
553 show variables like 'server_id';
554 Variable_name Value
555 server_id 3
556 show variables like 'log_bin';
557 Variable_name Value
558 log_bin ON
559 show variables like 'log_replica_updates';
560 Variable_name Value
561 log_replica_updates OFF
562 include/show_binlog_events.inc
563 Log_name Pos Event_type Server_id End_log_pos Info
564 master-bin.000001 # Query 3 # use `test`; CREATE TABLE bug45756_master_logged_1 (a int) engine = NDB
565 master-bin.000001 # Query 3 # BEGIN
566 master-bin.000001 # Table_map 3 # table_id: # (test.bug45756_master_logged_1)
567 master-bin.000001 # Table_map 3 # table_id: # (mysql.ndb_apply_status)
568 master-bin.000001 # Write_rows 3 # table_id: #
569 master-bin.000001 # Write_rows 3 # table_id: # flags: STMT_END_F
570 master-bin.000001 # Query 3 # COMMIT
571 master-bin.000001 # Query 3 # use `test`; drop table `test`.`bug45756_master_logged_1`
572 master-bin.000001 # Query 3 # use `test`; CREATE TABLE bug45756_master_logged_2 (a int) engine = NDB
573 master-bin.000001 # Query 3 # BEGIN
574 master-bin.000001 # Table_map 3 # table_id: # (test.bug45756_master_logged_2)
575 master-bin.000001 # Table_map 3 # table_id: # (mysql.ndb_apply_status)
576 master-bin.000001 # Write_rows 3 # table_id: #
577 master-bin.000001 # Write_rows 3 # table_id: # flags: STMT_END_F
578 master-bin.000001 # Query 3 # COMMIT
579 master-bin.000001 # Query 3 # use `test`; drop table `test`.`bug45756_master_logged_2`
580 master-bin.000001 # Query 3 # use `test`; CREATE TABLE bug45756_master_logged_3 (a int) engine = NDB
581 master-bin.000001 # Query 3 # BEGIN
582 master-bin.000001 # Table_map 3 # table_id: # (test.bug45756_master_logged_3)
583 master-bin.000001 # Table_map 3 # table_id: # (mysql.ndb_apply_status)
584 master-bin.000001 # Write_rows 3 # table_id: #
585 master-bin.000001 # Write_rows 3 # table_id: # flags: STMT_END_F
586 master-bin.000001 # Query 3 # COMMIT
587 master-bin.000001 # Query 3 # use `test`; DROP TABLE `bug45756_master_logged_3` /* generated by server */
588 select 'server id' and 'event type' from mysqlbinlog output
589 binlog_entries
590 server id 3 Query
591 server id 3 Query
592 server id 3 Table_map: `test`.`bug45756_master_logged_1`
593 server id 3 Table_map: `mysql`.`ndb_apply_status`
594 server id 3 Write_rows:
595 server id 3 Write_rows: flags: STMT_END_F
596 server id 3 Query
597 server id 3 Query
598 server id 3 Query
599 server id 3 Query
600 server id 3 Table_map: `test`.`bug45756_master_logged_2`
601 server id 3 Table_map: `mysql`.`ndb_apply_status`
602 server id 3 Write_rows:
603 server id 3 Write_rows: flags: STMT_END_F
604 server id 3 Query
605 server id 3 Query
606 server id 3 Query
607 server id 3 Query
608 server id 3 Table_map: `test`.`bug45756_master_logged_3`
609 server id 3 Table_map: `mysql`.`ndb_apply_status`
610 server id 3 Write_rows:
611 server id 3 Write_rows: flags: STMT_END_F
612 server id 3 Query
613 server id 3 Query
614
615
616
617 connection srv_slave;
618 show variables like 'server_id';
619 Variable_name Value
620 server_id 4
621 show variables like 'log_bin';
622 Variable_name Value
623 log_bin OFF
624 show variables like 'log_replica_updates';
625 Variable_name Value
626 log_replica_updates OFF
627 show binlog events;
628 Log_name Pos Event_type Server_id End_log_pos Info
629
630
631
632 connection srv_slave1;
633 show variables like 'server_id';
634 Variable_name Value
635 server_id 5
636 show variables like 'log_bin';
637 Variable_name Value
638 log_bin ON
639 show variables like 'log_replica_updates';
640 Variable_name Value
641 log_replica_updates OFF
642 include/show_binlog_events.inc
643 Log_name Pos Event_type Server_id End_log_pos Info
644 slave-master-bin.000001 # Query 5 # use `test`; CREATE TABLE bug_45756_slave_logged_1 (a int) engine = NDB
645 slave-master-bin.000001 # Query 5 # BEGIN
646 slave-master-bin.000001 # Table_map 5 # table_id: # (test.bug_45756_slave_logged_1)
647 slave-master-bin.000001 # Table_map 5 # table_id: # (mysql.ndb_apply_status)
648 slave-master-bin.000001 # Write_rows 5 # table_id: #
649 slave-master-bin.000001 # Write_rows 5 # table_id: # flags: STMT_END_F
650 slave-master-bin.000001 # Query 5 # COMMIT
651 slave-master-bin.000001 # Query 5 # use `test`; drop table `test`.`bug_45756_slave_logged_1`
652 slave-master-bin.000001 # Query 5 # use `test`; CREATE TABLE bug_45756_slave_logged_2 (a int) engine = NDB
653 slave-master-bin.000001 # Query 5 # BEGIN
654 slave-master-bin.000001 # Table_map 5 # table_id: # (test.bug_45756_slave_logged_2)
655 slave-master-bin.000001 # Table_map 5 # table_id: # (mysql.ndb_apply_status)
656 slave-master-bin.000001 # Write_rows 5 # table_id: #
657 slave-master-bin.000001 # Write_rows 5 # table_id: # flags: STMT_END_F
658 slave-master-bin.000001 # Query 5 # COMMIT
659 slave-master-bin.000001 # Query 5 # use `test`; DROP TABLE `bug_45756_slave_logged_2` /* generated by server */
660 slave-master-bin.000001 # Query 5 # use `test`; CREATE TABLE bug_45756_slave_logged_3 (a int) engine = NDB
661 slave-master-bin.000001 # Query 5 # BEGIN
662 slave-master-bin.000001 # Table_map 5 # table_id: # (test.bug_45756_slave_logged_3)
663 slave-master-bin.000001 # Table_map 5 # table_id: # (mysql.ndb_apply_status)
664 slave-master-bin.000001 # Write_rows 5 # table_id: #
665 slave-master-bin.000001 # Write_rows 5 # table_id: # flags: STMT_END_F
666 slave-master-bin.000001 # Query 5 # COMMIT
667 slave-master-bin.000001 # Query 5 # use `test`; drop table `test`.`bug_45756_slave_logged_3`
668 select 'server id' and 'event type' from mysqlbinlog output
669 binlog_entries
670 server id 5 Query
671 server id 5 Query
672 server id 5 Table_map: `test`.`bug_45756_slave_logged_1`
673 server id 5 Table_map: `mysql`.`ndb_apply_status`
674 server id 5 Write_rows:
675 server id 5 Write_rows: flags: STMT_END_F
676 server id 5 Query
677 server id 5 Query
678 server id 5 Query
679 server id 5 Query
680 server id 5 Table_map: `test`.`bug_45756_slave_logged_2`
681 server id 5 Table_map: `mysql`.`ndb_apply_status`
682 server id 5 Write_rows:
683 server id 5 Write_rows: flags: STMT_END_F
684 server id 5 Query
685 server id 5 Query
686 server id 5 Query
687 server id 5 Query
688 server id 5 Table_map: `test`.`bug_45756_slave_logged_3`
689 server id 5 Table_map: `mysql`.`ndb_apply_status`
690 server id 5 Write_rows:
691 server id 5 Write_rows: flags: STMT_END_F
692 server id 5 Query
693 server id 5 Query
694
695
696
697 connection srv_slave2;
698 show variables like 'server_id';
699 Variable_name Value
700 server_id 6
701 show variables like 'log_bin';
702 Variable_name Value
703 log_bin ON
704 show variables like 'log_replica_updates';
705 Variable_name Value
706 log_replica_updates ON
707 include/show_binlog_events.inc
708 Log_name Pos Event_type Server_id End_log_pos Info
709 slave-master-bin.000001 # Query 6 # use `test`; CREATE TABLE bug_45756_slave_logged_1 (a int) engine = NDB
710 slave-master-bin.000001 # Query 6 # BEGIN
711 slave-master-bin.000001 # Table_map 6 # table_id: # (test.bug_45756_slave_logged_1)
712 slave-master-bin.000001 # Table_map 6 # table_id: # (mysql.ndb_apply_status)
713 slave-master-bin.000001 # Write_rows 6 # table_id: #
714 slave-master-bin.000001 # Write_rows 6 # table_id: # flags: STMT_END_F
715 slave-master-bin.000001 # Query 6 # COMMIT
716 slave-master-bin.000001 # Query 6 # use `test`; drop table `test`.`bug_45756_slave_logged_1`
717 slave-master-bin.000001 # Query 6 # use `test`; CREATE TABLE bug_45756_slave_logged_2 (a int) engine = NDB
718 slave-master-bin.000001 # Query 6 # BEGIN
719 slave-master-bin.000001 # Table_map 6 # table_id: # (test.bug_45756_slave_logged_2)
720 slave-master-bin.000001 # Table_map 6 # table_id: # (mysql.ndb_apply_status)
721 slave-master-bin.000001 # Write_rows 6 # table_id: #
722 slave-master-bin.000001 # Write_rows 6 # table_id: # flags: STMT_END_F
723 slave-master-bin.000001 # Query 6 # COMMIT
724 slave-master-bin.000001 # Query 6 # use `test`; drop table `test`.`bug_45756_slave_logged_2`
725 slave-master-bin.000001 # Query 6 # use `test`; CREATE TABLE bug_45756_slave_logged_3 (a int) engine = NDB
726 slave-master-bin.000001 # Query 6 # BEGIN
727 slave-master-bin.000001 # Table_map 6 # table_id: # (test.bug_45756_slave_logged_3)
728 slave-master-bin.000001 # Table_map 6 # table_id: # (mysql.ndb_apply_status)
729 slave-master-bin.000001 # Write_rows 6 # table_id: #
730 slave-master-bin.000001 # Write_rows 6 # table_id: # flags: STMT_END_F
731 slave-master-bin.000001 # Query 6 # COMMIT
732 slave-master-bin.000001 # Query 6 # use `test`; DROP TABLE `bug_45756_slave_logged_3` /* generated by server */
733 slave-master-bin.000001 # Query 1 # use `test`; CREATE TABLE bug45756_master_logged_1 (a int) engine = NDB
734 slave-master-bin.000001 # Query 6 # BEGIN
735 slave-master-bin.000001 # Table_map 6 # table_id: # (test.bug45756_master_logged_1)
736 slave-master-bin.000001 # Table_map 6 # table_id: # (mysql.ndb_apply_status)
737 slave-master-bin.000001 # Write_rows 6 # table_id: #
738 slave-master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
739 slave-master-bin.000001 # Query 6 # COMMIT
740 slave-master-bin.000001 # Query 1 # use `test`; drop table `test`.`bug45756_master_logged_1`
741 slave-master-bin.000001 # Query 1 # use `test`; CREATE TABLE bug45756_master_logged_2 (a int) engine = NDB
742 slave-master-bin.000001 # Query 6 # BEGIN
743 slave-master-bin.000001 # Table_map 6 # table_id: # (test.bug45756_master_logged_2)
744 slave-master-bin.000001 # Table_map 6 # table_id: # (mysql.ndb_apply_status)
745 slave-master-bin.000001 # Write_rows 6 # table_id: #
746 slave-master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
747 slave-master-bin.000001 # Query 6 # COMMIT
748 slave-master-bin.000001 # Query 1 # use `test`; drop table `test`.`bug45756_master_logged_2`
749 slave-master-bin.000001 # Query 1 # use `test`; CREATE TABLE bug45756_master_logged_3 (a int) engine = NDB
750 slave-master-bin.000001 # Query 6 # BEGIN
751 slave-master-bin.000001 # Table_map 6 # table_id: # (test.bug45756_master_logged_3)
752 slave-master-bin.000001 # Table_map 6 # table_id: # (mysql.ndb_apply_status)
753 slave-master-bin.000001 # Write_rows 6 # table_id: #
754 slave-master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
755 slave-master-bin.000001 # Query 6 # COMMIT
756 slave-master-bin.000001 # Query 1 # use `test`; drop table `test`.`bug45756_master_logged_3`
757 select 'server id' and 'event type' from mysqlbinlog output
758 binlog_entries
759 server id 6 Query
760 server id 6 Query
761 server id 6 Table_map: `test`.`bug_45756_slave_logged_1`
762 server id 6 Table_map: `mysql`.`ndb_apply_status`
763 server id 6 Write_rows:
764 server id 6 Write_rows: flags: STMT_END_F
765 server id 6 Query
766 server id 6 Query
767 server id 6 Query
768 server id 6 Query
769 server id 6 Table_map: `test`.`bug_45756_slave_logged_2`
770 server id 6 Table_map: `mysql`.`ndb_apply_status`
771 server id 6 Write_rows:
772 server id 6 Write_rows: flags: STMT_END_F
773 server id 6 Query
774 server id 6 Query
775 server id 6 Query
776 server id 6 Query
777 server id 6 Table_map: `test`.`bug_45756_slave_logged_3`
778 server id 6 Table_map: `mysql`.`ndb_apply_status`
779 server id 6 Write_rows:
780 server id 6 Write_rows: flags: STMT_END_F
781 server id 6 Query
782 server id 6 Query
783 server id 1 Query
784 server id 6 Query
785 server id 6 Table_map: `test`.`bug45756_master_logged_1`
786 server id 6 Table_map: `mysql`.`ndb_apply_status`
787 server id 6 Write_rows:
788 server id 1 Write_rows: flags: STMT_END_F
789 server id 6 Query
790 server id 1 Query
791 server id 1 Query
792 server id 6 Query
793 server id 6 Table_map: `test`.`bug45756_master_logged_2`
794 server id 6 Table_map: `mysql`.`ndb_apply_status`
795 server id 6 Write_rows:
796 server id 1 Write_rows: flags: STMT_END_F
797 server id 6 Query
798 server id 1 Query
799 server id 1 Query
800 server id 6 Query
801 server id 6 Table_map: `test`.`bug45756_master_logged_3`
802 server id 6 Table_map: `mysql`.`ndb_apply_status`
803 server id 6 Write_rows:
804 server id 1 Write_rows: flags: STMT_END_F
805 server id 6 Query
806 server id 1 Query
807 include/stop_slave.inc
808 *** Configuring replication via Slave2 ***
809 [connection srv_slave2]
810 include/rpl_change_topology.inc [new topology=1->4,1->5,1->6]
811 Warnings:
812 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
813 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
814 include/start_slave.inc
815 *** Generating slave cluster originated binloggable changes ***
816 CREATE TABLE bug_45756_slave_logged_1 (a int) engine = NDB;
817 INSERT INTO bug_45756_slave_logged_1 VALUES (1);
818 DROP TABLE bug_45756_slave_logged_1;
819 CREATE TABLE bug_45756_slave_logged_2 (a int) engine = NDB;
820 INSERT INTO bug_45756_slave_logged_2 VALUES (1);
821 DROP TABLE bug_45756_slave_logged_2;
822 CREATE TABLE bug_45756_slave_logged_3 (a int) engine = NDB;
823 INSERT INTO bug_45756_slave_logged_3 VALUES (1);
824 DROP TABLE bug_45756_slave_logged_3;
825 ***Generating slave cluster non-binloggable changes***
826 SET SQL_LOG_BIN= 0;
827 CREATE TABLE bug_45756_slave_not_logged_1 (a int) engine = NDB;
828 INSERT INTO bug_45756_slave_not_logged_1 VALUES (1);
829 DROP TABLE bug_45756_slave_not_logged_1;
830 SET SQL_LOG_BIN= 1;
831 SET SQL_LOG_BIN= 0;
832 CREATE TABLE bug_45756_slave_not_logged_2 (a int) engine = NDB;
833 INSERT INTO bug_45756_slave_not_logged_2 VALUES (1);
834 DROP TABLE bug_45756_slave_not_logged_2;
835 SET SQL_LOG_BIN= 1;
836 SET SQL_LOG_BIN= 0;
837 CREATE TABLE bug_45756_slave_not_logged_3 (a int) engine = NDB;
838 INSERT INTO bug_45756_slave_not_logged_3 VALUES (1);
839 DROP TABLE bug_45756_slave_not_logged_3;
840 SET SQL_LOG_BIN= 1;
841 *** Generating data to be replicated ***
842 CREATE TABLE bug45756_master_logged_1 (a int) engine = NDB;
843 INSERT INTO bug45756_master_logged_1 VALUES (1);
844 DROP TABLE bug45756_master_logged_1;
845 CREATE TABLE bug45756_master_logged_2 (a int) engine = NDB;
846 INSERT INTO bug45756_master_logged_2 VALUES (1);
847 DROP TABLE bug45756_master_logged_2;
848 CREATE TABLE bug45756_master_logged_3 (a int) engine = NDB;
849 INSERT INTO bug45756_master_logged_3 VALUES (1);
850 DROP TABLE bug45756_master_logged_3;
851 *** Generating changes not to be replicated ***
852 SET SQL_LOG_BIN= 0;
853 CREATE TABLE bug45756_master_not_logged_1 (a int) engine = NDB;
854 INSERT INTO bug45756_master_not_logged_1 VALUES (1);
855 DROP TABLE bug45756_master_not_logged_1;
856 SET SQL_LOG_BIN= 1;
857 SET SQL_LOG_BIN= 0;
858 CREATE TABLE bug45756_master_not_logged_2 (a int) engine = NDB;
859 INSERT INTO bug45756_master_not_logged_2 VALUES (1);
860 DROP TABLE bug45756_master_not_logged_2;
861 SET SQL_LOG_BIN= 1;
862 SET SQL_LOG_BIN= 0;
863 CREATE TABLE bug45756_master_not_logged_3 (a int) engine = NDB;
864 INSERT INTO bug45756_master_not_logged_3 VALUES (1);
865 DROP TABLE bug45756_master_not_logged_3;
866 SET SQL_LOG_BIN= 1;
867 *** Checking binlog contents on every server in both clusters ***
868
869
870
871 connection srv_master;
872 show variables like 'server_id';
873 Variable_name Value
874 server_id 1
875 show variables like 'log_bin';
876 Variable_name Value
877 log_bin ON
878 show variables like 'log_replica_updates';
879 Variable_name Value
880 log_replica_updates OFF
881 include/show_binlog_events.inc
882 Log_name Pos Event_type Server_id End_log_pos Info
883 master-bin.000001 # Query 1 # use `test`; CREATE TABLE bug45756_master_logged_1 (a int) engine = NDB
884 master-bin.000001 # Query 1 # BEGIN
885 master-bin.000001 # Table_map 1 # table_id: # (test.bug45756_master_logged_1)
886 master-bin.000001 # Table_map 1 # table_id: # (mysql.ndb_apply_status)
887 master-bin.000001 # Write_rows 1 # table_id: #
888 master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
889 master-bin.000001 # Query 1 # COMMIT
890 master-bin.000001 # Query 1 # use `test`; DROP TABLE `bug45756_master_logged_1` /* generated by server */
891 master-bin.000001 # Query 1 # use `test`; CREATE TABLE bug45756_master_logged_2 (a int) engine = NDB
892 master-bin.000001 # Query 1 # BEGIN
893 master-bin.000001 # Table_map 1 # table_id: # (test.bug45756_master_logged_2)
894 master-bin.000001 # Table_map 1 # table_id: # (mysql.ndb_apply_status)
895 master-bin.000001 # Write_rows 1 # table_id: #
896 master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
897 master-bin.000001 # Query 1 # COMMIT
898 master-bin.000001 # Query 1 # use `test`; drop table `test`.`bug45756_master_logged_2`
899 master-bin.000001 # Query 1 # use `test`; CREATE TABLE bug45756_master_logged_3 (a int) engine = NDB
900 master-bin.000001 # Query 1 # BEGIN
901 master-bin.000001 # Table_map 1 # table_id: # (test.bug45756_master_logged_3)
902 master-bin.000001 # Table_map 1 # table_id: # (mysql.ndb_apply_status)
903 master-bin.000001 # Write_rows 1 # table_id: #
904 master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
905 master-bin.000001 # Query 1 # COMMIT
906 master-bin.000001 # Query 1 # use `test`; drop table `test`.`bug45756_master_logged_3`
907 select 'server id' and 'event type' from mysqlbinlog output
908 binlog_entries
909 server id 1 Query
910 server id 1 Query
911 server id 1 Table_map: `test`.`bug45756_master_logged_1`
912 server id 1 Table_map: `mysql`.`ndb_apply_status`
913 server id 1 Write_rows:
914 server id 1 Write_rows: flags: STMT_END_F
915 server id 1 Query
916 server id 1 Query
917 server id 1 Query
918 server id 1 Query
919 server id 1 Table_map: `test`.`bug45756_master_logged_2`
920 server id 1 Table_map: `mysql`.`ndb_apply_status`
921 server id 1 Write_rows:
922 server id 1 Write_rows: flags: STMT_END_F
923 server id 1 Query
924 server id 1 Query
925 server id 1 Query
926 server id 1 Query
927 server id 1 Table_map: `test`.`bug45756_master_logged_3`
928 server id 1 Table_map: `mysql`.`ndb_apply_status`
929 server id 1 Write_rows:
930 server id 1 Write_rows: flags: STMT_END_F
931 server id 1 Query
932 server id 1 Query
933
934
935
936 connection srv_master1;
937 show variables like 'server_id';
938 Variable_name Value
939 server_id 2
940 show variables like 'log_bin';
941 Variable_name Value
942 log_bin OFF
943 show variables like 'log_replica_updates';
944 Variable_name Value
945 log_replica_updates OFF
946 show binlog events;
947 Log_name Pos Event_type Server_id End_log_pos Info
948
949
950
951 connection srv_master2;
952 show variables like 'server_id';
953 Variable_name Value
954 server_id 3
955 show variables like 'log_bin';
956 Variable_name Value
957 log_bin ON
958 show variables like 'log_replica_updates';
959 Variable_name Value
960 log_replica_updates OFF
961 include/show_binlog_events.inc
962 Log_name Pos Event_type Server_id End_log_pos Info
963 master-bin.000001 # Query 3 # use `test`; CREATE TABLE bug45756_master_logged_1 (a int) engine = NDB
964 master-bin.000001 # Query 3 # BEGIN
965 master-bin.000001 # Table_map 3 # table_id: # (test.bug45756_master_logged_1)
966 master-bin.000001 # Table_map 3 # table_id: # (mysql.ndb_apply_status)
967 master-bin.000001 # Write_rows 3 # table_id: #
968 master-bin.000001 # Write_rows 3 # table_id: # flags: STMT_END_F
969 master-bin.000001 # Query 3 # COMMIT
970 master-bin.000001 # Query 3 # use `test`; drop table `test`.`bug45756_master_logged_1`
971 master-bin.000001 # Query 3 # use `test`; CREATE TABLE bug45756_master_logged_2 (a int) engine = NDB
972 master-bin.000001 # Query 3 # BEGIN
973 master-bin.000001 # Table_map 3 # table_id: # (test.bug45756_master_logged_2)
974 master-bin.000001 # Table_map 3 # table_id: # (mysql.ndb_apply_status)
975 master-bin.000001 # Write_rows 3 # table_id: #
976 master-bin.000001 # Write_rows 3 # table_id: # flags: STMT_END_F
977 master-bin.000001 # Query 3 # COMMIT
978 master-bin.000001 # Query 3 # use `test`; drop table `test`.`bug45756_master_logged_2`
979 master-bin.000001 # Query 3 # use `test`; CREATE TABLE bug45756_master_logged_3 (a int) engine = NDB
980 master-bin.000001 # Query 3 # BEGIN
981 master-bin.000001 # Table_map 3 # table_id: # (test.bug45756_master_logged_3)
982 master-bin.000001 # Table_map 3 # table_id: # (mysql.ndb_apply_status)
983 master-bin.000001 # Write_rows 3 # table_id: #
984 master-bin.000001 # Write_rows 3 # table_id: # flags: STMT_END_F
985 master-bin.000001 # Query 3 # COMMIT
986 master-bin.000001 # Query 3 # use `test`; DROP TABLE `bug45756_master_logged_3` /* generated by server */
987 select 'server id' and 'event type' from mysqlbinlog output
988 binlog_entries
989 server id 3 Query
990 server id 3 Query
991 server id 3 Table_map: `test`.`bug45756_master_logged_1`
992 server id 3 Table_map: `mysql`.`ndb_apply_status`
993 server id 3 Write_rows:
994 server id 3 Write_rows: flags: STMT_END_F
995 server id 3 Query
996 server id 3 Query
997 server id 3 Query
998 server id 3 Query
999 server id 3 Table_map: `test`.`bug45756_master_logged_2`
1000 server id 3 Table_map: `mysql`.`ndb_apply_status`
1001 server id 3 Write_rows:
1002 server id 3 Write_rows: flags: STMT_END_F
1003 server id 3 Query
1004 server id 3 Query
1005 server id 3 Query
1006 server id 3 Query
1007 server id 3 Table_map: `test`.`bug45756_master_logged_3`
1008 server id 3 Table_map: `mysql`.`ndb_apply_status`
1009 server id 3 Write_rows:
1010 server id 3 Write_rows: flags: STMT_END_F
1011 server id 3 Query
1012 server id 3 Query
1013
1014
1015
1016 connection srv_slave;
1017 show variables like 'server_id';
1018 Variable_name Value
1019 server_id 4
1020 show variables like 'log_bin';
1021 Variable_name Value
1022 log_bin OFF
1023 show variables like 'log_replica_updates';
1024 Variable_name Value
1025 log_replica_updates OFF
1026 show binlog events;
1027 Log_name Pos Event_type Server_id End_log_pos Info
1028
1029
1030
1031 connection srv_slave1;
1032 show variables like 'server_id';
1033 Variable_name Value
1034 server_id 5
1035 show variables like 'log_bin';
1036 Variable_name Value
1037 log_bin ON
1038 show variables like 'log_replica_updates';
1039 Variable_name Value
1040 log_replica_updates OFF
1041 include/show_binlog_events.inc
1042 Log_name Pos Event_type Server_id End_log_pos Info
1043 slave-master-bin.000001 # Query 5 # use `test`; CREATE TABLE bug_45756_slave_logged_1 (a int) engine = NDB
1044 slave-master-bin.000001 # Query 5 # BEGIN
1045 slave-master-bin.000001 # Table_map 5 # table_id: # (test.bug_45756_slave_logged_1)
1046 slave-master-bin.000001 # Table_map 5 # table_id: # (mysql.ndb_apply_status)
1047 slave-master-bin.000001 # Write_rows 5 # table_id: #
1048 slave-master-bin.000001 # Write_rows 5 # table_id: # flags: STMT_END_F
1049 slave-master-bin.000001 # Query 5 # COMMIT
1050 slave-master-bin.000001 # Query 5 # use `test`; drop table `test`.`bug_45756_slave_logged_1`
1051 slave-master-bin.000001 # Query 5 # use `test`; CREATE TABLE bug_45756_slave_logged_2 (a int) engine = NDB
1052 slave-master-bin.000001 # Query 5 # BEGIN
1053 slave-master-bin.000001 # Table_map 5 # table_id: # (test.bug_45756_slave_logged_2)
1054 slave-master-bin.000001 # Table_map 5 # table_id: # (mysql.ndb_apply_status)
1055 slave-master-bin.000001 # Write_rows 5 # table_id: #
1056 slave-master-bin.000001 # Write_rows 5 # table_id: # flags: STMT_END_F
1057 slave-master-bin.000001 # Query 5 # COMMIT
1058 slave-master-bin.000001 # Query 5 # use `test`; DROP TABLE `bug_45756_slave_logged_2` /* generated by server */
1059 slave-master-bin.000001 # Query 5 # use `test`; CREATE TABLE bug_45756_slave_logged_3 (a int) engine = NDB
1060 slave-master-bin.000001 # Query 5 # BEGIN
1061 slave-master-bin.000001 # Table_map 5 # table_id: # (test.bug_45756_slave_logged_3)
1062 slave-master-bin.000001 # Table_map 5 # table_id: # (mysql.ndb_apply_status)
1063 slave-master-bin.000001 # Write_rows 5 # table_id: #
1064 slave-master-bin.000001 # Write_rows 5 # table_id: # flags: STMT_END_F
1065 slave-master-bin.000001 # Query 5 # COMMIT
1066 slave-master-bin.000001 # Query 5 # use `test`; drop table `test`.`bug_45756_slave_logged_3`
1067 select 'server id' and 'event type' from mysqlbinlog output
1068 binlog_entries
1069 server id 5 Query
1070 server id 5 Query
1071 server id 5 Table_map: `test`.`bug_45756_slave_logged_1`
1072 server id 5 Table_map: `mysql`.`ndb_apply_status`
1073 server id 5 Write_rows:
1074 server id 5 Write_rows: flags: STMT_END_F
1075 server id 5 Query
1076 server id 5 Query
1077 server id 5 Query
1078 server id 5 Query
1079 server id 5 Table_map: `test`.`bug_45756_slave_logged_2`
1080 server id 5 Table_map: `mysql`.`ndb_apply_status`
1081 server id 5 Write_rows:
1082 server id 5 Write_rows: flags: STMT_END_F
1083 server id 5 Query
1084 server id 5 Query
1085 server id 5 Query
1086 server id 5 Query
1087 server id 5 Table_map: `test`.`bug_45756_slave_logged_3`
1088 server id 5 Table_map: `mysql`.`ndb_apply_status`
1089 server id 5 Write_rows:
1090 server id 5 Write_rows: flags: STMT_END_F
1091 server id 5 Query
1092 server id 5 Query
1093
1094
1095
1096 connection srv_slave2;
1097 show variables like 'server_id';
1098 Variable_name Value
1099 server_id 6
1100 show variables like 'log_bin';
1101 Variable_name Value
1102 log_bin ON
1103 show variables like 'log_replica_updates';
1104 Variable_name Value
1105 log_replica_updates ON
1106 include/show_binlog_events.inc
1107 Log_name Pos Event_type Server_id End_log_pos Info
1108 slave-master-bin.000001 # Query 6 # use `test`; CREATE TABLE bug_45756_slave_logged_1 (a int) engine = NDB
1109 slave-master-bin.000001 # Query 6 # BEGIN
1110 slave-master-bin.000001 # Table_map 6 # table_id: # (test.bug_45756_slave_logged_1)
1111 slave-master-bin.000001 # Table_map 6 # table_id: # (mysql.ndb_apply_status)
1112 slave-master-bin.000001 # Write_rows 6 # table_id: #
1113 slave-master-bin.000001 # Write_rows 6 # table_id: # flags: STMT_END_F
1114 slave-master-bin.000001 # Query 6 # COMMIT
1115 slave-master-bin.000001 # Query 6 # use `test`; drop table `test`.`bug_45756_slave_logged_1`
1116 slave-master-bin.000001 # Query 6 # use `test`; CREATE TABLE bug_45756_slave_logged_2 (a int) engine = NDB
1117 slave-master-bin.000001 # Query 6 # BEGIN
1118 slave-master-bin.000001 # Table_map 6 # table_id: # (test.bug_45756_slave_logged_2)
1119 slave-master-bin.000001 # Table_map 6 # table_id: # (mysql.ndb_apply_status)
1120 slave-master-bin.000001 # Write_rows 6 # table_id: #
1121 slave-master-bin.000001 # Write_rows 6 # table_id: # flags: STMT_END_F
1122 slave-master-bin.000001 # Query 6 # COMMIT
1123 slave-master-bin.000001 # Query 6 # use `test`; drop table `test`.`bug_45756_slave_logged_2`
1124 slave-master-bin.000001 # Query 6 # use `test`; CREATE TABLE bug_45756_slave_logged_3 (a int) engine = NDB
1125 slave-master-bin.000001 # Query 6 # BEGIN
1126 slave-master-bin.000001 # Table_map 6 # table_id: # (test.bug_45756_slave_logged_3)
1127 slave-master-bin.000001 # Table_map 6 # table_id: # (mysql.ndb_apply_status)
1128 slave-master-bin.000001 # Write_rows 6 # table_id: #
1129 slave-master-bin.000001 # Write_rows 6 # table_id: # flags: STMT_END_F
1130 slave-master-bin.000001 # Query 6 # COMMIT
1131 slave-master-bin.000001 # Query 6 # use `test`; DROP TABLE `bug_45756_slave_logged_3` /* generated by server */
1132 slave-master-bin.000001 # Query 1 # use `test`; CREATE TABLE bug45756_master_logged_1 (a int) engine = NDB
1133 slave-master-bin.000001 # Query 6 # BEGIN
1134 slave-master-bin.000001 # Table_map 6 # table_id: # (test.bug45756_master_logged_1)
1135 slave-master-bin.000001 # Table_map 6 # table_id: # (mysql.ndb_apply_status)
1136 slave-master-bin.000001 # Write_rows 6 # table_id: #
1137 slave-master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
1138 slave-master-bin.000001 # Query 6 # COMMIT
1139 slave-master-bin.000001 # Query 1 # use `test`; DROP TABLE `bug45756_master_logged_1` /* generated by server */
1140 slave-master-bin.000001 # Query 1 # use `test`; CREATE TABLE bug45756_master_logged_2 (a int) engine = NDB
1141 slave-master-bin.000001 # Query 6 # BEGIN
1142 slave-master-bin.000001 # Table_map 6 # table_id: # (test.bug45756_master_logged_2)
1143 slave-master-bin.000001 # Table_map 6 # table_id: # (mysql.ndb_apply_status)
1144 slave-master-bin.000001 # Write_rows 6 # table_id: #
1145 slave-master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
1146 slave-master-bin.000001 # Query 6 # COMMIT
1147 slave-master-bin.000001 # Query 1 # use `test`; DROP TABLE `bug45756_master_logged_2` /* generated by server */
1148 slave-master-bin.000001 # Query 1 # use `test`; CREATE TABLE bug45756_master_logged_3 (a int) engine = NDB
1149 slave-master-bin.000001 # Query 6 # BEGIN
1150 slave-master-bin.000001 # Table_map 6 # table_id: # (test.bug45756_master_logged_3)
1151 slave-master-bin.000001 # Table_map 6 # table_id: # (mysql.ndb_apply_status)
1152 slave-master-bin.000001 # Write_rows 6 # table_id: #
1153 slave-master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
1154 slave-master-bin.000001 # Query 6 # COMMIT
1155 slave-master-bin.000001 # Query 1 # use `test`; DROP TABLE `bug45756_master_logged_3` /* generated by server */
1156 select 'server id' and 'event type' from mysqlbinlog output
1157 binlog_entries
1158 server id 6 Query
1159 server id 6 Query
1160 server id 6 Table_map: `test`.`bug_45756_slave_logged_1`
1161 server id 6 Table_map: `mysql`.`ndb_apply_status`
1162 server id 6 Write_rows:
1163 server id 6 Write_rows: flags: STMT_END_F
1164 server id 6 Query
1165 server id 6 Query
1166 server id 6 Query
1167 server id 6 Query
1168 server id 6 Table_map: `test`.`bug_45756_slave_logged_2`
1169 server id 6 Table_map: `mysql`.`ndb_apply_status`
1170 server id 6 Write_rows:
1171 server id 6 Write_rows: flags: STMT_END_F
1172 server id 6 Query
1173 server id 6 Query
1174 server id 6 Query
1175 server id 6 Query
1176 server id 6 Table_map: `test`.`bug_45756_slave_logged_3`
1177 server id 6 Table_map: `mysql`.`ndb_apply_status`
1178 server id 6 Write_rows:
1179 server id 6 Write_rows: flags: STMT_END_F
1180 server id 6 Query
1181 server id 6 Query
1182 server id 1 Query
1183 server id 6 Query
1184 server id 6 Table_map: `test`.`bug45756_master_logged_1`
1185 server id 6 Table_map: `mysql`.`ndb_apply_status`
1186 server id 6 Write_rows:
1187 server id 1 Write_rows: flags: STMT_END_F
1188 server id 6 Query
1189 server id 1 Query
1190 server id 1 Query
1191 server id 6 Query
1192 server id 6 Table_map: `test`.`bug45756_master_logged_2`
1193 server id 6 Table_map: `mysql`.`ndb_apply_status`
1194 server id 6 Write_rows:
1195 server id 1 Write_rows: flags: STMT_END_F
1196 server id 6 Query
1197 server id 1 Query
1198 server id 1 Query
1199 server id 6 Query
1200 server id 6 Table_map: `test`.`bug45756_master_logged_3`
1201 server id 6 Table_map: `mysql`.`ndb_apply_status`
1202 server id 6 Write_rows:
1203 server id 1 Write_rows: flags: STMT_END_F
1204 server id 6 Query
1205 server id 1 Query
1206 include/stop_slave.inc
1207 include/rpl_change_topology.inc [new topology=none]
1208 include/rpl_end.inc