Linux ip-172-26-2-223 5.4.0-1018-aws #18-Ubuntu SMP Wed Jun 24 01:15:00 UTC 2020 x86_64
Apache
: 172.26.2.223 | : 18.221.207.166
Cant Read [ /etc/named.conf ]
8.1.13
www
www.github.com/MadExploits
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
CPANEL RESET
CREATE WP USER
BLACK DEFEND!
README
+ Create Folder
+ Create File
/
www /
server /
mysql /
mysql-test /
suite /
ndb_rpl /
r /
[ HOME SHELL ]
Name
Size
Permission
Action
ndb_dist_priv_common.result
2.33
KB
-rw-r--r--
ndb_rpl_2innodb.result
41.34
KB
-rw-r--r--
ndb_rpl_2myisam.result
41.34
KB
-rw-r--r--
ndb_rpl_2ndb.result
16.17
KB
-rw-r--r--
ndb_rpl_2other.result
32.71
KB
-rw-r--r--
ndb_rpl_add_column.result
5.99
KB
-rw-r--r--
ndb_rpl_apply_status.result
907
B
-rw-r--r--
ndb_rpl_auto_inc.result
3.72
KB
-rw-r--r--
ndb_rpl_bank.result
10.82
KB
-rw-r--r--
ndb_rpl_basic.result
13.52
KB
-rw-r--r--
ndb_rpl_batch.result
2.48
KB
-rw-r--r--
ndb_rpl_batch_handling.result
1.91
KB
-rw-r--r--
ndb_rpl_binlog_format_errors.r...
1.27
KB
-rw-r--r--
ndb_rpl_bitfield.result
14.48
KB
-rw-r--r--
ndb_rpl_blob.result
7.29
KB
-rw-r--r--
ndb_rpl_break_3_chain.result
3.17
KB
-rw-r--r--
ndb_rpl_bug22045.result
2.56
KB
-rw-r--r--
ndb_rpl_bug_13440282.result
2.3
KB
-rw-r--r--
ndb_rpl_check_for_mixed.result
483
B
-rw-r--r--
ndb_rpl_checksum.result
6.31
KB
-rw-r--r--
ndb_rpl_circular.result
5.13
KB
-rw-r--r--
ndb_rpl_circular_2ch.result
2.27
KB
-rw-r--r--
ndb_rpl_circular_2ch_rep_statu...
7.47
KB
-rw-r--r--
ndb_rpl_circular_simplex.resul...
1.28
KB
-rw-r--r--
ndb_rpl_conflict_basic.result
18.2
KB
-rw-r--r--
ndb_rpl_conflict_epoch.result
71.03
KB
-rw-r--r--
ndb_rpl_conflict_epoch2.result
143.62
KB
-rw-r--r--
ndb_rpl_conflict_epoch2_extra....
63.18
KB
-rw-r--r--
ndb_rpl_conflict_epoch2_trans....
47.12
KB
-rw-r--r--
ndb_rpl_conflict_epoch_ext.res...
106.6
KB
-rw-r--r--
ndb_rpl_conflict_epoch_extende...
13.51
KB
-rw-r--r--
ndb_rpl_conflict_epoch_trans.r...
23.13
KB
-rw-r--r--
ndb_rpl_conflict_epoch_trans_e...
23.62
KB
-rw-r--r--
ndb_rpl_conflict_max.result
36.46
KB
-rw-r--r--
ndb_rpl_conflict_max_delete_wi...
35.68
KB
-rw-r--r--
ndb_rpl_conflict_old.result
36.65
KB
-rw-r--r--
ndb_rpl_conflict_read_tracking...
29.94
KB
-rw-r--r--
ndb_rpl_ctype_ucs2_def.result
703
B
-rw-r--r--
ndb_rpl_dd_advance.result
8.9
KB
-rw-r--r--
ndb_rpl_dd_basic.result
2.4
KB
-rw-r--r--
ndb_rpl_dd_partitions.result
35.75
KB
-rw-r--r--
ndb_rpl_ddl_open_trans.result
1.87
KB
-rw-r--r--
ndb_rpl_dist_priv.result
11.31
KB
-rw-r--r--
ndb_rpl_do_db.result
1.44
KB
-rw-r--r--
ndb_rpl_do_table.result
1.13
KB
-rw-r--r--
ndb_rpl_empty_epoch.result
1.17
KB
-rw-r--r--
ndb_rpl_gap_event.result
1.38
KB
-rw-r--r--
ndb_rpl_idempotent.result
3.06
KB
-rw-r--r--
ndb_rpl_ignore_db.result
1.08
KB
-rw-r--r--
ndb_rpl_init_rep_status.result
2.17
KB
-rw-r--r--
ndb_rpl_innodb2ndb.result
41
KB
-rw-r--r--
ndb_rpl_innodb_trans.result
3.08
KB
-rw-r--r--
ndb_rpl_last_conflict_epoch_va...
2.06
KB
-rw-r--r--
ndb_rpl_load.result
1.27
KB
-rw-r--r--
ndb_rpl_logging.result
2.66
KB
-rw-r--r--
ndb_rpl_mix_eng_trans.result
10.51
KB
-rw-r--r--
ndb_rpl_mix_innodb.result
4.35
KB
-rw-r--r--
ndb_rpl_mixed_tables.result
7.28
KB
-rw-r--r--
ndb_rpl_multi.result
2.33
KB
-rw-r--r--
ndb_rpl_myisam2ndb.result
41
KB
-rw-r--r--
ndb_rpl_ndbapi-examples.result
522
B
-rw-r--r--
ndb_rpl_rep_error.result
16.79
KB
-rw-r--r--
ndb_rpl_rep_ignore.result
1.4
KB
-rw-r--r--
ndb_rpl_skip_gap_event.result
1.27
KB
-rw-r--r--
ndb_rpl_slave_binlog_index.res...
1.83
KB
-rw-r--r--
ndb_rpl_slave_conflict_role_va...
9.63
KB
-rw-r--r--
ndb_rpl_slave_lsu.result
53.8
KB
-rw-r--r--
ndb_rpl_slave_lsu_anyval.resul...
54.73
KB
-rw-r--r--
ndb_rpl_slave_replay.result
6.42
KB
-rw-r--r--
ndb_rpl_slave_restart.result
1.93
KB
-rw-r--r--
ndb_rpl_stm_innodb.result
4.38
KB
-rw-r--r--
ndb_rpl_sync.result
2.38
KB
-rw-r--r--
ndb_rpl_ui.result
1.86
KB
-rw-r--r--
ndb_rpl_ui2.result
813
B
-rw-r--r--
ndb_rpl_ui3.result
1.22
KB
-rw-r--r--
rpl_truncate_7ndb.result
3.27
KB
-rw-r--r--
rpl_truncate_7ndb_2.result
3.27
KB
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : ndb_rpl_slave_lsu.result
include/rpl_init.inc [topology=none] *** Configuring connections *** include/rpl_connect.inc [creating srv_master] include/rpl_connect.inc [creating srv_master1] include/rpl_connect.inc [creating srv_master2] include/rpl_connect.inc [creating srv_slave] include/rpl_connect.inc [creating srv_slave1] include/rpl_connect.inc [creating srv_slave2] *** Waiting for each cluster to startup *** *** Configuring replication via Slave *** [connection srv_slave] include/rpl_change_topology.inc [new topology=1->4] include/start_slave.inc *** Generating slave cluster originated binloggable changes *** CREATE TABLE bug_45756_slave_logged_1 (a int) engine = NDB; INSERT INTO bug_45756_slave_logged_1 VALUES (1); DROP TABLE bug_45756_slave_logged_1; CREATE TABLE bug_45756_slave_logged_2 (a int) engine = NDB; INSERT INTO bug_45756_slave_logged_2 VALUES (1); DROP TABLE bug_45756_slave_logged_2; CREATE TABLE bug_45756_slave_logged_3 (a int) engine = NDB; INSERT INTO bug_45756_slave_logged_3 VALUES (1); DROP TABLE bug_45756_slave_logged_3; ***Generating slave cluster non-binloggable changes*** SET SQL_LOG_BIN= 0; CREATE TABLE bug_45756_slave_not_logged_1 (a int) engine = NDB; INSERT INTO bug_45756_slave_not_logged_1 VALUES (1); DROP TABLE bug_45756_slave_not_logged_1; SET SQL_LOG_BIN= 1; SET SQL_LOG_BIN= 0; CREATE TABLE bug_45756_slave_not_logged_2 (a int) engine = NDB; INSERT INTO bug_45756_slave_not_logged_2 VALUES (1); DROP TABLE bug_45756_slave_not_logged_2; SET SQL_LOG_BIN= 1; SET SQL_LOG_BIN= 0; CREATE TABLE bug_45756_slave_not_logged_3 (a int) engine = NDB; INSERT INTO bug_45756_slave_not_logged_3 VALUES (1); DROP TABLE bug_45756_slave_not_logged_3; SET SQL_LOG_BIN= 1; *** Generating data to be replicated *** CREATE TABLE bug45756_master_logged_1 (a int) engine = NDB; INSERT INTO bug45756_master_logged_1 VALUES (1); DROP TABLE bug45756_master_logged_1; CREATE TABLE bug45756_master_logged_2 (a int) engine = NDB; INSERT INTO bug45756_master_logged_2 VALUES (1); DROP TABLE bug45756_master_logged_2; CREATE TABLE bug45756_master_logged_3 (a int) engine = NDB; INSERT INTO bug45756_master_logged_3 VALUES (1); DROP TABLE bug45756_master_logged_3; *** Generating changes not to be replicated *** SET SQL_LOG_BIN= 0; CREATE TABLE bug45756_master_not_logged_1 (a int) engine = NDB; INSERT INTO bug45756_master_not_logged_1 VALUES (1); DROP TABLE bug45756_master_not_logged_1; SET SQL_LOG_BIN= 1; SET SQL_LOG_BIN= 0; CREATE TABLE bug45756_master_not_logged_2 (a int) engine = NDB; INSERT INTO bug45756_master_not_logged_2 VALUES (1); DROP TABLE bug45756_master_not_logged_2; SET SQL_LOG_BIN= 1; SET SQL_LOG_BIN= 0; CREATE TABLE bug45756_master_not_logged_3 (a int) engine = NDB; INSERT INTO bug45756_master_not_logged_3 VALUES (1); DROP TABLE bug45756_master_not_logged_3; SET SQL_LOG_BIN= 1; *** Checking binlog contents on every server in both clusters *** connection srv_master; show variables like 'server_id'; Variable_name Value server_id 1 show variables like 'log_bin'; Variable_name Value log_bin ON show variables like 'log_slave_updates'; Variable_name Value log_slave_updates OFF include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query 1 # use `test`; CREATE TABLE bug45756_master_logged_1 (a int) engine = NDB master-bin.000001 # Query 1 # BEGIN master-bin.000001 # Table_map 1 # table_id: # (test.bug45756_master_logged_1) master-bin.000001 # Table_map 1 # table_id: # (mysql.ndb_apply_status) master-bin.000001 # Write_rows 1 # table_id: # master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F master-bin.000001 # Query 1 # COMMIT master-bin.000001 # Query 1 # use `test`; DROP TABLE `bug45756_master_logged_1` /* generated by server */ master-bin.000001 # Query 1 # use `test`; CREATE TABLE bug45756_master_logged_2 (a int) engine = NDB master-bin.000001 # Query 1 # BEGIN master-bin.000001 # Table_map 1 # table_id: # (test.bug45756_master_logged_2) master-bin.000001 # Table_map 1 # table_id: # (mysql.ndb_apply_status) master-bin.000001 # Write_rows 1 # table_id: # master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F master-bin.000001 # Query 1 # COMMIT master-bin.000001 # Query 1 # use `test`; drop table `test`.`bug45756_master_logged_2` master-bin.000001 # Query 1 # use `test`; CREATE TABLE bug45756_master_logged_3 (a int) engine = NDB master-bin.000001 # Query 1 # BEGIN master-bin.000001 # Table_map 1 # table_id: # (test.bug45756_master_logged_3) master-bin.000001 # Table_map 1 # table_id: # (mysql.ndb_apply_status) master-bin.000001 # Write_rows 1 # table_id: # master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F master-bin.000001 # Query 1 # COMMIT master-bin.000001 # Query 1 # use `test`; drop table `test`.`bug45756_master_logged_3` select replace(right(txt, length(txt)-17), '\r', '') as binlog_entries from raw_binlog_rows where txt like '%server id%' and not (txt like '%Start%' or txt like '%Rotate%'); binlog_entries server id 1 Query server id 1 Query server id 1 Table_map: `test`.`bug45756_master_logged_1` server id 1 Table_map: `mysql`.`ndb_apply_status` server id 1 Write_rows: server id 1 Write_rows: flags: STMT_END_F server id 1 Query server id 1 Query server id 1 Query server id 1 Query server id 1 Table_map: `test`.`bug45756_master_logged_2` server id 1 Table_map: `mysql`.`ndb_apply_status` server id 1 Write_rows: server id 1 Write_rows: flags: STMT_END_F server id 1 Query server id 1 Query server id 1 Query server id 1 Query server id 1 Table_map: `test`.`bug45756_master_logged_3` server id 1 Table_map: `mysql`.`ndb_apply_status` server id 1 Write_rows: server id 1 Write_rows: flags: STMT_END_F server id 1 Query server id 1 Query connection srv_master1; show variables like 'server_id'; Variable_name Value server_id 2 show variables like 'log_bin'; Variable_name Value log_bin OFF show variables like 'log_slave_updates'; Variable_name Value log_slave_updates OFF show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info connection srv_master2; show variables like 'server_id'; Variable_name Value server_id 3 show variables like 'log_bin'; Variable_name Value log_bin ON show variables like 'log_slave_updates'; Variable_name Value log_slave_updates OFF show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query 3 # use `test`; CREATE TABLE bug45756_master_logged_1 (a int) engine = NDB master-bin.000001 # Query 3 # BEGIN master-bin.000001 # Table_map 3 # table_id: # (test.bug45756_master_logged_1) master-bin.000001 # Table_map 3 # table_id: # (mysql.ndb_apply_status) master-bin.000001 # Write_rows 3 # table_id: # master-bin.000001 # Write_rows 3 # table_id: # flags: STMT_END_F master-bin.000001 # Query 3 # COMMIT master-bin.000001 # Query 3 # use `test`; drop table `test`.`bug45756_master_logged_1` master-bin.000001 # Query 3 # use `test`; CREATE TABLE bug45756_master_logged_2 (a int) engine = NDB master-bin.000001 # Query 3 # BEGIN master-bin.000001 # Table_map 3 # table_id: # (test.bug45756_master_logged_2) master-bin.000001 # Table_map 3 # table_id: # (mysql.ndb_apply_status) master-bin.000001 # Write_rows 3 # table_id: # master-bin.000001 # Write_rows 3 # table_id: # flags: STMT_END_F master-bin.000001 # Query 3 # COMMIT master-bin.000001 # Query 3 # use `test`; drop table `test`.`bug45756_master_logged_2` master-bin.000001 # Query 3 # use `test`; CREATE TABLE bug45756_master_logged_3 (a int) engine = NDB master-bin.000001 # Query 3 # BEGIN master-bin.000001 # Table_map 3 # table_id: # (test.bug45756_master_logged_3) master-bin.000001 # Table_map 3 # table_id: # (mysql.ndb_apply_status) master-bin.000001 # Write_rows 3 # table_id: # master-bin.000001 # Write_rows 3 # table_id: # flags: STMT_END_F master-bin.000001 # Query 3 # COMMIT master-bin.000001 # Query 3 # use `test`; DROP TABLE `bug45756_master_logged_3` /* generated by server */ select replace(right(txt, length(txt)-17), '\r', '') as binlog_entries from raw_binlog_rows where txt like '%server id%' and not (txt like '%Start%' or txt like '%Rotate%'); binlog_entries server id 3 Query server id 3 Query server id 3 Table_map: `test`.`bug45756_master_logged_1` server id 3 Table_map: `mysql`.`ndb_apply_status` server id 3 Write_rows: server id 3 Write_rows: flags: STMT_END_F server id 3 Query server id 3 Query server id 3 Query server id 3 Query server id 3 Table_map: `test`.`bug45756_master_logged_2` server id 3 Table_map: `mysql`.`ndb_apply_status` server id 3 Write_rows: server id 3 Write_rows: flags: STMT_END_F server id 3 Query server id 3 Query server id 3 Query server id 3 Query server id 3 Table_map: `test`.`bug45756_master_logged_3` server id 3 Table_map: `mysql`.`ndb_apply_status` server id 3 Write_rows: server id 3 Write_rows: flags: STMT_END_F server id 3 Query server id 3 Query connection srv_slave; show variables like 'server_id'; Variable_name Value server_id 4 show variables like 'log_bin'; Variable_name Value log_bin OFF show variables like 'log_slave_updates'; Variable_name Value log_slave_updates OFF show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info connection srv_slave1; show variables like 'server_id'; Variable_name Value server_id 5 show variables like 'log_bin'; Variable_name Value log_bin ON show variables like 'log_slave_updates'; Variable_name Value log_slave_updates OFF show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info slave-master-bin.000001 # Query 5 # use `test`; CREATE TABLE bug_45756_slave_logged_1 (a int) engine = NDB slave-master-bin.000001 # Query 5 # BEGIN slave-master-bin.000001 # Table_map 5 # table_id: # (test.bug_45756_slave_logged_1) slave-master-bin.000001 # Table_map 5 # table_id: # (mysql.ndb_apply_status) slave-master-bin.000001 # Write_rows 5 # table_id: # slave-master-bin.000001 # Write_rows 5 # table_id: # flags: STMT_END_F slave-master-bin.000001 # Query 5 # COMMIT slave-master-bin.000001 # Query 5 # use `test`; drop table `test`.`bug_45756_slave_logged_1` slave-master-bin.000001 # Query 5 # use `test`; CREATE TABLE bug_45756_slave_logged_2 (a int) engine = NDB slave-master-bin.000001 # Query 5 # BEGIN slave-master-bin.000001 # Table_map 5 # table_id: # (test.bug_45756_slave_logged_2) slave-master-bin.000001 # Table_map 5 # table_id: # (mysql.ndb_apply_status) slave-master-bin.000001 # Write_rows 5 # table_id: # slave-master-bin.000001 # Write_rows 5 # table_id: # flags: STMT_END_F slave-master-bin.000001 # Query 5 # COMMIT slave-master-bin.000001 # Query 5 # use `test`; DROP TABLE `bug_45756_slave_logged_2` /* generated by server */ slave-master-bin.000001 # Query 5 # use `test`; CREATE TABLE bug_45756_slave_logged_3 (a int) engine = NDB slave-master-bin.000001 # Query 5 # BEGIN slave-master-bin.000001 # Table_map 5 # table_id: # (test.bug_45756_slave_logged_3) slave-master-bin.000001 # Table_map 5 # table_id: # (mysql.ndb_apply_status) slave-master-bin.000001 # Write_rows 5 # table_id: # slave-master-bin.000001 # Write_rows 5 # table_id: # flags: STMT_END_F slave-master-bin.000001 # Query 5 # COMMIT slave-master-bin.000001 # Query 5 # use `test`; drop table `test`.`bug_45756_slave_logged_3` select replace(right(txt, length(txt)-17), '\r', '') as binlog_entries from raw_binlog_rows where txt like '%server id%' and not (txt like '%Start%' or txt like '%Rotate%'); binlog_entries server id 5 Query server id 5 Query server id 5 Table_map: `test`.`bug_45756_slave_logged_1` server id 5 Table_map: `mysql`.`ndb_apply_status` server id 5 Write_rows: server id 5 Write_rows: flags: STMT_END_F server id 5 Query server id 5 Query server id 5 Query server id 5 Query server id 5 Table_map: `test`.`bug_45756_slave_logged_2` server id 5 Table_map: `mysql`.`ndb_apply_status` server id 5 Write_rows: server id 5 Write_rows: flags: STMT_END_F server id 5 Query server id 5 Query server id 5 Query server id 5 Query server id 5 Table_map: `test`.`bug_45756_slave_logged_3` server id 5 Table_map: `mysql`.`ndb_apply_status` server id 5 Write_rows: server id 5 Write_rows: flags: STMT_END_F server id 5 Query server id 5 Query connection srv_slave2; show variables like 'server_id'; Variable_name Value server_id 6 show variables like 'log_bin'; Variable_name Value log_bin ON show variables like 'log_slave_updates'; Variable_name Value log_slave_updates ON show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info slave-master-bin.000001 # Query 6 # use `test`; CREATE TABLE bug_45756_slave_logged_1 (a int) engine = NDB slave-master-bin.000001 # Query 6 # BEGIN slave-master-bin.000001 # Table_map 6 # table_id: # (test.bug_45756_slave_logged_1) slave-master-bin.000001 # Table_map 6 # table_id: # (mysql.ndb_apply_status) slave-master-bin.000001 # Write_rows 6 # table_id: # slave-master-bin.000001 # Write_rows 6 # table_id: # flags: STMT_END_F slave-master-bin.000001 # Query 6 # COMMIT slave-master-bin.000001 # Query 6 # use `test`; drop table `test`.`bug_45756_slave_logged_1` slave-master-bin.000001 # Query 6 # use `test`; CREATE TABLE bug_45756_slave_logged_2 (a int) engine = NDB slave-master-bin.000001 # Query 6 # BEGIN slave-master-bin.000001 # Table_map 6 # table_id: # (test.bug_45756_slave_logged_2) slave-master-bin.000001 # Table_map 6 # table_id: # (mysql.ndb_apply_status) slave-master-bin.000001 # Write_rows 6 # table_id: # slave-master-bin.000001 # Write_rows 6 # table_id: # flags: STMT_END_F slave-master-bin.000001 # Query 6 # COMMIT slave-master-bin.000001 # Query 6 # use `test`; drop table `test`.`bug_45756_slave_logged_2` slave-master-bin.000001 # Query 6 # use `test`; CREATE TABLE bug_45756_slave_logged_3 (a int) engine = NDB slave-master-bin.000001 # Query 6 # BEGIN slave-master-bin.000001 # Table_map 6 # table_id: # (test.bug_45756_slave_logged_3) slave-master-bin.000001 # Table_map 6 # table_id: # (mysql.ndb_apply_status) slave-master-bin.000001 # Write_rows 6 # table_id: # slave-master-bin.000001 # Write_rows 6 # table_id: # flags: STMT_END_F slave-master-bin.000001 # Query 6 # COMMIT slave-master-bin.000001 # Query 6 # use `test`; DROP TABLE `bug_45756_slave_logged_3` /* generated by server */ slave-master-bin.000001 # Query 1 # use `test`; CREATE TABLE bug45756_master_logged_1 (a int) engine = NDB slave-master-bin.000001 # Query 6 # BEGIN slave-master-bin.000001 # Table_map 6 # table_id: # (test.bug45756_master_logged_1) slave-master-bin.000001 # Table_map 6 # table_id: # (mysql.ndb_apply_status) slave-master-bin.000001 # Write_rows 6 # table_id: # slave-master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F slave-master-bin.000001 # Query 6 # COMMIT slave-master-bin.000001 # Query 1 # use `test`; drop table `test`.`bug45756_master_logged_1` slave-master-bin.000001 # Query 1 # use `test`; CREATE TABLE bug45756_master_logged_2 (a int) engine = NDB slave-master-bin.000001 # Query 6 # BEGIN slave-master-bin.000001 # Table_map 6 # table_id: # (test.bug45756_master_logged_2) slave-master-bin.000001 # Table_map 6 # table_id: # (mysql.ndb_apply_status) slave-master-bin.000001 # Write_rows 6 # table_id: # slave-master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F slave-master-bin.000001 # Query 6 # COMMIT slave-master-bin.000001 # Query 1 # use `test`; drop table `test`.`bug45756_master_logged_2` slave-master-bin.000001 # Query 1 # use `test`; CREATE TABLE bug45756_master_logged_3 (a int) engine = NDB slave-master-bin.000001 # Query 6 # BEGIN slave-master-bin.000001 # Table_map 6 # table_id: # (test.bug45756_master_logged_3) slave-master-bin.000001 # Table_map 6 # table_id: # (mysql.ndb_apply_status) slave-master-bin.000001 # Write_rows 6 # table_id: # slave-master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F slave-master-bin.000001 # Query 6 # COMMIT slave-master-bin.000001 # Query 1 # use `test`; drop table `test`.`bug45756_master_logged_3` select replace(right(txt, length(txt)-17), '\r', '') as binlog_entries from raw_binlog_rows where txt like '%server id%' and not (txt like '%Start%' or txt like '%Rotate%'); binlog_entries server id 6 Query server id 6 Query server id 6 Table_map: `test`.`bug_45756_slave_logged_1` server id 6 Table_map: `mysql`.`ndb_apply_status` server id 6 Write_rows: server id 6 Write_rows: flags: STMT_END_F server id 6 Query server id 6 Query server id 6 Query server id 6 Query server id 6 Table_map: `test`.`bug_45756_slave_logged_2` server id 6 Table_map: `mysql`.`ndb_apply_status` server id 6 Write_rows: server id 6 Write_rows: flags: STMT_END_F server id 6 Query server id 6 Query server id 6 Query server id 6 Query server id 6 Table_map: `test`.`bug_45756_slave_logged_3` server id 6 Table_map: `mysql`.`ndb_apply_status` server id 6 Write_rows: server id 6 Write_rows: flags: STMT_END_F server id 6 Query server id 6 Query server id 1 Query server id 6 Query server id 6 Table_map: `test`.`bug45756_master_logged_1` server id 6 Table_map: `mysql`.`ndb_apply_status` server id 6 Write_rows: server id 1 Write_rows: flags: STMT_END_F server id 6 Query server id 1 Query server id 1 Query server id 6 Query server id 6 Table_map: `test`.`bug45756_master_logged_2` server id 6 Table_map: `mysql`.`ndb_apply_status` server id 6 Write_rows: server id 1 Write_rows: flags: STMT_END_F server id 6 Query server id 1 Query server id 1 Query server id 6 Query server id 6 Table_map: `test`.`bug45756_master_logged_3` server id 6 Table_map: `mysql`.`ndb_apply_status` server id 6 Write_rows: server id 1 Write_rows: flags: STMT_END_F server id 6 Query server id 1 Query include/stop_slave.inc *** Configuring replication via Slave1 *** [connection srv_slave1] include/rpl_change_topology.inc [new topology=1->4,1->5] include/start_slave.inc *** Generating slave cluster originated binloggable changes *** CREATE TABLE bug_45756_slave_logged_1 (a int) engine = NDB; INSERT INTO bug_45756_slave_logged_1 VALUES (1); DROP TABLE bug_45756_slave_logged_1; CREATE TABLE bug_45756_slave_logged_2 (a int) engine = NDB; INSERT INTO bug_45756_slave_logged_2 VALUES (1); DROP TABLE bug_45756_slave_logged_2; CREATE TABLE bug_45756_slave_logged_3 (a int) engine = NDB; INSERT INTO bug_45756_slave_logged_3 VALUES (1); DROP TABLE bug_45756_slave_logged_3; ***Generating slave cluster non-binloggable changes*** SET SQL_LOG_BIN= 0; CREATE TABLE bug_45756_slave_not_logged_1 (a int) engine = NDB; INSERT INTO bug_45756_slave_not_logged_1 VALUES (1); DROP TABLE bug_45756_slave_not_logged_1; SET SQL_LOG_BIN= 1; SET SQL_LOG_BIN= 0; CREATE TABLE bug_45756_slave_not_logged_2 (a int) engine = NDB; INSERT INTO bug_45756_slave_not_logged_2 VALUES (1); DROP TABLE bug_45756_slave_not_logged_2; SET SQL_LOG_BIN= 1; SET SQL_LOG_BIN= 0; CREATE TABLE bug_45756_slave_not_logged_3 (a int) engine = NDB; INSERT INTO bug_45756_slave_not_logged_3 VALUES (1); DROP TABLE bug_45756_slave_not_logged_3; SET SQL_LOG_BIN= 1; *** Generating data to be replicated *** CREATE TABLE bug45756_master_logged_1 (a int) engine = NDB; INSERT INTO bug45756_master_logged_1 VALUES (1); DROP TABLE bug45756_master_logged_1; CREATE TABLE bug45756_master_logged_2 (a int) engine = NDB; INSERT INTO bug45756_master_logged_2 VALUES (1); DROP TABLE bug45756_master_logged_2; CREATE TABLE bug45756_master_logged_3 (a int) engine = NDB; INSERT INTO bug45756_master_logged_3 VALUES (1); DROP TABLE bug45756_master_logged_3; *** Generating changes not to be replicated *** SET SQL_LOG_BIN= 0; CREATE TABLE bug45756_master_not_logged_1 (a int) engine = NDB; INSERT INTO bug45756_master_not_logged_1 VALUES (1); DROP TABLE bug45756_master_not_logged_1; SET SQL_LOG_BIN= 1; SET SQL_LOG_BIN= 0; CREATE TABLE bug45756_master_not_logged_2 (a int) engine = NDB; INSERT INTO bug45756_master_not_logged_2 VALUES (1); DROP TABLE bug45756_master_not_logged_2; SET SQL_LOG_BIN= 1; SET SQL_LOG_BIN= 0; CREATE TABLE bug45756_master_not_logged_3 (a int) engine = NDB; INSERT INTO bug45756_master_not_logged_3 VALUES (1); DROP TABLE bug45756_master_not_logged_3; SET SQL_LOG_BIN= 1; *** Checking binlog contents on every server in both clusters *** connection srv_master; show variables like 'server_id'; Variable_name Value server_id 1 show variables like 'log_bin'; Variable_name Value log_bin ON show variables like 'log_slave_updates'; Variable_name Value log_slave_updates OFF show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query 1 # use `test`; CREATE TABLE bug45756_master_logged_1 (a int) engine = NDB master-bin.000001 # Query 1 # BEGIN master-bin.000001 # Table_map 1 # table_id: # (test.bug45756_master_logged_1) master-bin.000001 # Table_map 1 # table_id: # (mysql.ndb_apply_status) master-bin.000001 # Write_rows 1 # table_id: # master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F master-bin.000001 # Query 1 # COMMIT master-bin.000001 # Query 1 # use `test`; DROP TABLE `bug45756_master_logged_1` /* generated by server */ master-bin.000001 # Query 1 # use `test`; CREATE TABLE bug45756_master_logged_2 (a int) engine = NDB master-bin.000001 # Query 1 # BEGIN master-bin.000001 # Table_map 1 # table_id: # (test.bug45756_master_logged_2) master-bin.000001 # Table_map 1 # table_id: # (mysql.ndb_apply_status) master-bin.000001 # Write_rows 1 # table_id: # master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F master-bin.000001 # Query 1 # COMMIT master-bin.000001 # Query 1 # use `test`; drop table `test`.`bug45756_master_logged_2` master-bin.000001 # Query 1 # use `test`; CREATE TABLE bug45756_master_logged_3 (a int) engine = NDB master-bin.000001 # Query 1 # BEGIN master-bin.000001 # Table_map 1 # table_id: # (test.bug45756_master_logged_3) master-bin.000001 # Table_map 1 # table_id: # (mysql.ndb_apply_status) master-bin.000001 # Write_rows 1 # table_id: # master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F master-bin.000001 # Query 1 # COMMIT master-bin.000001 # Query 1 # use `test`; drop table `test`.`bug45756_master_logged_3` select replace(right(txt, length(txt)-17), '\r', '') as binlog_entries from raw_binlog_rows where txt like '%server id%' and not (txt like '%Start%' or txt like '%Rotate%'); binlog_entries server id 1 Query server id 1 Query server id 1 Table_map: `test`.`bug45756_master_logged_1` server id 1 Table_map: `mysql`.`ndb_apply_status` server id 1 Write_rows: server id 1 Write_rows: flags: STMT_END_F server id 1 Query server id 1 Query server id 1 Query server id 1 Query server id 1 Table_map: `test`.`bug45756_master_logged_2` server id 1 Table_map: `mysql`.`ndb_apply_status` server id 1 Write_rows: server id 1 Write_rows: flags: STMT_END_F server id 1 Query server id 1 Query server id 1 Query server id 1 Query server id 1 Table_map: `test`.`bug45756_master_logged_3` server id 1 Table_map: `mysql`.`ndb_apply_status` server id 1 Write_rows: server id 1 Write_rows: flags: STMT_END_F server id 1 Query server id 1 Query connection srv_master1; show variables like 'server_id'; Variable_name Value server_id 2 show variables like 'log_bin'; Variable_name Value log_bin OFF show variables like 'log_slave_updates'; Variable_name Value log_slave_updates OFF show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info connection srv_master2; show variables like 'server_id'; Variable_name Value server_id 3 show variables like 'log_bin'; Variable_name Value log_bin ON show variables like 'log_slave_updates'; Variable_name Value log_slave_updates OFF show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query 3 # use `test`; CREATE TABLE bug45756_master_logged_1 (a int) engine = NDB master-bin.000001 # Query 3 # BEGIN master-bin.000001 # Table_map 3 # table_id: # (test.bug45756_master_logged_1) master-bin.000001 # Table_map 3 # table_id: # (mysql.ndb_apply_status) master-bin.000001 # Write_rows 3 # table_id: # master-bin.000001 # Write_rows 3 # table_id: # flags: STMT_END_F master-bin.000001 # Query 3 # COMMIT master-bin.000001 # Query 3 # use `test`; drop table `test`.`bug45756_master_logged_1` master-bin.000001 # Query 3 # use `test`; CREATE TABLE bug45756_master_logged_2 (a int) engine = NDB master-bin.000001 # Query 3 # BEGIN master-bin.000001 # Table_map 3 # table_id: # (test.bug45756_master_logged_2) master-bin.000001 # Table_map 3 # table_id: # (mysql.ndb_apply_status) master-bin.000001 # Write_rows 3 # table_id: # master-bin.000001 # Write_rows 3 # table_id: # flags: STMT_END_F master-bin.000001 # Query 3 # COMMIT master-bin.000001 # Query 3 # use `test`; drop table `test`.`bug45756_master_logged_2` master-bin.000001 # Query 3 # use `test`; CREATE TABLE bug45756_master_logged_3 (a int) engine = NDB master-bin.000001 # Query 3 # BEGIN master-bin.000001 # Table_map 3 # table_id: # (test.bug45756_master_logged_3) master-bin.000001 # Table_map 3 # table_id: # (mysql.ndb_apply_status) master-bin.000001 # Write_rows 3 # table_id: # master-bin.000001 # Write_rows 3 # table_id: # flags: STMT_END_F master-bin.000001 # Query 3 # COMMIT master-bin.000001 # Query 3 # use `test`; DROP TABLE `bug45756_master_logged_3` /* generated by server */ select replace(right(txt, length(txt)-17), '\r', '') as binlog_entries from raw_binlog_rows where txt like '%server id%' and not (txt like '%Start%' or txt like '%Rotate%'); binlog_entries server id 3 Query server id 3 Query server id 3 Table_map: `test`.`bug45756_master_logged_1` server id 3 Table_map: `mysql`.`ndb_apply_status` server id 3 Write_rows: server id 3 Write_rows: flags: STMT_END_F server id 3 Query server id 3 Query server id 3 Query server id 3 Query server id 3 Table_map: `test`.`bug45756_master_logged_2` server id 3 Table_map: `mysql`.`ndb_apply_status` server id 3 Write_rows: server id 3 Write_rows: flags: STMT_END_F server id 3 Query server id 3 Query server id 3 Query server id 3 Query server id 3 Table_map: `test`.`bug45756_master_logged_3` server id 3 Table_map: `mysql`.`ndb_apply_status` server id 3 Write_rows: server id 3 Write_rows: flags: STMT_END_F server id 3 Query server id 3 Query connection srv_slave; show variables like 'server_id'; Variable_name Value server_id 4 show variables like 'log_bin'; Variable_name Value log_bin OFF show variables like 'log_slave_updates'; Variable_name Value log_slave_updates OFF show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info connection srv_slave1; show variables like 'server_id'; Variable_name Value server_id 5 show variables like 'log_bin'; Variable_name Value log_bin ON show variables like 'log_slave_updates'; Variable_name Value log_slave_updates OFF show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info slave-master-bin.000001 # Query 5 # use `test`; CREATE TABLE bug_45756_slave_logged_1 (a int) engine = NDB slave-master-bin.000001 # Query 5 # BEGIN slave-master-bin.000001 # Table_map 5 # table_id: # (test.bug_45756_slave_logged_1) slave-master-bin.000001 # Table_map 5 # table_id: # (mysql.ndb_apply_status) slave-master-bin.000001 # Write_rows 5 # table_id: # slave-master-bin.000001 # Write_rows 5 # table_id: # flags: STMT_END_F slave-master-bin.000001 # Query 5 # COMMIT slave-master-bin.000001 # Query 5 # use `test`; drop table `test`.`bug_45756_slave_logged_1` slave-master-bin.000001 # Query 5 # use `test`; CREATE TABLE bug_45756_slave_logged_2 (a int) engine = NDB slave-master-bin.000001 # Query 5 # BEGIN slave-master-bin.000001 # Table_map 5 # table_id: # (test.bug_45756_slave_logged_2) slave-master-bin.000001 # Table_map 5 # table_id: # (mysql.ndb_apply_status) slave-master-bin.000001 # Write_rows 5 # table_id: # slave-master-bin.000001 # Write_rows 5 # table_id: # flags: STMT_END_F slave-master-bin.000001 # Query 5 # COMMIT slave-master-bin.000001 # Query 5 # use `test`; DROP TABLE `bug_45756_slave_logged_2` /* generated by server */ slave-master-bin.000001 # Query 5 # use `test`; CREATE TABLE bug_45756_slave_logged_3 (a int) engine = NDB slave-master-bin.000001 # Query 5 # BEGIN slave-master-bin.000001 # Table_map 5 # table_id: # (test.bug_45756_slave_logged_3) slave-master-bin.000001 # Table_map 5 # table_id: # (mysql.ndb_apply_status) slave-master-bin.000001 # Write_rows 5 # table_id: # slave-master-bin.000001 # Write_rows 5 # table_id: # flags: STMT_END_F slave-master-bin.000001 # Query 5 # COMMIT slave-master-bin.000001 # Query 5 # use `test`; drop table `test`.`bug_45756_slave_logged_3` select replace(right(txt, length(txt)-17), '\r', '') as binlog_entries from raw_binlog_rows where txt like '%server id%' and not (txt like '%Start%' or txt like '%Rotate%'); binlog_entries server id 5 Query server id 5 Query server id 5 Table_map: `test`.`bug_45756_slave_logged_1` server id 5 Table_map: `mysql`.`ndb_apply_status` server id 5 Write_rows: server id 5 Write_rows: flags: STMT_END_F server id 5 Query server id 5 Query server id 5 Query server id 5 Query server id 5 Table_map: `test`.`bug_45756_slave_logged_2` server id 5 Table_map: `mysql`.`ndb_apply_status` server id 5 Write_rows: server id 5 Write_rows: flags: STMT_END_F server id 5 Query server id 5 Query server id 5 Query server id 5 Query server id 5 Table_map: `test`.`bug_45756_slave_logged_3` server id 5 Table_map: `mysql`.`ndb_apply_status` server id 5 Write_rows: server id 5 Write_rows: flags: STMT_END_F server id 5 Query server id 5 Query connection srv_slave2; show variables like 'server_id'; Variable_name Value server_id 6 show variables like 'log_bin'; Variable_name Value log_bin ON show variables like 'log_slave_updates'; Variable_name Value log_slave_updates ON show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info slave-master-bin.000001 # Query 6 # use `test`; CREATE TABLE bug_45756_slave_logged_1 (a int) engine = NDB slave-master-bin.000001 # Query 6 # BEGIN slave-master-bin.000001 # Table_map 6 # table_id: # (test.bug_45756_slave_logged_1) slave-master-bin.000001 # Table_map 6 # table_id: # (mysql.ndb_apply_status) slave-master-bin.000001 # Write_rows 6 # table_id: # slave-master-bin.000001 # Write_rows 6 # table_id: # flags: STMT_END_F slave-master-bin.000001 # Query 6 # COMMIT slave-master-bin.000001 # Query 6 # use `test`; drop table `test`.`bug_45756_slave_logged_1` slave-master-bin.000001 # Query 6 # use `test`; CREATE TABLE bug_45756_slave_logged_2 (a int) engine = NDB slave-master-bin.000001 # Query 6 # BEGIN slave-master-bin.000001 # Table_map 6 # table_id: # (test.bug_45756_slave_logged_2) slave-master-bin.000001 # Table_map 6 # table_id: # (mysql.ndb_apply_status) slave-master-bin.000001 # Write_rows 6 # table_id: # slave-master-bin.000001 # Write_rows 6 # table_id: # flags: STMT_END_F slave-master-bin.000001 # Query 6 # COMMIT slave-master-bin.000001 # Query 6 # use `test`; drop table `test`.`bug_45756_slave_logged_2` slave-master-bin.000001 # Query 6 # use `test`; CREATE TABLE bug_45756_slave_logged_3 (a int) engine = NDB slave-master-bin.000001 # Query 6 # BEGIN slave-master-bin.000001 # Table_map 6 # table_id: # (test.bug_45756_slave_logged_3) slave-master-bin.000001 # Table_map 6 # table_id: # (mysql.ndb_apply_status) slave-master-bin.000001 # Write_rows 6 # table_id: # slave-master-bin.000001 # Write_rows 6 # table_id: # flags: STMT_END_F slave-master-bin.000001 # Query 6 # COMMIT slave-master-bin.000001 # Query 6 # use `test`; DROP TABLE `bug_45756_slave_logged_3` /* generated by server */ slave-master-bin.000001 # Query 1 # use `test`; CREATE TABLE bug45756_master_logged_1 (a int) engine = NDB slave-master-bin.000001 # Query 6 # BEGIN slave-master-bin.000001 # Table_map 6 # table_id: # (test.bug45756_master_logged_1) slave-master-bin.000001 # Table_map 6 # table_id: # (mysql.ndb_apply_status) slave-master-bin.000001 # Write_rows 6 # table_id: # slave-master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F slave-master-bin.000001 # Query 6 # COMMIT slave-master-bin.000001 # Query 1 # use `test`; drop table `test`.`bug45756_master_logged_1` slave-master-bin.000001 # Query 1 # use `test`; CREATE TABLE bug45756_master_logged_2 (a int) engine = NDB slave-master-bin.000001 # Query 6 # BEGIN slave-master-bin.000001 # Table_map 6 # table_id: # (test.bug45756_master_logged_2) slave-master-bin.000001 # Table_map 6 # table_id: # (mysql.ndb_apply_status) slave-master-bin.000001 # Write_rows 6 # table_id: # slave-master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F slave-master-bin.000001 # Query 6 # COMMIT slave-master-bin.000001 # Query 1 # use `test`; drop table `test`.`bug45756_master_logged_2` slave-master-bin.000001 # Query 1 # use `test`; CREATE TABLE bug45756_master_logged_3 (a int) engine = NDB slave-master-bin.000001 # Query 6 # BEGIN slave-master-bin.000001 # Table_map 6 # table_id: # (test.bug45756_master_logged_3) slave-master-bin.000001 # Table_map 6 # table_id: # (mysql.ndb_apply_status) slave-master-bin.000001 # Write_rows 6 # table_id: # slave-master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F slave-master-bin.000001 # Query 6 # COMMIT slave-master-bin.000001 # Query 1 # use `test`; drop table `test`.`bug45756_master_logged_3` select replace(right(txt, length(txt)-17), '\r', '') as binlog_entries from raw_binlog_rows where txt like '%server id%' and not (txt like '%Start%' or txt like '%Rotate%'); binlog_entries server id 6 Query server id 6 Query server id 6 Table_map: `test`.`bug_45756_slave_logged_1` server id 6 Table_map: `mysql`.`ndb_apply_status` server id 6 Write_rows: server id 6 Write_rows: flags: STMT_END_F server id 6 Query server id 6 Query server id 6 Query server id 6 Query server id 6 Table_map: `test`.`bug_45756_slave_logged_2` server id 6 Table_map: `mysql`.`ndb_apply_status` server id 6 Write_rows: server id 6 Write_rows: flags: STMT_END_F server id 6 Query server id 6 Query server id 6 Query server id 6 Query server id 6 Table_map: `test`.`bug_45756_slave_logged_3` server id 6 Table_map: `mysql`.`ndb_apply_status` server id 6 Write_rows: server id 6 Write_rows: flags: STMT_END_F server id 6 Query server id 6 Query server id 1 Query server id 6 Query server id 6 Table_map: `test`.`bug45756_master_logged_1` server id 6 Table_map: `mysql`.`ndb_apply_status` server id 6 Write_rows: server id 1 Write_rows: flags: STMT_END_F server id 6 Query server id 1 Query server id 1 Query server id 6 Query server id 6 Table_map: `test`.`bug45756_master_logged_2` server id 6 Table_map: `mysql`.`ndb_apply_status` server id 6 Write_rows: server id 1 Write_rows: flags: STMT_END_F server id 6 Query server id 1 Query server id 1 Query server id 6 Query server id 6 Table_map: `test`.`bug45756_master_logged_3` server id 6 Table_map: `mysql`.`ndb_apply_status` server id 6 Write_rows: server id 1 Write_rows: flags: STMT_END_F server id 6 Query server id 1 Query include/stop_slave.inc *** Configuring replication via Slave2 *** [connection srv_slave2] include/rpl_change_topology.inc [new topology=1->4,1->5,1->6] include/start_slave.inc *** Generating slave cluster originated binloggable changes *** CREATE TABLE bug_45756_slave_logged_1 (a int) engine = NDB; INSERT INTO bug_45756_slave_logged_1 VALUES (1); DROP TABLE bug_45756_slave_logged_1; CREATE TABLE bug_45756_slave_logged_2 (a int) engine = NDB; INSERT INTO bug_45756_slave_logged_2 VALUES (1); DROP TABLE bug_45756_slave_logged_2; CREATE TABLE bug_45756_slave_logged_3 (a int) engine = NDB; INSERT INTO bug_45756_slave_logged_3 VALUES (1); DROP TABLE bug_45756_slave_logged_3; ***Generating slave cluster non-binloggable changes*** SET SQL_LOG_BIN= 0; CREATE TABLE bug_45756_slave_not_logged_1 (a int) engine = NDB; INSERT INTO bug_45756_slave_not_logged_1 VALUES (1); DROP TABLE bug_45756_slave_not_logged_1; SET SQL_LOG_BIN= 1; SET SQL_LOG_BIN= 0; CREATE TABLE bug_45756_slave_not_logged_2 (a int) engine = NDB; INSERT INTO bug_45756_slave_not_logged_2 VALUES (1); DROP TABLE bug_45756_slave_not_logged_2; SET SQL_LOG_BIN= 1; SET SQL_LOG_BIN= 0; CREATE TABLE bug_45756_slave_not_logged_3 (a int) engine = NDB; INSERT INTO bug_45756_slave_not_logged_3 VALUES (1); DROP TABLE bug_45756_slave_not_logged_3; SET SQL_LOG_BIN= 1; *** Generating data to be replicated *** CREATE TABLE bug45756_master_logged_1 (a int) engine = NDB; INSERT INTO bug45756_master_logged_1 VALUES (1); DROP TABLE bug45756_master_logged_1; CREATE TABLE bug45756_master_logged_2 (a int) engine = NDB; INSERT INTO bug45756_master_logged_2 VALUES (1); DROP TABLE bug45756_master_logged_2; CREATE TABLE bug45756_master_logged_3 (a int) engine = NDB; INSERT INTO bug45756_master_logged_3 VALUES (1); DROP TABLE bug45756_master_logged_3; *** Generating changes not to be replicated *** SET SQL_LOG_BIN= 0; CREATE TABLE bug45756_master_not_logged_1 (a int) engine = NDB; INSERT INTO bug45756_master_not_logged_1 VALUES (1); DROP TABLE bug45756_master_not_logged_1; SET SQL_LOG_BIN= 1; SET SQL_LOG_BIN= 0; CREATE TABLE bug45756_master_not_logged_2 (a int) engine = NDB; INSERT INTO bug45756_master_not_logged_2 VALUES (1); DROP TABLE bug45756_master_not_logged_2; SET SQL_LOG_BIN= 1; SET SQL_LOG_BIN= 0; CREATE TABLE bug45756_master_not_logged_3 (a int) engine = NDB; INSERT INTO bug45756_master_not_logged_3 VALUES (1); DROP TABLE bug45756_master_not_logged_3; SET SQL_LOG_BIN= 1; *** Checking binlog contents on every server in both clusters *** connection srv_master; show variables like 'server_id'; Variable_name Value server_id 1 show variables like 'log_bin'; Variable_name Value log_bin ON show variables like 'log_slave_updates'; Variable_name Value log_slave_updates OFF show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query 1 # use `test`; CREATE TABLE bug45756_master_logged_1 (a int) engine = NDB master-bin.000001 # Query 1 # BEGIN master-bin.000001 # Table_map 1 # table_id: # (test.bug45756_master_logged_1) master-bin.000001 # Table_map 1 # table_id: # (mysql.ndb_apply_status) master-bin.000001 # Write_rows 1 # table_id: # master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F master-bin.000001 # Query 1 # COMMIT master-bin.000001 # Query 1 # use `test`; DROP TABLE `bug45756_master_logged_1` /* generated by server */ master-bin.000001 # Query 1 # use `test`; CREATE TABLE bug45756_master_logged_2 (a int) engine = NDB master-bin.000001 # Query 1 # BEGIN master-bin.000001 # Table_map 1 # table_id: # (test.bug45756_master_logged_2) master-bin.000001 # Table_map 1 # table_id: # (mysql.ndb_apply_status) master-bin.000001 # Write_rows 1 # table_id: # master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F master-bin.000001 # Query 1 # COMMIT master-bin.000001 # Query 1 # use `test`; drop table `test`.`bug45756_master_logged_2` master-bin.000001 # Query 1 # use `test`; CREATE TABLE bug45756_master_logged_3 (a int) engine = NDB master-bin.000001 # Query 1 # BEGIN master-bin.000001 # Table_map 1 # table_id: # (test.bug45756_master_logged_3) master-bin.000001 # Table_map 1 # table_id: # (mysql.ndb_apply_status) master-bin.000001 # Write_rows 1 # table_id: # master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F master-bin.000001 # Query 1 # COMMIT master-bin.000001 # Query 1 # use `test`; drop table `test`.`bug45756_master_logged_3` select replace(right(txt, length(txt)-17), '\r', '') as binlog_entries from raw_binlog_rows where txt like '%server id%' and not (txt like '%Start%' or txt like '%Rotate%'); binlog_entries server id 1 Query server id 1 Query server id 1 Table_map: `test`.`bug45756_master_logged_1` server id 1 Table_map: `mysql`.`ndb_apply_status` server id 1 Write_rows: server id 1 Write_rows: flags: STMT_END_F server id 1 Query server id 1 Query server id 1 Query server id 1 Query server id 1 Table_map: `test`.`bug45756_master_logged_2` server id 1 Table_map: `mysql`.`ndb_apply_status` server id 1 Write_rows: server id 1 Write_rows: flags: STMT_END_F server id 1 Query server id 1 Query server id 1 Query server id 1 Query server id 1 Table_map: `test`.`bug45756_master_logged_3` server id 1 Table_map: `mysql`.`ndb_apply_status` server id 1 Write_rows: server id 1 Write_rows: flags: STMT_END_F server id 1 Query server id 1 Query connection srv_master1; show variables like 'server_id'; Variable_name Value server_id 2 show variables like 'log_bin'; Variable_name Value log_bin OFF show variables like 'log_slave_updates'; Variable_name Value log_slave_updates OFF show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info connection srv_master2; show variables like 'server_id'; Variable_name Value server_id 3 show variables like 'log_bin'; Variable_name Value log_bin ON show variables like 'log_slave_updates'; Variable_name Value log_slave_updates OFF show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query 3 # use `test`; CREATE TABLE bug45756_master_logged_1 (a int) engine = NDB master-bin.000001 # Query 3 # BEGIN master-bin.000001 # Table_map 3 # table_id: # (test.bug45756_master_logged_1) master-bin.000001 # Table_map 3 # table_id: # (mysql.ndb_apply_status) master-bin.000001 # Write_rows 3 # table_id: # master-bin.000001 # Write_rows 3 # table_id: # flags: STMT_END_F master-bin.000001 # Query 3 # COMMIT master-bin.000001 # Query 3 # use `test`; drop table `test`.`bug45756_master_logged_1` master-bin.000001 # Query 3 # use `test`; CREATE TABLE bug45756_master_logged_2 (a int) engine = NDB master-bin.000001 # Query 3 # BEGIN master-bin.000001 # Table_map 3 # table_id: # (test.bug45756_master_logged_2) master-bin.000001 # Table_map 3 # table_id: # (mysql.ndb_apply_status) master-bin.000001 # Write_rows 3 # table_id: # master-bin.000001 # Write_rows 3 # table_id: # flags: STMT_END_F master-bin.000001 # Query 3 # COMMIT master-bin.000001 # Query 3 # use `test`; drop table `test`.`bug45756_master_logged_2` master-bin.000001 # Query 3 # use `test`; CREATE TABLE bug45756_master_logged_3 (a int) engine = NDB master-bin.000001 # Query 3 # BEGIN master-bin.000001 # Table_map 3 # table_id: # (test.bug45756_master_logged_3) master-bin.000001 # Table_map 3 # table_id: # (mysql.ndb_apply_status) master-bin.000001 # Write_rows 3 # table_id: # master-bin.000001 # Write_rows 3 # table_id: # flags: STMT_END_F master-bin.000001 # Query 3 # COMMIT master-bin.000001 # Query 3 # use `test`; DROP TABLE `bug45756_master_logged_3` /* generated by server */ select replace(right(txt, length(txt)-17), '\r', '') as binlog_entries from raw_binlog_rows where txt like '%server id%' and not (txt like '%Start%' or txt like '%Rotate%'); binlog_entries server id 3 Query server id 3 Query server id 3 Table_map: `test`.`bug45756_master_logged_1` server id 3 Table_map: `mysql`.`ndb_apply_status` server id 3 Write_rows: server id 3 Write_rows: flags: STMT_END_F server id 3 Query server id 3 Query server id 3 Query server id 3 Query server id 3 Table_map: `test`.`bug45756_master_logged_2` server id 3 Table_map: `mysql`.`ndb_apply_status` server id 3 Write_rows: server id 3 Write_rows: flags: STMT_END_F server id 3 Query server id 3 Query server id 3 Query server id 3 Query server id 3 Table_map: `test`.`bug45756_master_logged_3` server id 3 Table_map: `mysql`.`ndb_apply_status` server id 3 Write_rows: server id 3 Write_rows: flags: STMT_END_F server id 3 Query server id 3 Query connection srv_slave; show variables like 'server_id'; Variable_name Value server_id 4 show variables like 'log_bin'; Variable_name Value log_bin OFF show variables like 'log_slave_updates'; Variable_name Value log_slave_updates OFF show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info connection srv_slave1; show variables like 'server_id'; Variable_name Value server_id 5 show variables like 'log_bin'; Variable_name Value log_bin ON show variables like 'log_slave_updates'; Variable_name Value log_slave_updates OFF show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info slave-master-bin.000001 # Query 5 # use `test`; CREATE TABLE bug_45756_slave_logged_1 (a int) engine = NDB slave-master-bin.000001 # Query 5 # BEGIN slave-master-bin.000001 # Table_map 5 # table_id: # (test.bug_45756_slave_logged_1) slave-master-bin.000001 # Table_map 5 # table_id: # (mysql.ndb_apply_status) slave-master-bin.000001 # Write_rows 5 # table_id: # slave-master-bin.000001 # Write_rows 5 # table_id: # flags: STMT_END_F slave-master-bin.000001 # Query 5 # COMMIT slave-master-bin.000001 # Query 5 # use `test`; drop table `test`.`bug_45756_slave_logged_1` slave-master-bin.000001 # Query 5 # use `test`; CREATE TABLE bug_45756_slave_logged_2 (a int) engine = NDB slave-master-bin.000001 # Query 5 # BEGIN slave-master-bin.000001 # Table_map 5 # table_id: # (test.bug_45756_slave_logged_2) slave-master-bin.000001 # Table_map 5 # table_id: # (mysql.ndb_apply_status) slave-master-bin.000001 # Write_rows 5 # table_id: # slave-master-bin.000001 # Write_rows 5 # table_id: # flags: STMT_END_F slave-master-bin.000001 # Query 5 # COMMIT slave-master-bin.000001 # Query 5 # use `test`; DROP TABLE `bug_45756_slave_logged_2` /* generated by server */ slave-master-bin.000001 # Query 5 # use `test`; CREATE TABLE bug_45756_slave_logged_3 (a int) engine = NDB slave-master-bin.000001 # Query 5 # BEGIN slave-master-bin.000001 # Table_map 5 # table_id: # (test.bug_45756_slave_logged_3) slave-master-bin.000001 # Table_map 5 # table_id: # (mysql.ndb_apply_status) slave-master-bin.000001 # Write_rows 5 # table_id: # slave-master-bin.000001 # Write_rows 5 # table_id: # flags: STMT_END_F slave-master-bin.000001 # Query 5 # COMMIT slave-master-bin.000001 # Query 5 # use `test`; drop table `test`.`bug_45756_slave_logged_3` select replace(right(txt, length(txt)-17), '\r', '') as binlog_entries from raw_binlog_rows where txt like '%server id%' and not (txt like '%Start%' or txt like '%Rotate%'); binlog_entries server id 5 Query server id 5 Query server id 5 Table_map: `test`.`bug_45756_slave_logged_1` server id 5 Table_map: `mysql`.`ndb_apply_status` server id 5 Write_rows: server id 5 Write_rows: flags: STMT_END_F server id 5 Query server id 5 Query server id 5 Query server id 5 Query server id 5 Table_map: `test`.`bug_45756_slave_logged_2` server id 5 Table_map: `mysql`.`ndb_apply_status` server id 5 Write_rows: server id 5 Write_rows: flags: STMT_END_F server id 5 Query server id 5 Query server id 5 Query server id 5 Query server id 5 Table_map: `test`.`bug_45756_slave_logged_3` server id 5 Table_map: `mysql`.`ndb_apply_status` server id 5 Write_rows: server id 5 Write_rows: flags: STMT_END_F server id 5 Query server id 5 Query connection srv_slave2; show variables like 'server_id'; Variable_name Value server_id 6 show variables like 'log_bin'; Variable_name Value log_bin ON show variables like 'log_slave_updates'; Variable_name Value log_slave_updates ON show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info slave-master-bin.000001 # Query 6 # use `test`; CREATE TABLE bug_45756_slave_logged_1 (a int) engine = NDB slave-master-bin.000001 # Query 6 # BEGIN slave-master-bin.000001 # Table_map 6 # table_id: # (test.bug_45756_slave_logged_1) slave-master-bin.000001 # Table_map 6 # table_id: # (mysql.ndb_apply_status) slave-master-bin.000001 # Write_rows 6 # table_id: # slave-master-bin.000001 # Write_rows 6 # table_id: # flags: STMT_END_F slave-master-bin.000001 # Query 6 # COMMIT slave-master-bin.000001 # Query 6 # use `test`; drop table `test`.`bug_45756_slave_logged_1` slave-master-bin.000001 # Query 6 # use `test`; CREATE TABLE bug_45756_slave_logged_2 (a int) engine = NDB slave-master-bin.000001 # Query 6 # BEGIN slave-master-bin.000001 # Table_map 6 # table_id: # (test.bug_45756_slave_logged_2) slave-master-bin.000001 # Table_map 6 # table_id: # (mysql.ndb_apply_status) slave-master-bin.000001 # Write_rows 6 # table_id: # slave-master-bin.000001 # Write_rows 6 # table_id: # flags: STMT_END_F slave-master-bin.000001 # Query 6 # COMMIT slave-master-bin.000001 # Query 6 # use `test`; drop table `test`.`bug_45756_slave_logged_2` slave-master-bin.000001 # Query 6 # use `test`; CREATE TABLE bug_45756_slave_logged_3 (a int) engine = NDB slave-master-bin.000001 # Query 6 # BEGIN slave-master-bin.000001 # Table_map 6 # table_id: # (test.bug_45756_slave_logged_3) slave-master-bin.000001 # Table_map 6 # table_id: # (mysql.ndb_apply_status) slave-master-bin.000001 # Write_rows 6 # table_id: # slave-master-bin.000001 # Write_rows 6 # table_id: # flags: STMT_END_F slave-master-bin.000001 # Query 6 # COMMIT slave-master-bin.000001 # Query 6 # use `test`; DROP TABLE `bug_45756_slave_logged_3` /* generated by server */ slave-master-bin.000001 # Query 1 # use `test`; CREATE TABLE bug45756_master_logged_1 (a int) engine = NDB slave-master-bin.000001 # Query 6 # BEGIN slave-master-bin.000001 # Table_map 6 # table_id: # (test.bug45756_master_logged_1) slave-master-bin.000001 # Table_map 6 # table_id: # (mysql.ndb_apply_status) slave-master-bin.000001 # Write_rows 6 # table_id: # slave-master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F slave-master-bin.000001 # Query 6 # COMMIT slave-master-bin.000001 # Query 1 # use `test`; DROP TABLE `bug45756_master_logged_1` /* generated by server */ slave-master-bin.000001 # Query 1 # use `test`; CREATE TABLE bug45756_master_logged_2 (a int) engine = NDB slave-master-bin.000001 # Query 6 # BEGIN slave-master-bin.000001 # Table_map 6 # table_id: # (test.bug45756_master_logged_2) slave-master-bin.000001 # Table_map 6 # table_id: # (mysql.ndb_apply_status) slave-master-bin.000001 # Write_rows 6 # table_id: # slave-master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F slave-master-bin.000001 # Query 6 # COMMIT slave-master-bin.000001 # Query 1 # use `test`; DROP TABLE `bug45756_master_logged_2` /* generated by server */ slave-master-bin.000001 # Query 1 # use `test`; CREATE TABLE bug45756_master_logged_3 (a int) engine = NDB slave-master-bin.000001 # Query 6 # BEGIN slave-master-bin.000001 # Table_map 6 # table_id: # (test.bug45756_master_logged_3) slave-master-bin.000001 # Table_map 6 # table_id: # (mysql.ndb_apply_status) slave-master-bin.000001 # Write_rows 6 # table_id: # slave-master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F slave-master-bin.000001 # Query 6 # COMMIT slave-master-bin.000001 # Query 1 # use `test`; DROP TABLE `bug45756_master_logged_3` /* generated by server */ select replace(right(txt, length(txt)-17), '\r', '') as binlog_entries from raw_binlog_rows where txt like '%server id%' and not (txt like '%Start%' or txt like '%Rotate%'); binlog_entries server id 6 Query server id 6 Query server id 6 Table_map: `test`.`bug_45756_slave_logged_1` server id 6 Table_map: `mysql`.`ndb_apply_status` server id 6 Write_rows: server id 6 Write_rows: flags: STMT_END_F server id 6 Query server id 6 Query server id 6 Query server id 6 Query server id 6 Table_map: `test`.`bug_45756_slave_logged_2` server id 6 Table_map: `mysql`.`ndb_apply_status` server id 6 Write_rows: server id 6 Write_rows: flags: STMT_END_F server id 6 Query server id 6 Query server id 6 Query server id 6 Query server id 6 Table_map: `test`.`bug_45756_slave_logged_3` server id 6 Table_map: `mysql`.`ndb_apply_status` server id 6 Write_rows: server id 6 Write_rows: flags: STMT_END_F server id 6 Query server id 6 Query server id 1 Query server id 6 Query server id 6 Table_map: `test`.`bug45756_master_logged_1` server id 6 Table_map: `mysql`.`ndb_apply_status` server id 6 Write_rows: server id 1 Write_rows: flags: STMT_END_F server id 6 Query server id 1 Query server id 1 Query server id 6 Query server id 6 Table_map: `test`.`bug45756_master_logged_2` server id 6 Table_map: `mysql`.`ndb_apply_status` server id 6 Write_rows: server id 1 Write_rows: flags: STMT_END_F server id 6 Query server id 1 Query server id 1 Query server id 6 Query server id 6 Table_map: `test`.`bug45756_master_logged_3` server id 6 Table_map: `mysql`.`ndb_apply_status` server id 6 Write_rows: server id 1 Write_rows: flags: STMT_END_F server id 6 Query server id 1 Query include/stop_slave.inc include/rpl_change_topology.inc [new topology=none]
Close
