Skip to main content
MySQL semi-sync backup
Last update:

MySQL semi-sync backup

With MySQL semi-sync cloud databases, cluster backup is automatic — you don't need to configure it yourself and monitor the creation of copies.

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 unloaded. Automatic backups cannot be disabled.

Backup schedule

  • Full cluster backups are created once a day.
  • Binlog files are created regularly or when a certain amount of changes accumulate.

Retention period for copies

Backups are kept for 7 days, after which they are deleted.

Backups of remote clusters are kept for 7 days from the time the copy is created. You can restore cluster from a copy.

Restore the cluster

You can restore a cluster from a backup to any point in time in the last 7 days.

The restore creates a new database cluster — 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.

  1. In Control Panel, go to Cloud PlatformDatabases.
  2. From the () menu of the cluster, select Restore.
  3. Choose how to restore the cluster — from the last available backup or to a specific point in time within the last 7 days.
  4. You will be redirected to the page for creating a new cluster. If necessary, change the cluster settings (see the Create Cluster instructions for details) and click Create Cluster.
  5. Once the cluster is rebuilt, the node addresses will change — change them in your application.

Cost

Backup storage is charged under the cloud platform payment model.

The cost is listed at .