edb-ref-archs
edb-ref-archs copied to clipboard
EnterpriseDB
EDB Reference Architectures
EDB Reference Architectures
Introduction
This repository contains reference architectures and supporting materials and code for the deployment of EDB Postgres Advanced Server, PostgreSQL and related tools for high availability, monitoring, and management.
Selecting an Architecture
The reference architectures offered are split into the core database server and a number of optional add ons.
Each database server architecture is designed to meet different needs and requirements, offering a range of scalability and availability and redundancy options offering different levels of:
- Recovery Time Objective (RTO)
- Recovery Point Objective (RPO)
- Geographic Redundancy Objective (GRO)
- Target Availability
Select and implement the most appropriate reference architecture to meet your needs, and then implement one or more of the Add On options to provide the additional functionality you require.
Database Clusters
- Single node
- Multi node with asynchronous replication
- Multi node with synchronous replication
| Architecture | Redundancy | Automatic Failover | Multi node commit | Recommended Use |
|---|---|---|---|---|
| Single Node | No | No | No | Development/testing |
| Multi Node Async | Yes | Yes | No | Production, with transaction loss acceptable |
| Multi Node Sync | Yes | Yes | Yes | Production, with no transaction loss acceptable |
Add Ons
Poolers and Query Routers
- Load balancing with pgBouncer
- Load balancing and query routing with pgPool
| Add On | Load balancing | Query Routing |
|---|---|---|
| pgBouncer | Yes | No |
| pgPool | Yes | Yes |
Administration
- Monitoring with Postgres Enterprise Manager (PEM)
- Backup & Recovery with Backup and Recovery Tool (BART)
Improvements and Issues
If you want to suggest any improvements or report any problems you may have found, please create a Pull Request or log an Issue.
License
The contents of this repository are licensed under the PostgreSQL License.
EnterpriseDB