Table of Contents
NODE_ERROR State
Built-in High Availability (BiHA)
is a complex Postgres Pro Standard solution managed by the
biha extension and the
bihactl utility. Together with
a set of core patches, SQL interface, and the biha-background-worker
process, which coordinates the cluster nodes, BiHA
turns a Postgres Pro cluster into
a BiHA cluster —
a cluster with physical replication and built-in failover,
high availability, and automatic node failure recovery.
As compared to existing cluster solutions, i.e. a standard PostgreSQL primary-standby cluster and a cluster configured with multimaster, the BiHA cluster offers the following benefits:
Physical replication.
Dedicated leader node available for read and write transactions and read-only follower nodes.
Built-in failover including capabilities of automatic node failure detection, response, and subsequent cluster reconfiguration by means of elections.
Referee node to avoid split-brain issues.
Manual switchover.
Autorewind capabilities.
Synchronous and asynchronous node replication.
Cascading replication.
Multi-level geographical distribution and disaster resilience (experimental functionality).
Hanging prevention mechanism.
No additional external cluster software required.