How to specify the target database name and table name in TiCDC

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

Original topic: ticdc如何指定目标库名,表名

| username: 消息终结者

How to specify the target database name and table name in ticdc?

| username: TiDBer_CQ | Original post link

Control which databases and tables need to be synchronized or not synchronized through configuration rules.

| username: 消息终结者 | Original post link

What if I want to synchronize to a different database table than the upstream? For example, the upstream is test.table, and the corresponding downstream table is test2.table2.

| username: come_true | Original post link

The table subcommand has two options, --db and --table, which are used to specify the database name and table name, respectively.

| username: TiDBer_CQ | Original post link

I haven’t directly connected two inconsistent upstream and downstream tables through TiCDC, but I would add a message queue in the middle to map the different upstream and downstream tables.

| username: 消息终结者 | Original post link

Is there a complete command or a documentation link?

| username: 消息终结者 | Original post link

We want to directly synchronize the MySQL database without using MQ.

| username: xingzhenxiang | Original post link

TiCDC can directly synchronize to MySQL

| username: h5n1 | Original post link

TiCDC currently does not have the capability to specify different downstream tables.

| username: 消息终结者 | Original post link

Setting it this way doesn’t take effect.

| username: come_true | Original post link

Take a look at this link: TiDB Maintenance Documentation (Part 2) - Mo Tian Lun (modb.pro)

| username: system | Original post link

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