Debian Codegraph @

mysql-test/suite/ndb_binlog/r/ndb_binlog_disable.result

raw
1 create table test.ndbt1 (a int primary key, b int) engine=ndb;
2 SET sql_log_bin = 0;
3 use test;
4 create table test.ndbt2 (a int primary key, b int) engine=ndb;
5 create table test.ndbt3 (a int primary key, b int) engine=ndb;
6 begin;
7 insert into ndbt1 values (1,1);
8 insert into ndbt2 values (1,1),(2,2);
9 insert into ndbt3 values (1,1);
10 commit;
11 SET sql_log_bin = 1;
12 begin;
13 insert into ndbt1 values (2,2);
14 insert into ndbt3 values (2,2);
15 commit;
16 Show + reset Binlog contents on Mysqld 1
17 We should se tables ndbt1 and ndbt3 added to Table_map,
18 but not table ndbt2
19 create table table_map_binlog_rows (table_map varchar(1000));
20 select * from table_map_binlog_rows order by table_map;
21 table_map
22 `mysql`.`ndb_apply_status`
23 `test`.`ndbt1`
24 `test`.`ndbt3`
25 drop table table_map_binlog_rows;
26 reset master;
27 Show + reset Binlog contents on Mysqld 2
28 We should se tables ndbt1 and ndbt3 added to Table_map,
29 but not table ndbt2
30 create table table_map_binlog_rows (table_map varchar(1000));
31 select * from table_map_binlog_rows order by table_map;
32 table_map
33 `mysql`.`ndb_apply_status`
34 `test`.`ndbt1`
35 `test`.`ndbt3`
36 drop table table_map_binlog_rows;
37 reset master;
38 drop table ndbt1;
39 drop table ndbt2;
40 drop table ndbt3;