TiCDC does not support updates, how can TiCDC support updates?

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

Original topic: ticdc不支持更新,怎么样才能才TICDC支持更新

| username: keyway

[TiDB Usage Environment] Production Environment / Testing / PoC
[TiDB Version]
[Reproduction Path] TIDB+DM+TICDC replicates data from MySQL database A to database B, while canal+kafka reads binlog data from database B.
[Encountered Issue: Problem Phenomenon and Impact]
ticdc does not support updates, update statements are converted to delete + insert
Querying at the tidb level, it is still an update statement

When it reaches ticdc, it is no longer an update
image

Such an update statement becomes 2 statements, doubling the data volume. How can TICDC support updates?

[Resource Configuration]
[Attachments: Screenshots/Logs/Monitoring]


| username: Running | Original post link

The underlying principles determine the output of TiCDC.

| username: xingzhenxiang | Original post link

I feel like this will increase the GC consumption of the receiving environment.

| username: neilshen | Original post link

Could you share the table structure and the UPDATE statement? Did you update the primary key?

| username: keyway | Original post link

Ordinary updates, any field is like this.

| username: system | Original post link

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