2.8. Providing High Availability #
You can create backups of the OLAP data in local storages using BiHA and pg_probackup. In network and S3 storages, use BiHA and pg_probackup for the Postgres Pro AXE DBMS data and backup tools of the storage provider for the OLAP data.
The implementation of high availability depends on the required OLAP data restore time (refer to the table below).
OLAP Data Restore Time | Implementation |
|---|---|
Days | Full backups of the OLAP data |
Hours, minutes | Incremental backups of the OLAP data |
Seconds | Full backups of the OLAP data on standby servers or a fail-safe network/S3 storage |
Note
Most OLAP data processing scenarios do not have strict requirements on the restore time as compared to OLTP data processing scenarios and real-time analytics.