AWS open-sourced Postgres active-active replication extension
10 months ago
- #PostgreSQL
- #high-availability
- #database-replication
- pgactive is a PostgreSQL extension for active-active database replication.
- Database replication copies changes between instances, aiding high availability, latency reduction, and data migration.
- PostgreSQL typically uses an active-standby model with a single writable instance.
- Active-active replication allows writes on multiple instances, useful for Multi-Region HA, write latency reduction, and blue/green updates.
- Applications must handle conflicts, replication lag, and missing features like incremental sequences in active-active setups.
- Logical replication, introduced in PostgreSQL 10, is key for active-active, enabling external interpretation of changes.
- PostgreSQL's design allows extensions like pgactive to support active-active replication while awaiting upstream integration.