1.开启federated存储引擎
https://blog.csdn.net/zh15732621679/article/details/79387510
2.创建映射表
首先在Master机器上建立projects表,我们只需要将每个agent数据库中建立映射表projects
CREATE TABLE `projects` (
`project_id` INT(11) NOT NULL AUTO_INCREMENT,
`project_code` VARCHAR(50) NOT NULL,
`test_code` VARCHAR(50) NOT NULL,
`create_time` BIGINT(11) NULL DEFAULT NULL,
`result` VARCHAR(255) NULL DEFAULT NULL,
`ts` BIGINT(11) NOT NULL,
PRIMARY KEY (`id`)
)
COLLATE='utf8_general_ci'
ENGINE=FEDERATED
CONNECTION='mysql://user:password@202.59.232.211:3306/testdb/tb_projects_tests';