MySQL semi-sync backups
With MySQL semi-sync cloud databases, backups are created automatically — you don't need to configure and monitor backups yourself.
The WAL-G tool is used to create cluster backups. Point-in-Time Recovery is performed using binary log entries.
Backups are stored in isolation from other users' backups.
Backups cannot be uploaded. Automatic creation of backups cannot be disabled.
Backup schedule
- Full cluster backups are created once per day.
- Binlog files are created regularly or when a certain amount of changes accumulate.
Backup retention period
Backups are stored for 7 days, after that they are deleted.
Backups of remote clusters are kept for 7 days from the date of creation. From the backup you can cluster recovery.
Restore the cluster
You can restore a cluster from a backup to any point in time in the last 7 days.
When restoring, a new database cluster is created — you can change the name, configuration (with the same or larger disk size), number of nodes, network and DBMS settings. The DBMS type and version cannot be changed.
If the cluster is not deleted
If the cluster is removed
- In control panel go to Cloud platform → Databases.
- On the menu. cluster select Restore.
- Select how to restore the cluster — from the last available backup or to a specific point in time within the last 7 days.
- You will be redirected to the page for creating a new cluster. If necessary, change the cluster settings (see the instructions for details) Create a cluster) and press Create a cluster.
- Once the cluster is rebuilt, the node addresses will change — change them in your application.
- In control panel go to Cloud platform → Databases.
- Click Create a cluster.
- Select the pool where the remote cluster was located.
- Check the box Restore a cluster from backup.
- Select the source cluster.
- Select how to restore the cluster — from the last available backup or to a specific point in time within the last 7 days.
- Click Continue.
- Select the rest of the cluster settings — see the instructions for details Create a cluster.
- Click Create a cluster.
- Once the cluster is rebuilt, the node addresses will change — change them in your application.