· 9 years ago · Nov 24, 2016, 11:32 AM
1DROP TABLE IF EXISTS `master`.t1;
2CREATE TABLE `master`.t1 (
3 id INT(20) NOT NULL AUTO_INCREMENT,
4 name VARCHAR(32) NOT NULL,
5 PRIMARY KEY(id)
6);
7
8DROP TABLE IF EXISTS `slave`.t1;
9CREATE TABLE `slave`.t1 (
10 id INT(20) NOT NULL AUTO_INCREMENT,
11 name VARCHAR(32) NOT NULL,
12 PRIMARY KEY(id)
13)
14ENGINE=FEDERATED
15CONNECTION='mysql://root:password@localhost:3306/master/t1';
16
17INSERT INTO `master`.t1 (name) VALUE ('alex');
18
19SELECT * FROM `master`.t1;
20SELECT * FROM `slave`.t1;