Issues with TiCDC Real-Time Hot Synchronization

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

Original topic: TiCDC实时热同步问题

| username: TiDBer_QYr0vohO

[TiDB Usage Environment] Production Environment / Testing / PoC
Testing
[TiDB Version]
v7.1.0
[Reproduction Path] What operations were performed when the issue occurred
None
[Encountered Issue: Issue Phenomenon and Impact]
I would like to ask some questions:

  1. I want to use CDC to perform real-time hot synchronization on the data of a TiDB cluster and have created a new TiDB cluster. The normal operation is to use BR to restore the full backup data from the upstream to the new TiDB, and then use CDC to synchronize the incremental data. Is that correct?
  2. Should CDC be deployed first, and then execute the BR full backup?
    [Resource Configuration] Go to TiDB Dashboard - Cluster Information (Cluster Info) - Hosts, and take a screenshot of this page
    [Attachments: Screenshots/Logs/Monitoring]
| username: zhanggame1 | Original post link

For small data volumes, you can use dumpling+lightning for recovery, which is simpler. Recently, I used dumpling+lightning for backup and recovery, and dumpling can perform consistent backups.

  1. Before the backup, GC was turned off, and it was turned back on after completing CDC.
  2. CDC can be deployed either before or after, and synchronization can be started after the backup database is restored.

Reference:
Setting Up Primary-Secondary Cluster Replication | PingCAP Documentation Center

| username: porpoiselxj | Original post link

After the backup is completed, record the TSO. When creating a new CDC, you can specify the start-ts. Therefore, it doesn’t matter whether you create it before or after.

| username: TiDBer_QYr0vohO | Original post link

Okay, thank you.

| username: TiDBer_QYr0vohO | Original post link

Okay, thank you.

| username: system | Original post link

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