1 include/master-slave.inc
3 DROP DATABASE IF EXISTS replica;
4 CREATE DATABASE replica;
5 CREATE TABLE t1 (a INT NOT NULL KEY, b text NOT NULL)ENGINE=NDB;
6 CREATE TABLE t2 (a INT NOT NULL KEY, b text NOT NULL)ENGINE=NDB;
8 CREATE TABLE replica.t1 (a INT NOT NULL KEY, b text NOT NULL)ENGINE=NDB;
9 CREATE TABLE replica.t2 (a INT NOT NULL KEY, b text NOT NULL)ENGINE=NDB;
11 INSERT INTO t1 VALUES(1, repeat('abc',10));
12 INSERT INTO t2 VALUES(1, repeat('abc',10));
17 SELECT COUNT(*) FROM t1;
20 SELECT COUNT(*) FROM t2;
24 INSERT INTO replica.t1 VALUES(2, repeat('def',200));
25 INSERT INTO replica.t2 VALUES(2, repeat('def',200));
30 SELECT COUNT(*) FROM t1;
33 SELECT COUNT(*) FROM t2;
42 SELECT COUNT(*) FROM t2;
50 DROP DATABASE IF EXISTS replica;