【MySQL】多源复制多个主库有相同的表-复制到从库中一张相同的表

1.主库插入数据

--主库1插入数据 
insert into my_tab1 values (1,'xsq1');
"root@localhost">insert into my_tab1 values (1,'xsq1');
Query OK, 1 row affected (0.00 sec)
"root@localhost">select * from my_tab1;
+------+------+
| id   | name |
+------+------+
|    1 | xsq1 |
+------+------+
1 row in set (0.00 sec)

--主库2插入数据 
insert into my_tab1 values (2,'xsq2');
"root@localhost">insert into my_tab1 values (2,'xsq2');
Query OK, 1 row affected (0.00 sec)

"root@localhost">select * from my_tab1;
+------+------+
| id   | name |
+------+------+
|    2 | xsq2 |
+------+------+
1 row in set (0.00 sec)

2.从库检查 

"root@localhost">select * from my_tab1;
+------+------+
| id   | name |
+------+------+
|    1 | xsq1 |
|    2 | xsq2 |
+------+------+
2 rows in set (0.00 sec)

3.总结 

如果有多个库中有相同的表，需要将这相同的表复制到同一个从库中同一个表中，
那么多源复制将是很好的方案。