Is TiDB backup using XtraBackup failing? Is it unsupported?

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

Original topic: tidb使用xtrabackup备份失败,是不支持吗

| username: TiDBer_jg5p7Njn

【TiDB Usage Environment】Production Environment / Testing / PoC
【TiDB Version】v7.4.0
【Reproduction Path】What operations were performed that led to the issue
【Encountered Problem: Problem Phenomenon and Impact】
【Resource Configuration】
【Attachments: Screenshots / Logs / Monitoring】

| username: 小龙虾爱大龙虾 | Original post link

Yes, because the underlying layer is TiKV, it is not compatible with xtrabackup. Please use BR or Dumpling for backups.

| username: zhanggame1 | Original post link

xtrabackup is specifically used to back up InnoDB tables, while TiDB is a KV database at its core.

| username: Fly-bird | Original post link

TiDB uses BR for physical backups and Dumpling for logical backups.

| username: dba远航 | Original post link

Xtrabackup is a physical backup tool specifically designed for traditional MySQL, and it should not have support for TiDB.

| username: forever | Original post link

Completely different logic. xtrabackup is based on physical file backup of MySQL, but the underlying structure of TiDB is completely different from MySQL. For TiDB backup, you still need to use TiDB’s BR.

| username: andone | Original post link

Not supported

| username: zxgaa | Original post link

Not supported

| username: 随缘天空 | Original post link

The official TiDB documentation recommends several commonly used migration and backup tools. There is always one that suits your needs: 数据迁移工具概览 | PingCAP 文档中心

| username: Kongdom | Original post link

According to Baidu Encyclopedia, xtrabackup is used for backing up InnoDB, while TiDB is key-value, so it cannot be used. It is recommended to use TiDB’s official tools for backup.

xtrabackup is an open-source physical backup tool for MySQL by Percona. Xtrabackup is a tool for backing up InnoDB data, supporting online hot backup (backup without affecting data read and write).

| username: TiDBer_jg5p7Njn | Original post link

Thank you, my phone customer said it is supported :smiley:

| username: swino | Original post link

You can choose to use TiDB’s built-in backup tool.

| username: Kongdom | Original post link

:thinking: Can you share how the case is supported?

| username: system | Original post link

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