EnterpriseDB unveils a ground-breaking update for Postgres with EDB Postgres Distributed (PGD) 5.0, which aims to deliver extreme high availability, operational resiliency, and enterprise-scale. This innovative solution is designed to assist customers in addressing their most mission-critical use cases.
Jozef de Vries, EDB's Chief Product Engineering Officer, states that PGD 5.0 "uniquely solves the problem of planned downtime and unplanned outages for enterprises running business-critical applications.” The solution offers extreme high availability for Postgres, keeping business- and mission-critical applications running and safeguarding against both planned and unplanned outages.
This breakthrough is achieved through the use of a novel active-active technology that allows customers to run PostgreSQL with up to 99.999%+ availability. This multi-master capability is exclusively available with EDB, setting it apart from any other Postgres-native database.
Marc Linster, EDB's Chief Technology Officer, emphasizes the importance of operational resiliency in today's business environment. Downtime and data loss can result in significant business disruption, and enterprises cannot afford such consequences. PGD 5.0 delivers extreme high availability to minimize downtime, ensuring customers can always access their data and applications, even during major version upgrades and maintenance operations.
EDB's PGD 5.0 offers support and guidance for a standard set of architecture topologies known as 'Always On.' These topologies support single or multi-location deployments with varying levels of redundancy, depending on customers' Recovery Point Objective (RPO) and Recovery Time Objective (RTO) requirements.
Several key benefits are offered by EDB PGD 5.0 for IT and business, including:
- Maximizing uptime: Extreme high availability ensures that high-value transactions occur when necessary and allows businesses to deliver the uptime customers and partners expect.
- Protecting business-critical applications: A redundancy architecture for frequently accessed applications offers a higher level of availability and protection.
- Increased availability of web-based applications: Redirecting traffic to functional servers ensures online applications remain operational in case a server fails.
- Avoidance of productivity disruptions: Businesses can perform full version upgrades and maintenance with minimal downtime, avoiding costly maintenance weekends.
PGD's 'Always On' capability is based on a 3 or 5 node group architecture that protects against an increasing range of failure situations. Each architecture can provide a zero RPO, as data can be streamed synchronously to at least one local master, guaranteeing zero data loss in case of local hardware failure.
During system maintenance or software upgrades, PGD maintains availability through a process called 'rolling upgrades' or 'rolling restart.' This process is performed on each node in the cluster one at a time, while keeping the rest of the cluster operational. During the upgrade, the application can switch over to a node not undergoing maintenance or upgrade, providing continuous database availability. PGD offers an array of tooling and documentation to assist users in orchestrating this process.
PGD 5.0 is immediately available without disruption through EDB Extreme High Availability, an easy-to-use add-on to EDB Enterprise and Standard Plans. It is accompanied by EDB's newly-launched Transparent Data Encryption (TDE) and PostgreSQL's intrinsic security and disaster recovery features for a comprehensive, modern cybersecurity infrastructure and database productivity solution.
Furthermore, AppMaster plans to keep supporting and upgrading seamless compatibility with PostgreSQL and EDB Postgres, given their proven reliability, extreme high availability and capability to scale easily, which perfectly align with AppMaster's serverless and scalable No-Code platform.