1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
|
create table test.t1(a int primary key) engine=ndb;
set global ndb_log_apply_status=Off;
show variables like '%ndb_log_apply_status%';
Variable_name Value
ndb_log_apply_status OFF
reset slave;
Warnings:
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
reset master;
Should have empty apply status table
select * from mysql.ndb_apply_status;
server_id epoch log_name start_pos end_pos
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);
commit;
Should not see ndb_apply_status updates in the Binlog
show binlog events;
select txt from binlog_stmts where txt like '%binlog.000001%' order by txt;
txt
set global ndb_log_apply_status=On;
show variables like '%ndb_log_apply_status%';
Variable_name Value
ndb_log_apply_status ON
reset slave;
Warnings:
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
reset master;
Should have empty apply status table
select * from mysql.ndb_apply_status;
server_id epoch log_name start_pos end_pos
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 (2);
commit;
Should see ndb_apply_status updates in the Binlog
show binlog events;
select txt from binlog_stmts where txt like '%binlog.000001%' order by txt;
txt
INSERT INTO `mysql`.`ndb_apply_status` SET @1=555 @2=12345 @3='binlog.000001' @4=20 @5=30
INSERT INTO `mysql`.`ndb_apply_status` SET @1=666 @2=67890 @3='binlog.000001' @4=50 @5=60
set global ndb_log_apply_status=Off;
drop table test.t1;
|
