Backups in Yandex MPP Analytics for PostgreSQL
When are backups performed? Is a DB cluster available during backup?
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.
Is DB host backup enabled by default?
Yes, backup is enabled by default. For Greenplum®, a full backup is performed every day, saving all DB cluster transaction logs. The first and every second automatic backups are full backups of all databases. Other backups are incremental and store only the data that has changed since the previous backup to save space.
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 Yandex MPP Analytics for PostgreSQL cluster backups 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.