# # This tests checks the operation of binlog-do-db , replicate-wild-do-table # --source include/galera_cluster.inc --source include/have_innodb.inc --connection node_1 CREATE DATABASE db1; CREATE DATABASE db2; CREATE TABLE db1.t1 (f1 INTEGER) ENGINE=InnoDB; CREATE TABLE db2.t2A (f1 INTEGER) ENGINE=InnoDB; CREATE TABLE db2.t2B (f1 INTEGER) ENGINE=InnoDB; INSERT INTO db1.t1 VALUES (1); INSERT INTO db2.t2A VALUES (2); INSERT INTO db2.t2B VALUES (3); --connection node_2 SELECT COUNT(*) = 0 FROM db1.t1; SELECT COUNT(*) = 0 FROM db2.t2A; SELECT COUNT(*) = 1 FROM db2.t2B; --connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3 --connection node_3 SELECT COUNT(*) = 0 FROM db1.t1; SELECT COUNT(*) = 1 FROM db2.t2A; SELECT COUNT(*) = 1 FROM db2.t2B; --connection node_1 DROP SCHEMA db1; DROP SCHEMA db2;