pg_paxos: PostgreSQL Table Replication with Paxos Consensus
pg_paxos is a PostgreSQL extension that implements a basic table replication mechanism using the Paxos consensus algorithm. It ensures strong consistency across multiple PostgreSQL servers by logging every data modification and applying them in a fault-tolerant manner, allowing for seamless scaling and high availability in distributed database environments.
Features
Strong consistency through Multi-Paxos log application
Robustness to node failures, sustaining operations even with a minority of nodes down
Automatic logging of SQL queries to a replicated table via executor hooks
Supports dynamic group membership, allowing nodes to join or leave the replication group
Two consistency models: strong and optimistic, catering to different performance requirements
Direct access to Paxos functions for custom distributed logging solutions