Debian Codegraph @

mysql-test/suite/ndb_rpl/t/ndb_rpl_ignore_db.test

raw
1 --source include/have_ndb.inc
2 --source include/have_binlog_format_mixed_or_row.inc
3 --source suite/ndb_rpl/ndb_master-slave.inc
4
5 # We are not binlogging changes to the mysql db. Check
6 # that changes to tables in the mysql db are not replicated
7 # but ndb_apply_status events are
8
9 --connection slave
10 delete from mysql.ndb_apply_status;
11
12 --connection master
13 use mysql;
14 create table t1 (a int primary key, b int) engine=myisam;
15 create table t2 (a int primary key, b int) engine=ndb;
16
17 insert into t1 values (1,1), (2,2);
18 insert into t2 values (1,1), (2,2);
19
20 delete from t1;
21 delete from t2;
22
23 use test;
24 create table t3 (a int primary key, b int) engine=ndb;
25 insert into t3 values (1,1), (2,2);
26
27 --sync_slave_with_master slave
28 --connection slave
29
30 select count(1) from information_schema.tables where table_schema="mysql" and (table_name = "t1" or table_name="t2");
31
32 use test;
33 select * from t3 order by a;
34
35 select count(1) from mysql.ndb_apply_status;
36
37 --connection master
38 use mysql;
39 drop table t1;
40 drop table t2;
41
42 use test;
43 drop table t3;
44
45 --sync_slave_with_master slave
46
47 --source include/rpl_end.inc