How to use mydumper for incremental backups when currently using mydumper for full backups of the TiDB cluster?

Translated
1

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

Original topic: 目前使用mydumper给tidb集群做全量备份，怎么实现用mydumper做增量备份？

| username: Hacker_CsHliJiW

【TiDB Usage Environment】Production\Test Environment\POC
【TiDB Version】V5.3.0
【Problem Encountered】Currently using mydumper for daily full backups of the TiDB cluster, I want to see if it is possible to perform scheduled incremental backups using mydumper. The version information of mydumper is as follows:
mydumper 0.9.5 (ba3946edc087e87bba7cb2728bc2407f6dbd0a8b), built against MySQL 5.7.24
【Reproduction Path】Operations performed that led to the issue
【Problem Phenomenon and Impact】

If the question is related to performance optimization or troubleshooting, please download the script and run it. Please select all and copy-paste the terminal output results for upload.

2
| username: Hacker_CsHliJiW | Original post link

I want to keep a backup of TiDB in SQL format, making it convenient to restore to TiDB or MySQL clusters.

3
| username: 啦啦啦啦啦 | Original post link

Logical backups do not support incremental backups; they can only be combined with binlogs to achieve incremental backups.

4
| username: xiaohetao | Original post link

If you must perform incremental backups, you can use BR.

5
| username: ShawnYan | Original post link

You can use BR for incremental backups, but it is still an experimental feature in v5.3.

6
| username: OnTheRoad | Original post link

Logical backups cannot perform incremental backups. If incremental backups are needed, you can consider using BR backup, but it is an experimental feature.

7
| username: Hacker_CsHliJiW | Original post link

Thank you all for your replies. We have decided to use binlog for incremental backups.

8
| username: Hacker_CsHliJiW | Original post link

Currently using pump and drainer to synchronize binlog to a file. The drainer log shows that the save point was successful, but the binlog file is always empty.

image
image1150×798 414 KB

image
image811×148 29.1 KB

The pump generates normally.
image

9
| username: system | Original post link

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