Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.
Original topic: tidb使用xtrabackup备份失败,是不支持吗
【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】
Yes, because the underlying layer is TiKV, it is not compatible with xtrabackup. Please use BR or Dumpling for backups.
xtrabackup is specifically used to back up InnoDB tables, while TiDB is a KV database at its core.
TiDB uses BR for physical backups and Dumpling for logical backups.
Xtrabackup is a physical backup tool specifically designed for traditional MySQL, and it should not have support for TiDB.
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.
The official TiDB documentation recommends several commonly used migration and backup tools. There is always one that suits your needs: 数据迁移工具概览 | PingCAP 文档中心
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).
Thank you, my phone customer said it is supported
You can choose to use TiDB’s built-in backup tool.
Can you share how the case is supported?
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.