DM配置规则名称怎么配置两个

舞动梦灵 · 2024 年4 月 24 日 06:04

舞动梦灵:

mysql-instances:

source-id: “test1”
block-allow-list: “bw-rule-1”,“bw-rule-2”
filter-rules: [“filter1”,“filter2”]
meta:
binlog-name: “mysql-db40-bin.000080”
binlog-pos: 423320383
block-allow-list:
bw-rule-1:
do-dbs: [“db_name1”]
do-tables:

db-name: “"
tbl-name: "”
bw-rule-2:
do-dbs: [“db_name2”]
do-tables:

db-name: “"
tbl-name: "”
filters:
filter1:
schema-pattern: “db_name1”
events: [“drop database”,“truncate table”, “drop table”,“delete”,“create index”,“drop index”]
sql-pattern: [“^CREATE\s+DEFINER”,“^DROP\s+EVENT”]
action: Ignore
filter2:
schema-pattern: “db_name2”
events: [“drop database”,“truncate table”, “drop table”,“delete”,“create index”,“drop index”]
action: Ignore

我没搞过这么分的这么细的，我只搞一个规则全部库通用，如果这个不行的话，那就就用同一个数据源写两个souce-id，
mysql-instances:

source-id: “test1”
block-allow-list: “bw-rule-1”
filter-rules: [“filter1”]
source-id: “test1”
block-allow-list: “bw-rule-2”
filter-rules: [“filter2”]

或者同一个IP地址写两个数据源
mysql-instances:

source-id: “test1”
block-allow-list: “bw-rule-1”
filter-rules: [“filter1”]
source-id: “test2”
block-allow-list: “bw-rule-2”
filter-rules: [“filter2”]

你可以都试试呀，一个数据源多个白名单这个没测试过，后面两个肯定是可以用的，哪个用着顺手用哪个。