Skip to main content

MySQL semi-sync cluster backups

With MySQL semi-sync Managed Databases, backups are created automatically—you don't need to configure or monitor them yourself.

The WAL-G tool is used to create cluster backups. Point-in-Time Recovery is performed using binary log entries (Point-in-Time Recovery).

Backups are stored in isolation from other users' backups.

Backups cannot be downloaded. Automatic backup creation 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 have accumulated.

Backup retention period

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

Backups of deleted clusters are stored for 7 days from the moment of creation. From a backup, you can restore the cluster.

Restore cluster

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

Restoring 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. Location, DBMS type, and version cannot be changed.

  1. In the Control panel, on the top menu, click Products and select Cloud Databases.
  2. Open the Active tab.
  3. In the cluster menu, select Restore.
  4. Select how to restore the cluster—from the last available backup or to a specific point in time within the last 7 days.
  5. You will be redirected to the page for creating a new cluster. If necessary, change the cluster settings (more details in the Create a Cluster guide) and click Create Cluster.
  6. After the cluster is restored, the node addresses will change—update them in the application that connects to the cluster.