When merging and synchronizing MySQL sharded tables to TiDB, the DM tool fails to filter delete operations

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

Original topic: mysql分库分表合并同步到tidb时,dm工具过滤delete失效

| username: TiDBer_YP3mRzmB

[TiDB Usage Environment] Production Environment / Testing / PoC
[TiDB Version]
v6.1.0
[Reproduction Path] Operations performed that led to the issue
[Encountered Issue: Problem Phenomenon and Impact]
When merging and synchronizing sharded tables to TiDB, it is necessary to filter out delete operations from the source. The current configuration is ineffective, and data in the downstream TiDB is also being deleted. DM version v6.2.0
[Resource Configuration]

[Attachments: Screenshots/Logs/Monitoring]


| username: Meditator | Original post link

  1. Check if there are any anomalies in the DM logs.
  2. Remember that the database name (schema-pattern) and table name (table-pattern) have wildcard requirements, and support *?
  3. If using ~, try quoting with double quotes?

image
Refer here: