Backups in Yandex MPP Analytics for PostgreSQL
When does a backup run? Is a database cluster available during backups?
The backup window is an interval during which a full daily backup of the DB cluster is performed. You can configure a backup window when creating or editing a cluster.
Clusters remain fully accessible during backups.
Are database host backups enabled by default?
Yes, backups are on by default. For Greenplum®, a full backup takes place once a day and saves all transaction logs for a DB cluster. The first and every second automatic backups are full backups of all databases. To save space, other backups are incremental and only store the data that has changed since the previous backup.
Automatically created backups of an existing cluster are kept for seven days, whereas those created manually are stored indefinitely. Once the cluster is deleted, all its backups are kept for seven days.
Can I run backup for a Greenplum® cluster manually?
Yes, Yandex MPP Analytics for PostgreSQL supports manually running a cluster backup.
Can I select other resources when restoring a cluster from a backup?
Yes, with the following restrictions:
- The total number of segments must be the same as in the source cluster.
- The disk size per segment in the new cluster must be at least as large as in the source cluster.
Example
The source cluster has four segment hosts, each containing four segments. The total number of segments is 16. When restoring the cluster, you can choose two segment hosts with eight segments per host, so that the total number of segments remains 16.
To ensure that the disk size per segment does not decrease, the disk size in each segment host must at least double.
Greenplum® and Greenplum Database® are registered trademarks or trademarks of Broadcom Inc. in the United States and/or other countries.