# Comparison of Backup and Recover Technologies

__*Comparison of backup and recover technologies*__

| Methodology | Cold/Hot/Warm Backup | Logical/Physical Backup | consistency |
| :-- | :-- | :-- | :-- |
| BR Tool | Hot Backup | Physical Backup | Yes |
| Dumpling | Hot/Warm Backup | Logical Backup | Yes |
| Replication | Hot Backup | Logical Backup | Yes |
| OS Copy | Cold or Warm Backup | Physical Backup | Yes |

-------------------------------------------------------------
Let's compare the various backup method:

BR tool: BR, fully known as Backup & Restore, is a command line tool for TiDB distributed backup and recover. It is used for data backup and recover of TiDB clusters.

Dumpling: Data stored in TiDB/MySQL can be exported to SQL or CSV format, which can be used to complete a logical full backup or export.

Copy: Use the TiDB synchronization tool to copy the TiDB database.

Operating system copy: Direct copy of operating system data files for backup.

| Methodology | Cold/Hot/Warm Backup | Logical/Physical Backup | consistency |
| :-- | :-- | :-- | :-- | :-- | :-- |
| BR Tool | Hot Backup | Physical Backup | Yes |
| Dumpling | Hot/Warm Backup | Logical Backup | Yes |
| Replication | 16 Cores + | Hot Backup | Logical Backup | Yes |
| OS Copy | Cold or Warm Backup | Physical Backup | Yes |