1199 lines
54 KiB
Plaintext
1199 lines
54 KiB
Plaintext
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]
|