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. From the copy 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.

  1. В control panels go to Cloud platformDatabases.
  2. On the menu. 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 instructions for details) Create a cluster) and press Create a cluster.
  5. Once the cluster is rebuilt, the node addresses will change — change them in your application.