Flexible Table Specification for TiCDC Incremental Synchronization

Translated
1

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

Original topic: ticdc增量同步灵活指定表

| username: cf_data

[Test Environment for TiDB] Testing
[TiDB Version] V7.5.0
When configuring ticdc for incremental synchronization, can the downstream tables be flexibly specified, or can ticdc only automatically match the target database?
cdc cli changefeed create --server=http://10.0.10.25:8300 --sink-uri=“mysql://root:123456@127.0.0.1:3306/” --changefeed-id=“simple-replication-task”

1704434632422
1704434632422746×292 45.1 KB

It seems that the official examples and configuration files can only specify the source database and tables to be filtered. How should the target database and tables be specified?

2
| username: 小龙虾爱大龙虾 | Original post link

It should only do default matching and cannot perform upstream and downstream table mapping.

3
| username: 像风一样的男子 | Original post link

The target table cannot be specified and must have the same name as the upstream TiDB.

4
| username: cf_data | Original post link

Okay, thank you.

5
| username: dba远航 | Original post link

The functionality you need is supported by DM.

6
| username: FutureDB | Original post link

It seems that there is no corresponding configuration for the target database in TiCDC, but DM does have such related functions and configurations.

7
| username: Jellybean | Original post link

TiCDC currently only supports mirror synchronization and cannot specify the downstream target database table name. DM supports this feature, but DM is used for synchronizing from MySQL to TiDB.