Differences between TiDB Binlog and TiCDC, and how to choose

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

Original topic: TiDB binlog与ticdc区别,如何选择

| username: 路在何chu

【TiDB Usage Environment】Production Environment
TiDB synchronizing to MySQL
【TiDB Version】
6.5

| username: Fly-bird | Original post link

Prioritize choosing TiCDC.

| username: zhanggame1 | Original post link

Choose TiCDC, the binlog of version 6.5 can no longer fully support all TiDB operations.

| username: tidb菜鸟一只 | Original post link

Must use TiCDC.

| username: Kongdom | Original post link

The official recommendation is to use TiCDC instead of binlog.

TiDB Binlog is incompatible with some features introduced in TiDB v5.0 and cannot be used together. For details, refer to Precautions. It is recommended to use TiCDC instead of TiDB Binlog.

| username: Soysauce520 | Original post link

If there are no large transactions, use binlog; if there are large transactions, use TiCDC.

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

The official recommendation for CDC in version 6.5

| username: ShawnYan | Original post link

It depends on the scenario you are using it for. If you just want to capture and parse binlogs like MySQL, then you need to use TiDB Binlog.

| username: 路在何chu | Original post link

You can directly use CDC, analyze binlog, and directly downstream to MySQL.

| username: zhimadi | Original post link

For higher versions, use TiCDC instead of binlog.

| username: ajin0514 | Original post link

Try using a higher version of TiCDC.

| username: TiDBer_vfJBUcxl | Original post link

Choose TiCDC

| username: 普罗米修斯 | Original post link

When our cluster was using a lower version, we used binlog for incremental synchronization, which did not support TiCDC. Now that we have upgraded to a higher version, we are using TiCDC.

| username: Hacker007 | Original post link

Choose CDC. Can TiDB Binlog be parsed by MySQL?

| username: Z六月星星 | Original post link

TiCDC

| username: 大飞哥online | Original post link

ticdc is reliable.

| username: Kongdom | Original post link

:thinking: There is a small issue here: TiCDC can only synchronize with the same database name.

| username: ajin0514 | Original post link

CDC performance is better.