Debian Codegraph @

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

raw
1 ###########################################################
2 # Author: Jeb
3 # Date: 15-12-2006
4 # Purpose: To test --replicate-ignore-table=db_name.tbl_name
5 # and --replicate-ignore-db=db_name
6 # using cluster. Only replica should replicate.
7 ##########################################################
8
9 --source include/have_ndb.inc
10 --source suite/ndb_rpl/ndb_master-slave.inc
11
12 --disable_warnings
13 DROP DATABASE IF EXISTS replica;
14 --enable_warnings
15
16 # Create database and tables for the test.
17 CREATE DATABASE replica;
18 CREATE TABLE t1 (a INT NOT NULL KEY, b text NOT NULL)ENGINE=NDB;
19 CREATE TABLE t2 (a INT NOT NULL KEY, b text NOT NULL)ENGINE=NDB;
20 USE replica;
21 CREATE TABLE replica.t1 (a INT NOT NULL KEY, b text NOT NULL)ENGINE=NDB;
22 CREATE TABLE replica.t2 (a INT NOT NULL KEY, b text NOT NULL)ENGINE=NDB;
23
24 # Insert data into db that should not be picked up by slave
25 USE test;
26 INSERT INTO t1 VALUES(1, repeat('abc',10));
27 INSERT INTO t2 VALUES(1, repeat('abc',10));
28 SHOW TABLES;
29 SELECT COUNT(*) FROM t1;
30 SELECT COUNT(*) FROM t2;
31
32 # Insert data into db that should be replicated
33 USE replica;
34 INSERT INTO replica.t1 VALUES(2, repeat('def',200));
35 INSERT INTO replica.t2 VALUES(2, repeat('def',200));
36 SHOW TABLES;
37 SELECT COUNT(*) FROM t1;
38 SELECT COUNT(*) FROM t2;
39
40 # Check results on slave
41 --sync_slave_with_master
42 SHOW TABLES;
43 USE replica;
44 SHOW TABLES;
45 #SELECT COUNT(*) FROM t1;
46 SELECT COUNT(*) FROM t2;
47 USE test;
48 SHOW TABLES;
49
50 # Cleanup from testing
51 connection master;
52 USE test;
53 DROP TABLE t1, t2;
54 DROP DATABASE IF EXISTS replica;
55 --sync_slave_with_master
56
57 # End 5.1 test case
58 --source include/rpl_end.inc