EDB Postgres Distributed¶
EDB Postgres Distributed provides multi-master replication and data distribution with advanced conflict management, data-loss protection, and throughput up to 5X faster than native logical replication, and enables distributed PostgreSQL clusters with high availability up to five 9s.
node diagram¶
By default EDB Postgres Distributed uses asynchronous replication, applying changes on the peer nodes only after the local commit. Additional levels of synchronicity can be configured between different nodes, groups of nodes or all nodes by configuring show-camo ,
CAMO versus group commit , or eager all node replication features.
- EDB Postgres Distributed Release notes
- Release notes for EDB Postgres Distributed version 4.2.0
- Release notes for EDB Postgres Distributed version 4.1.1
- Release notes for EDB Postgres Distributed version 4.1.0
- Release notes for EDB Postgres Distributed version 4.0.3
- Release notes for EDB Postgres Distributed version 4.0.2
- Release notes for EDB Postgres Distributed version 4.0.1
- Release notes for EDB Postgres Distributed version 4.0.0
- ‘Known issues’
- Terminology
- Asynchronous replication
- Availability
- CAMO or commit-at-most-once
- Clustering
- Data sharding
- Eager Replication for BDR
- Eventual consistency
- Failover
- Horizontal scaling or scale out
- Logical replication
- Nines
- Node
- Physical replication
- Read scalability
- Recovery point objective (RPO)
- Recovery time objective (RTO)
- Single point of failure (SPOF)
- Switchover
- Synchronous replication
- Two-phase commit (2PC)
- Vertical scaling or scale up
- Write scalability
- Key components
- Choosing your architecture
- Choosing a Postgres distribution
- Choosing durability
- Other considerations
- Deployment options
- Upgrading
- Compatibility matrix
- Backup and recovery
- Monitoring
- Monitoring Overview
- Monitoring Node Join and Removal
- Monitoring Replication Peers
- Monitoring BDR Replication Workers
- Monitoring BDR Writers
- Monitoring Global Locks
- Monitoring Conflicts
- External Monitoring
- Apply Statistics
- Standard PostgreSQL Statistics Views
- Monitoring BDR Versions
- Monitoring Raft Consensus
- Monitoring Replication Slots
- Monitoring Transaction COMMITs
- EDB Postgres Distributed Command Line Interface