Concepts
Initial Setup
Peformance & Benchmark
Troubleshooting
FAQs
Glossary
The Backup & Restore feature on FPT Database Engine helps protect data against risks such as accidental deletion, data corruption, or system failures. The platform supports automatic backups, data restoration from backup files, and Point-in-Time Recovery for selected supported database engines.
A backup is a snapshot of database data taken at a specific point in time. Backups are used to restore data in case of operational errors or failures. The backup mechanism is designed to protect data, enable recovery in the event of failures, and meet compliance and security requirements in a cloud environment.
The Backup feature allows you to configure, operate, and monitor backup operations for database clusters. You can:
Backups are available for all database engines provided by FPT.
FPT Database Engine supports the following backup types:
Backups are stored on dedicated storage, isolated from the database cluster. This design ensures: data durability, high availability, and reliable recovery in the event of cluster failures.
Backup retention defines the number of full backups retained. When the retention limit is exceeded, the oldest backups are automatically deleted.
Restore allows you to recover a database cluster from an existing backup. The restore operation creates a new database cluster based on the selected backup.
Point-in-Time Recovery allows you to restore a database to a specific point in time. PITR is supported by combining periodic full backups and continuously archived transaction logs. This approach enables restoring a database to any valid point within the retention period.
PITR is especially useful for accidental data deletion, application errors and unintended data or configuration changes. Currently, this feature is supported for PostgreSQL, MySQL and MariaDB.
The combination of backup and PITR enhances data protection, ensures high availability, and provides flexible recovery capabilities for real-world operational scenarios.
| Permission | Action Type | Description |
|---|---|---|
| manageDatabase:ListBackup | View | Allows viewing backup service information. |
| manageDatabase:EnableBackup | Create | Allows enabling backup and restore service for a database cluster. |
| manageDatabase:DeleteBackup | Edit | Allows disabling backup and restore service for a database cluster. |
| manageDatabase:CreateJobBackup | Create | Allows creating backup jobs for a database cluster. |
| manageDatabase:ViewJobBackup | View | Allows viewing backup job details. |
| manageDatabase:RunNowJobBackup | Create | Allows triggering an on-demand backup snapshot for a database cluster. |
| manageDatabase:EditJobBackup | Edit | Allows editing backup jobs for a database cluster. |
| manageDatabase:DeleteJobBackup | Delete | Allows deleting backup jobs for a database cluster. |
| manageDatabase:ListRestore | View | Allows viewing available restore points of a database cluster. |
| manageDatabase:Restore | Create | Allows restoring a database cluster from backup or recover to a point in time. |
To manage and operate the backup service for your database cluster, please refer to the detailed instructions in the following sections:
Manage the backup service: explains how to enable/deactivate the backup service for a database cluster.
Manage backup jobs: Create/edit/delete a backup job to perform a backup for the database cluster.
Enable/disable PITR: instructions on how to enable/disable PITR to restore data to a specific point in time for supported database clusters.
Restore the database cluster: instructions on how to restore a cluster from backed-up data.
Push backup data to S3: instructions on how to push backed-up data to your S3 object for long-term storage as needed.