mysql-instances:
-
source-id: "mysql-replica-02"
route-rules: ["store-route-rule"]
filter-rules: ["store-filter-rule", "sale-filter-rule"]
block-allow-list: "bw-rule-1"
mydumper-config-name: "global"
loader-config-name: "global"
syncer-config-name: "global"
-
source-id: "mysql-replica-05"
route-rules: ["store-route-rule"]
filter-rules: ["store-filter-rule", "sale-filter-rule"]
block-allow-list: "bw-rule-1"
mydumper-config-name: "global"
loader-config-name: "global"
syncer-config-name: "global"
filters:
sale-filter-rule:
schema-pattern: "db0*"
table-pattern: "t_*"
events: ["truncate table", "drop table"]
action: Ignore
store-filter-rule:
schema-pattern: "db0*"
events: ["drop database"]
action: Ignore
block-allow-list:
bw-rule-1:
do-dbs: ["db01","db02"]
do-tables:
- db-name: "~.*"
tbl-name: "~(table01|table02)"
ignore-tables:
- db-name: "~.*"
tbl-name: "table03"
bw-rule-2:
ignore-tables:
- db-name: "~.*"
tbl-name: "~(table04|table05)"
问题1、bw-rule-2定义完后,写在哪里,是 block-allow-list: [“bw-rule-1”, “bw-rule-2”] 这样写入呢?还是…?
问题2、bw-rule-1里有do-tables和ignore-tables,是不是有do-tables,ignore-tables就不生效?
问题3、多张表是不是 tbl-name: “~(table04|table05)” 这样写,确定这样写没有问题?
问题4、~ 和 ^ 正则代表什么?
大神们回答一下,谢谢!!!