403Webshell
Server IP : 104.21.38.3  /  Your IP : 172.70.92.242
Web Server : Apache
System : Linux krdc-ubuntu-s-2vcpu-4gb-amd-blr1-01.localdomain 5.15.0-142-generic #152-Ubuntu SMP Mon May 19 10:54:31 UTC 2025 x86_64
User : www ( 1000)
PHP Version : 7.4.33
Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : OFF  |  Sudo : ON  |  Pkexec : ON
Directory :  /www/server/mysql/src/mysql-test/suite/ndb_rpl/r/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ Back ]     

Current File : /www/server/mysql/src/mysql-test/suite/ndb_rpl/r/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]

Youez - 2016 - github.com/yon3zu
LinuXploit