Database-as-a-service (EDB) provider EnterpriseDB has released the next generation of its popular distributed open source PostgreSQL database, called EDB Postgres Distributed 5.0, designed for high availability, optimized performance, and protection against data loss. .
In contrast to its PostgreSQL14 offering, EDB’s Postgres Distributed 5.0 (PGD 5.0) offers a distributed architecture along with features such as logical replication.
In the PGD 5.0 architecture, a node or database is a member of at least one node or database group, and the most basic system would have a single node group for an entire cluster.
“Each node (database) that participates in a PGD group receives changes from other members and can be directly written to by the user,” the company said in a blog post.
“This is different from hot or warm standby, where only one master server accepts writes, and all other nodes are standbys that replicate from the master or another standby,” the company added.
To enable high availability, companies can configure a PGD 5.0 system in such a way that each master node, database or server can be protected by one or more standby nodes, the company said.
“Group is the building block consisting of more than 2 nodes (servers). In a cluster, each node is in a different Availability Zone, with a dedicated router and backup, providing immediate failover and high availability. Each group has a dedicated replication set defined. If the pool loses a node, you can easily repair or replace it by copying an existing node from the pool,” the company said.
This means that one node is the target of the main application and the other nodes are in shadow mode, which means that they are performing the role of read and write replica.
This architectural configuration allows for faster performance as the primary write function occurs on one node, the company said, adding that “secondary applications can run against the hidden nodes, though these are throttled or interrupted if the primary application starts to use that node”.
“In the future, one node will be chosen as the primary replicator for other clusters, limiting CPU replication overhead as the cluster grows and minimizing bandwidth for other clusters,” the company said.
Data protection is key
As businesses generate ever-increasing amounts of data, IT infrastructure downtime can cause serious damage to businesses. Additionally, data center breaches are becoming more common, and a report from Uptime Institute’s 2022 Outage Analysis Report showed that 80% of data centers have experienced an outage in the last two years.
A separate report from IBM showed that data breaches have become very expensive to manage.
The distributed version of EDB’s object-relational database system, which competes with Azure’s Cosmos DB with Citius integration, is available as an add-on, dubbed EDB Extreme High Availability, for EDB Enterprise and Standard Plans, the company said.
In addition, EDB said it will release the distributed version for all of its managed database-as-a-service offerings, including Oracle-compatible BigAnimal and the AWS-compatible EDB Postgres cloud database service.
The company hopes to offer a 60-day self-guided trial for PGD 5.0 soon. The distributed version supports PostgreSQL, EDB Postgres Extended Server, and EDB Postgres Advanced Server along with other version combinations.
Copyright © 2023 IDG Communications, Inc.
Be First to Comment