Backup and restore overview
NineData backup and restore helps protect cloud and self-managed databases with logical backup, physical backup, restore, and backup-data query workflows. Use it to support disaster recovery, point-in-time validation, and long-term data protection across multiple environments.
Background
Data security is essential for business continuity and customer trust. Network attacks, operational mistakes, and application bugs can all put production data at risk.
NineData uses cloud-native infrastructure to provide durable backup storage, restore workflows, and online backup-data query. These capabilities help teams recover data, verify historical changes, and reduce the operational effort required to maintain backup systems.
Features
| Function | Description |
|---|---|
| Backup |
|
| Restore | Supports restore from logical backup sets and physical backup sets. Logical backup sets support second-level RPO and fine-grained row-level recovery. |
| Online query of backup data | Supports online SQL queries for data in logical backup sets. For details, see Query backup data. |
Advantages
NineData backup and restore is based on cloud-native architecture and provides the following advantages:
- Ready to use: Create an account and start protecting data without building a separate backup system.
- Simple configuration: Use guided console workflows instead of maintaining complex backup infrastructure.
- Multi-environment support: Protect databases in public cloud, private cloud, hybrid cloud, and self-managed environments through public or private network access.
- Security and compliance: Configure backup frequency, backup cycle, and retention period. NineData supports remote backup, hot and cold backup, backup data encryption, and encrypted data transmission.
- High availability: Backup storage uses redundant copies and cross-region or cross-availability-zone disaster recovery capabilities provided by cloud vendors.
- Second-level RPO: By monitoring and backing up database change logs in real time, NineData can provide RPO close to the second level.
- Online backup-data query: Query backup data at a specified point in time and use the result to support recovery after data loss.
Typical use cases
- Self-managed database backup in the cloud: Back up self-managed cloud databases to reduce infrastructure maintenance effort and improve data protection.
- Local database backup: Back up local databases to cloud storage to reduce local storage pressure as data grows.
- Multi-cloud or multi-region backup: Store backup data across regions or cloud vendors to support reliability, compliance, and disaster recovery requirements.
- Minute-level emergency recovery: Use online backup-data query and restore workflows to recover data after business logic errors or accidental operations.
- Data change tracking: Query historical backup data to investigate application bugs or trace the lifecycle of specific records.