AnalyticDB for PostgreSQL uses a primary/secondary architecture to provide multi-replica redundancy. AnalyticDB for PostgreSQL also uses the triplicate storage technology of disks to ensure data reliability. The system switches over to a secondary node when the primary node fails and recovers a node when the node fails. This ensures high availability. You can also restore data by using the backup and restoration feature.
Primary/secondary multi-replica redundancy and triplicate storage technology of disks
AnalyticDB for PostgreSQL is a distributed database service that uses the massively parallel processing (MPP) architecture. Distribution allows performance to be enhanced. However, a distributed database system may encounter high fault probability on nodes. Typically, a distributed database system provides multiple replicas to ensure service availability when specific nodes fail. AnalyticDB for PostgreSQL uses a dual-replica architecture. If a single replica set provides available compute nodes, the corresponding instance can provide services normally based on the primary/secondary dual-replica architecture. To ensure data reliability, AnalyticDB for PostgreSQL uses the triplicate storage technology of disks. A data file is discretely stored in triple-modular redundancy to prevent data loss.
Automatic failover and recovery
AnalyticDB for PostgreSQL checks the health status of nodes on an instance in real time. If the primary compute node is abnormal, a hot standby node takes over from the abnormal node to ensure instance availability. If a node is abnormal, AnalyticDB for PostgreSQL recovers the node to ensure multiple-replica redundancy for an instance. The recovery methods vary based on scenarios. For example, if compute nodes are abnormal due to exceptions on a physical machine, the system migrates the nodes to another machine. If compute nodes are abnormal due to a suspended process, the system restarts the process.
Backup and restoration
In specific cases, data is lost due to data center-level failures or accidental deletion of data. AnalyticDB for PostgreSQL can restore data for instances by using remote data backups. AnalyticDB for PostgreSQL supports full logical backup and restoration and is about to support incremental backup and restoration. Compared with full logical backup, incremental backup does not lock data and has little impact on your business. AnalyticDB for PostgreSQL allows you to restore data at the instance, database, and schema levels.