Gecko [ www.jdcpatala.org ]

Name	Size	Permission
ndb_dist_priv_common.result	2.33 KB	-rw-r--r--
ndb_rpl_2innodb.result	41.34 KB	-rw-r--r--
ndb_rpl_2myisam.result	41.34 KB	-rw-r--r--
ndb_rpl_2ndb.result	16.17 KB	-rw-r--r--
ndb_rpl_2other.result	32.71 KB	-rw-r--r--
ndb_rpl_add_column.result	5.99 KB	-rw-r--r--
ndb_rpl_apply_status.result	907 B	-rw-r--r--
ndb_rpl_auto_inc.result	3.72 KB	-rw-r--r--
ndb_rpl_bank.result	10.82 KB	-rw-r--r--
ndb_rpl_basic.result	13.52 KB	-rw-r--r--
ndb_rpl_batch.result	2.48 KB	-rw-r--r--
ndb_rpl_batch_handling.result	1.91 KB	-rw-r--r--
ndb_rpl_binlog_format_errors.r...	1.27 KB	-rw-r--r--
ndb_rpl_bitfield.result	14.48 KB	-rw-r--r--
ndb_rpl_blob.result	7.29 KB	-rw-r--r--
ndb_rpl_break_3_chain.result	3.17 KB	-rw-r--r--
ndb_rpl_bug22045.result	2.56 KB	-rw-r--r--
ndb_rpl_bug_13440282.result	2.3 KB	-rw-r--r--
ndb_rpl_check_for_mixed.result	483 B	-rw-r--r--
ndb_rpl_checksum.result	6.31 KB	-rw-r--r--
ndb_rpl_circular.result	5.13 KB	-rw-r--r--
ndb_rpl_circular_2ch.result	2.27 KB	-rw-r--r--
ndb_rpl_circular_2ch_rep_statu...	7.47 KB	-rw-r--r--
ndb_rpl_circular_simplex.resul...	1.28 KB	-rw-r--r--
ndb_rpl_conflict_basic.result	18.2 KB	-rw-r--r--
ndb_rpl_conflict_epoch.result	71.03 KB	-rw-r--r--
ndb_rpl_conflict_epoch2.result	143.62 KB	-rw-r--r--
ndb_rpl_conflict_epoch2_extra....	63.18 KB	-rw-r--r--
ndb_rpl_conflict_epoch2_trans....	47.12 KB	-rw-r--r--
ndb_rpl_conflict_epoch_ext.res...	106.6 KB	-rw-r--r--
ndb_rpl_conflict_epoch_extende...	13.51 KB	-rw-r--r--
ndb_rpl_conflict_epoch_trans.r...	23.13 KB	-rw-r--r--
ndb_rpl_conflict_epoch_trans_e...	23.62 KB	-rw-r--r--
ndb_rpl_conflict_max.result	36.46 KB	-rw-r--r--
ndb_rpl_conflict_max_delete_wi...	35.68 KB	-rw-r--r--
ndb_rpl_conflict_old.result	36.65 KB	-rw-r--r--
ndb_rpl_conflict_read_tracking...	29.94 KB	-rw-r--r--
ndb_rpl_ctype_ucs2_def.result	703 B	-rw-r--r--
ndb_rpl_dd_advance.result	8.9 KB	-rw-r--r--
ndb_rpl_dd_basic.result	2.4 KB	-rw-r--r--
ndb_rpl_dd_partitions.result	35.75 KB	-rw-r--r--
ndb_rpl_ddl_open_trans.result	1.87 KB	-rw-r--r--
ndb_rpl_dist_priv.result	11.31 KB	-rw-r--r--
ndb_rpl_do_db.result	1.44 KB	-rw-r--r--
ndb_rpl_do_table.result	1.13 KB	-rw-r--r--
ndb_rpl_empty_epoch.result	1.17 KB	-rw-r--r--
ndb_rpl_gap_event.result	1.38 KB	-rw-r--r--
ndb_rpl_idempotent.result	3.06 KB	-rw-r--r--
ndb_rpl_ignore_db.result	1.08 KB	-rw-r--r--
ndb_rpl_init_rep_status.result	2.17 KB	-rw-r--r--
ndb_rpl_innodb2ndb.result	41 KB	-rw-r--r--
ndb_rpl_innodb_trans.result	3.08 KB	-rw-r--r--
ndb_rpl_last_conflict_epoch_va...	2.06 KB	-rw-r--r--
ndb_rpl_load.result	1.27 KB	-rw-r--r--
ndb_rpl_logging.result	2.66 KB	-rw-r--r--
ndb_rpl_mix_eng_trans.result	10.51 KB	-rw-r--r--
ndb_rpl_mix_innodb.result	4.35 KB	-rw-r--r--
ndb_rpl_mixed_tables.result	7.28 KB	-rw-r--r--
ndb_rpl_multi.result	2.33 KB	-rw-r--r--
ndb_rpl_myisam2ndb.result	41 KB	-rw-r--r--
ndb_rpl_ndbapi-examples.result	522 B	-rw-r--r--
ndb_rpl_rep_error.result	16.79 KB	-rw-r--r--
ndb_rpl_rep_ignore.result	1.4 KB	-rw-r--r--
ndb_rpl_skip_gap_event.result	1.27 KB	-rw-r--r--
ndb_rpl_slave_binlog_index.res...	1.83 KB	-rw-r--r--
ndb_rpl_slave_conflict_role_va...	9.63 KB	-rw-r--r--
ndb_rpl_slave_lsu.result	53.8 KB	-rw-r--r--
ndb_rpl_slave_lsu_anyval.resul...	54.73 KB	-rw-r--r--
ndb_rpl_slave_replay.result	6.42 KB	-rw-r--r--
ndb_rpl_slave_restart.result	1.93 KB	-rw-r--r--
ndb_rpl_stm_innodb.result	4.38 KB	-rw-r--r--
ndb_rpl_sync.result	2.38 KB	-rw-r--r--
ndb_rpl_ui.result	1.86 KB	-rw-r--r--
ndb_rpl_ui2.result	813 B	-rw-r--r--
ndb_rpl_ui3.result	1.22 KB	-rw-r--r--
rpl_truncate_7ndb.result	3.27 KB	-rw-r--r--
rpl_truncate_7ndb_2.result	3.27 KB	-rw-r--r--

Code Editor : ndb_rpl_circular.result

include/rpl_init.inc [topology=1->2->1]
Warnings:
Note	####	Sending passwords in plain text without SSL/TLS is extremely insecure.
Note	####	Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
Warnings:
Note	####	Sending passwords in plain text without SSL/TLS is extremely insecure.
Note	####	Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
include/rpl_connect.inc [creating master]
include/rpl_connect.inc [creating slave]
CREATE TABLE t1 (a int key, b int) ENGINE=ndb;
SHOW TABLES;
Tables_in_test
t1
INSERT INTO t1 VALUES (1,2);
INSERT INTO t1 VALUES (2,3);
SELECT * FROM t1 ORDER BY a;
a	b
1	2
2	3
include/check_slave_no_error.inc
include/check_slave_is_running.inc
Slave Binlog contains all ops as log_slave_updates is on
show variables like 'server_id';
Variable_name	Value
server_id	2
show variables like 'log_bin';
Variable_name	Value
log_bin	ON
show variables like 'log_slave_updates';
Variable_name	Value
log_slave_updates	ON
include/show_binlog_events.inc
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000001	#	Query	#	#	use `test`; CREATE TABLE t1 (a int key, b int) ENGINE=ndb
slave-bin.000001	#	Query	#	#	BEGIN
slave-bin.000001	#	Table_map	#	#	table_id: # (test.t1)
slave-bin.000001	#	Table_map	#	#	table_id: # (mysql.ndb_apply_status)
slave-bin.000001	#	Write_rows	#	#	table_id: #
slave-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
slave-bin.000001	#	Query	#	#	COMMIT
slave-bin.000001	#	Query	#	#	BEGIN
slave-bin.000001	#	Table_map	#	#	table_id: # (test.t1)
slave-bin.000001	#	Table_map	#	#	table_id: # (mysql.ndb_apply_status)
slave-bin.000001	#	Write_rows	#	#	table_id: #
slave-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
slave-bin.000001	#	Query	#	#	COMMIT
include/check_slave_is_running.inc
SELECT * FROM t1 ORDER BY a;
a	b
1	2
2	3
include/check_slave_is_running.inc
Master Binlog contains only Master ops as log_slave_updates is off
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	#	#	BEGIN
master-bin.000001	#	Table_map	#	#	table_id: # (test.t1)
master-bin.000001	#	Table_map	#	#	table_id: # (mysql.ndb_apply_status)
master-bin.000001	#	Write_rows	#	#	table_id: #
master-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	#	#	COMMIT
STOP SLAVE;
DROP TABLE t1;
start slave;
create table t1 (a int primary key, b int) engine=ndb;
show variables like '%log_orig%';
Variable_name	Value
ndb_log_orig	ON
'Master' has only slave's serverid entry 
select server_id, log_name from mysql.ndb_apply_status order by server_id;
server_id	log_name
2	slave-bin.000001
set global ndb_log_apply_status=On;
show variables like 'ndb_log_apply_status';
Variable_name	Value
ndb_log_apply_status	ON
'Slave' has only Master's serverid entry
select server_id, log_name from mysql.ndb_apply_status order by server_id;
server_id	log_name
1	master-bin.000001
'Slave' has following ndb_binlog_index entries
select inserts, updates, deletes, schemaops, orig_server_id from mysql.ndb_binlog_index order by position;
inserts	updates	deletes	schemaops	orig_server_id
1	0	0	0	1
1	0	0	0	2
set global ndb_log_apply_status=On;
show variables like 'ndb_log_apply_status';
Variable_name	Value
ndb_log_apply_status	ON
stop slave;
insert into t1 values (1,1);
'Slave' still has only Master's serverid entry
select server_id, log_name from mysql.ndb_apply_status order by server_id;
server_id	log_name
1	master-bin.000001
'Slave' has following ndb_binlog_index entries
select inserts, updates, deletes, schemaops, orig_server_id from mysql.ndb_binlog_index order by position;
inserts	updates	deletes	schemaops	orig_server_id
1	0	0	0	1
1	0	0	0	2
0	0	0	0	2
1	0	0	0	1
'Master' still has only Slave's serverid entry
select server_id, log_name from mysql.ndb_apply_status order by server_id;
server_id	log_name
2	slave-bin.000001
start slave;
'Master' now has own serverid entry as well.
select server_id, log_name from mysql.ndb_apply_status order by server_id;
server_id	log_name
1	master-bin.000001
2	slave-bin.000001
'Slave' still only has 'Master''s serverid entry
select server_id, log_name from mysql.ndb_apply_status order by server_id;
server_id	log_name
1	master-bin.000001
Now create event originating at Slave
insert into t1 values (2,2);
'Slave' now also has its own serverid entry
select server_id, log_name from mysql.ndb_apply_status order by server_id;
server_id	log_name
1	master-bin.000001
2	slave-bin.000001
stop slave;
set global ndb_log_apply_status=off;
set global ndb_log_apply_status=off;
stop slave;
drop table t1;
drop table t1;
include/rpl_end.inc

${this.title}

Code Editor : ndb_rpl_circular.result