Debian Codegraph @

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

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