测试示例01-创建过滤链路之最佳实践亲试ok
#各个从节点创建过滤链路 replication filter 分别指定源库 和目标库
Slave-112如下操作：
mysql> stop slave;
Query OK, 0 rows affected (0.11 sec)
mysql> change replication filter replicate_rewrite_db=((imooc_db,order_db));
Query OK, 0 rows affected (0.00 sec)
mysql> start slave;
Query OK, 0 rows affected (0.09 sec)
Slave-113如下操作：
mysql> stop slave;
Query OK, 0 rows affected (0.19 sec)
mysql> change replication filter replicate_rewrite_db=((imooc_db,product_db));
Query OK, 0 rows affected (0.30 sec)
mysql> start slave;
Query OK, 0 rows affected (0.10 sec)
Slave-114如下操作
mysql> stop slave;
Query OK, 0 rows affected (0.19 sec)
mysql> change replication filter replicate_rewrite_db=((imooc_db,customer_db));
Query OK, 0 rows affected (0.00 sec)
mysql> start slave;
Query OK, 0 rows affected (0.17 sec)
Master-111更新数据，观察slave节点的数据是否变更
MySQL [imooc_db]> update region_info set region_name='中国(China)' where region_id=1;
Query OK, 1 row affected (0.34 sec)
Rows matched: 1 Changed: 1 Warnings: 0
MySQL [imooc_db]> commit;
Query OK, 0 rows affected (0.04 sec)
MySQL [imooc_db]> select * from region_info limit 2;
+-----------+-----------+---------------+--------------+
| region_id | parent_id | region_name | region_level |
+-----------+-----------+---------------+--------------+
| 1 | 0 | 中国(China) | 0 |
| 2 | 1 | 北京市 | 1 |
+-----------+-----------+---------------+--------------+
2 rows in set (0.00 sec)
Slave-112
.png)
Slave-113
Slave-114
符合预期，复制链路没问题
创建时间：2021-09-26 17:18
넶浏览量：0
