Database Cluster Backup

Overview

The service provides automatic backup of database clusters. The WAL-G tool is used to create backups. Backups are stored in the Selectel Cloud Storage, isolated from other users’ backups.

The backup schedule can be as follows:

• a full cluster backup is created once a week;
• an incremental (delta) cluster backup is created once a day. Such a copy contains all changes from the previous backup;
• WAL files are created every 10 minutes or when a certain amount of changes accumulates. Point-in-Time Recovery is performed using WAL files.

Backups are stored for 7 days. After 7 days, the backups are deleted.

The backups of the deleted clusters are kept for 7 days from the date of creation. After deleting the cluster, you can restore it from backup.

You cannot disable automatic backups. The costs for storing database backups is provided on our website.

Restoring a Cluster From a Backup

You can restore a cluster from a backup to any point in the last 7 days. Restoring a cluster from a backup will create a new database cluster. You can change the cluster location, the number of servers, and their configuration. The configuration can only be changed upwards.

You can restore the cluster as follows:

• from the settings menu of an existing cluster by clicking Restore in the drop-down list of actions;
• from the form for creating a new cluster by clicking Restore from backup.

In both cases, you need to specify a point in the past and the name of the original cluster that you want to restore.

Please note that after the cluster is restored, the server addresses will change. You can change them in your application as well.