Backup and Restoration Overview
Cloud Clusters backups are point-in-time filesystem-level snapshots. Snapshots are an instantaneous "picture" of your server's file system at a certain period of time. This picture captures the entire file system as it was when the snapshot is taken. When a snapshot is used to restore the server, the server will revert to exactly how it was at the time of the snapshot.
Cloud Clusters automates the process of backing up your MySQL. The backup frequency vary based on the plan and we practice different types of snapshots. Regarding our backup strategy, you should know the following things:
Type of Snapshot:
- A full snapshot holds a full copy of the cluster data at a given point of time. By default, data of all the caches will be stored in a snapshot.
- An incremental snapshot is a copy of the data that contains only that portion that has changed since the preceding full or incremental snapshot copy. When a full recovery is needed, the restoration process needs the last full snapshot, plus all the incremental snapshots up to the point of restoration.
|plan||Backup Frequency||Backup Day||Types of Backup|
|Express||Weekly||Sunday||1 full snapshot|
|Basic||Twice per Week||Wednesday,Saturday||1 full snapshot +1 incremental snapshot|
|Professional||Three times per week||Tuesday,Thursday,Saturday||1 full snapshot + 2 incremental snapshots|
|Advanced||Daily||everyday||1 full snapshot + 6 incremental snapshots|
Besides scheduled backups, we also support on-demand backups. If you need to take a full system snapshot manually, please see taking a system snapshot. Each backup file will be restored for 7 days on our platform. If you’d like to save it for a longer time, you can download it to your local machine. If you need to back up a single database, you can visit Backing up a single database via SSH and Backing up a single database via SSMS.
You can restore your SQL Server to the state that the selected snapshot captured. The Restoration can be easily taken in our Control Panel. If you need help on the operation, please take a look at restoring a system backup. Restoring a single database from your own backup is also possible. The integrated feature- SSH service- can be helpful with the task. A guidance on a single database restoration can be viewed at Restoring a single database via SSH.