Doris Backup Strategy (Full Backup, Incremental Backup, Snapshot Backup)
1. Full Backup
A full backup refers to creating a complete copy of an entire database or application's data, including all table structures, data, and indexes. In this backup strategy, we must ensure that the entire system can be restored from the backup files.
Advantages:
- Can be used for long-term data storage
- Facilitates fault recovery
Disadvantages:
- Consumes a large amount of storage space
- Requires a relatively long time to complete the backup and restore process
2. Incremental Backup
An incremental backup refers to backing up only the updated data, such as newly added tables or rows. This strategy reduces backup time and saves storage space.
Advantages:
- Consumes less storage space
- Faster backup and restore speeds
Disadvantages:
- Requires regular full backups
- Backup data may omit some historical data
3. Snapshot Backup
A snapshot backup refers to creating a snapshot of a database or application at a specific point in time, capturing the data at that moment. This strategy provides fast recovery and convenient storage.
Advantages:
- Fast recovery speed
- Convenient storage
Disadvantages:
- Requires regular snapshot creation
- Backup data may omit some historical data