Disaster Recovery Overview
Doris provides complete disaster recovery capabilities that help you handle data loss risks caused by hardware failures, software errors, and human operation mistakes. By combining backup and restore with recycle bin recovery, you can ensure high availability and reliability of data across different failure granularities.
Applicable Scenarios
Different disaster recovery capabilities apply to different failure scenarios. Combine them based on your business needs:
| Capability | Applicable Scenario | Recovery Granularity | Recovery Speed | Typical Use Case |
|---|---|---|---|---|
| Backup and restore | Data corruption, long-term archiving, migration | Database, table, partition | Minutes to hours (depending on data volume) | Periodic snapshots, cross-cluster migration, compliance archiving |
| Recycle bin recovery | Short-term human errors such as accidentally dropping tables or databases | Table, database | Seconds | Accidental deletion recovery, short-term retention |
Capability Comparison
The two capabilities differ in data protection strength, operational cost, and dependencies:
| Dimension | Backup and Restore | Recycle Bin Recovery |
|---|---|---|
| Data timeliness | Periodic snapshots | Retained at the moment of deletion |
| External dependencies | Requires remote storage such as object storage or HDFS | None (retained locally within the cluster) |
| Retention period | Retained according to backup policy | Configurable retention period, automatically cleaned up on expiration |
| Operational cost | Medium (periodic jobs + storage cost) | Low (enabled by default) |
1. Backup and Restore
Doris provides backup and restore functionality for periodically saving data snapshots, preventing data loss caused by unexpected events, and supporting data migration and long-term archiving.
Key Features
- Backup: Supports full backup of specified databases, tables, or partitions, saving complete data snapshots.
- Restore: Supports restoring databases, tables, or partitions from snapshots.
Example Scenario
A company periodically backs up its data and stores the backup files in an object storage service (such as Amazon S3). When an important table is dropped by mistake, the backup feature quickly restores the lost data and ensures normal business operations.
For detailed usage, see Data Backup and Data Restore.
2. Recycle Bin Recovery
Doris provides a recycle bin feature that offers a quick way to recover recently deleted data and reduce the impact of operational mistakes.
Key Features
- Temporary deletion: Tables or databases that are dropped are moved to the recycle bin first instead of being permanently deleted immediately.
- Retention period: Deleted data is kept in the recycle bin for a configurable period, during which you can choose to restore it.
- Quick recovery: Easily recover mistakenly deleted data from the recycle bin without going through a full backup and restore process.
- Data safety: If recovery is not needed, data in the recycle bin is automatically cleaned up after the retention period.
Example Scenario
A team accidentally drops an important table during routine operations. With the recycle bin feature, they quickly recover the deleted data, avoid a complex backup and restore process, and keep the business running.
For detailed usage, see Recycle Bin.
FAQ
Q: I accidentally dropped a table. Which feature should I use to recover it?
Use recycle bin recovery first. It completes in seconds and does not depend on external storage. If the retention period has passed, use backup and restore to recover from the most recent snapshot.
Q: Does data in the recycle bin stay there forever?
No. Deleted data is only kept during the configurable retention period and is automatically cleaned up after expiration. For long-term retention, use backup and restore.
Q: Where can backup files be stored?
Backup files support remote storage such as object storage (for example, Amazon S3) and HDFS, which avoids single-point failures shared with the source cluster.
