How to configure the DM configuration file to filter multiple table prefix matches?

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: DM 如果过滤多种表前缀匹配，配置文件要怎么配置？

| username: TiDBer_mvrpvfaN

Black and white list global configuration, each instance references the configuration item name through the configuration.

block-allow-list: # If the DM version is earlier than v2.0.0-beta.2, use black-white-list.
global:
do-dbs: [“syncdb”]
ignore-tables: # Whitelist of upstream tables that need to be migrated.
- db-name: “syncdb” # The name of the database where the table to be migrated is located.
tbl-name: “~^test_ss*” # The name of the table to be migrated.

As above, I have already filtered the tables starting with test_ss. I also want to filter the tables starting with bak_. How do I configure it in the configuration file? Do I just add another line with tbl-name: “~^bak*”?

2
| username: Kongdom | Original post link

The example shows that multiple configurations are possible.

3
| username: buchuitoudegou | Original post link

Please note that if you have already set do-dbs or do-tables in a certain rule, the subsequent ignore-dbs and ignore-tables may not take effect. You can refer to the rules given in this post: 同一个source，多个block-allow-list时怎么配置 - #12，来自 buchuitoudegou - TiDB 的问答社区

4
| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.