name: “ailearn-test”
task-mode: “all”
shard-mode: “pessimistic”
meta-schema: “dm_meta” # 将在下游数据库创建 schema 用于存放元数据
ignore-checking-items: [“auto_increment_ID”] # 本示例中上游存在自增主键，因此需要忽略掉
target-database:
host: “10.10.100.14”
port: 4000
user: “dm_worker”
password: “QInjI6TsmA+POyB7yKhauEAAqAx336rCMMgmzw==”
mysql-instances:
- source-id: “mysql-ailearn-test”
route-rules:
[
“route-rule-03”,
“route-rule-10”,
]
block-allow-list: “listA”
routes:
route-rule-03:
schema-pattern: “ailearn”
table-pattern: “global_id”
target-schema: “ailearn_test”
target-table: “global_id”
route-rule-10:
schema-pattern: “ailearn”
table-pattern: “intell_third_poll_data”
target-schema: “ailearn_test”
target-table: “intell_third_poll_data”
block-allow-list:
listA:
do-tables:
- db-name: “ailearn”
tbl-name: “global_id”
- db-name: “ailearn”
tbl-name: “intell_third_poll_data”