-- source include/have_ndb.inc -- source include/have_binlog_format_mixed_or_row.inc create table test.t1(a int primary key) engine=ndb; set global ndb_log_apply_status=Off; show variables like '%ndb_log_apply_status%'; reset slave; reset master; --echo Should have empty apply status table select * from mysql.ndb_apply_status; --echo Dummy incoming ndb_apply_status updates, should not be logged begin; insert into mysql.ndb_apply_status values (555, 12345, 'binlog.000001', 20, 30); insert into mysql.ndb_apply_status values (666, 67890, 'binlog.000001', 50, 60); replace into test.t1 values (1); # So that epoch is non-empty commit; --echo Should not see ndb_apply_status updates in the Binlog # Synchronise with Binlog --disable_result_log show binlog events; --enable_result_log let $Binlog_condition= like '%binlog.000001%'; --source suite/ndb_binlog/t/ndb_binlog_get_binlog_stmts_basic.inc set global ndb_log_apply_status=On; show variables like '%ndb_log_apply_status%'; reset slave; reset master; --echo Should have empty apply status table select * from mysql.ndb_apply_status; --echo Dummy incoming ndb_apply_status updates, should be logged begin; insert into mysql.ndb_apply_status values (555, 12345, 'binlog.000001', 20, 30); insert into mysql.ndb_apply_status values (666, 67890, 'binlog.000001', 50, 60); replace into test.t1 values (1); # So that epoch is non-empty commit; --echo Should see ndb_apply_status updates in the Binlog # Synchronise with Binlog --disable_result_log show binlog events; --enable_result_log let $Binlog_condition= like '%binlog.000001%'; --source suite/ndb_binlog/t/ndb_binlog_get_binlog_stmts_basic.inc set global ndb_log_apply_status=Off; drop table test.t1;
Name | Type | Size | Permission | Actions |
---|---|---|---|---|
ndb_binlog_basic.test | File | 2.23 KB | 0644 |
|
ndb_binlog_ddl_multi.test | File | 3.7 KB | 0644 |
|
ndb_binlog_discover.test | File | 1.11 KB | 0644 |
|
ndb_binlog_format.test | File | 1.16 KB | 0644 |
|
ndb_binlog_get_binlog_stmts.inc | File | 122 B | 0644 |
|
ndb_binlog_get_binlog_stmts_basic.inc | File | 2.91 KB | 0644 |
|
ndb_binlog_ignore_db-master.opt | File | 53 B | 0644 |
|
ndb_binlog_ignore_db.test | File | 2.17 KB | 0644 |
|
ndb_binlog_log_apply_status.test | File | 1.68 KB | 0644 |
|
ndb_binlog_log_bin.test | File | 1.33 KB | 0644 |
|
ndb_binlog_multi.test | File | 3.23 KB | 0644 |
|
ndb_binlog_restore.test | File | 4.96 KB | 0644 |
|
ndb_binlog_unique_epoch.cnf | File | 164 B | 0644 |
|
ndb_binlog_unique_epoch.test | File | 3.66 KB | 0644 |
|
ndb_binlog_variants.cnf | File | 999 B | 0644 |
|
ndb_binlog_variants.test | File | 6.11 KB | 0644 |
|