Database-as-a-Service provider EnterpriseDB (EDB) has released the next generation of its popular distributed open source PostgreSQL Called EDB Postgres Distributed 5.0, this database is designed to provide high availability, optimized performance, and protection against data loss.
in contrast PostgreSQL14 EDB’s Postgres Distributed 5.0 (PGD 5.0) provides 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 has a single node group for the entire cluster.
“Each node (database) participating in a PGD group can receive changes from other members and be written directly by users.” blog post.
“This is different from hot or warm standby, where only one master server accepts writes and all other nodes replicate from the master or another standby,” the company added.
For high availability, enterprises can set up their PGD 5.0 system so that each master node or database or server can be protected by one or more standby nodes, the company said.
“A group is a basic building block that consists of two or more nodes (servers). Each node in the group is in a different availability zone with dedicated routers and backups for instant switchover and high availability. Each group has its own replication set defined.If the group loses a node, it can be easily repaired or replaced by copying the existing node from the group,” the company said. says.
This means that one node is the target of the main application and the others are in shadow mode. In other words, it’s doing a read/write replica function.
This architectural setup improves performance as the main write function runs on one node. The company adds, “Secondary applications may run against the shadow node, but the shadow node will be reduced or suspended when the main application begins using it.”
“In the future, one node will be elected as the main replicator to other groups, limiting the CPU overhead of replication and minimizing bandwidth to other groups as the cluster grows.” said the company.
Data protection is key
As the amount of data that businesses generate increases, downtime in their IT infrastructure can take a serious toll on them. Additionally, data center breaches are becoming more common, Uptime Institute’s 2022 Outage Analysis Report indicates that 80% of data centers have failed in the last two years.
another Report from IBM showed that dealing with data breaches has become very costly.
A distributed version of EDB’s object-relational database system, which competes with Azure’s Cosmos DB and Citius integration, is available as an add-on called EDB Extreme High Availability for EDB Enterprise and Standard Plans, the company said.
The company will soon offer a 60-day self-guided trial of PGD 5.0. The distributed version supports PostgreSQL, EDB Postgres Extended Server, and EDB Postgres Advanced Server along with other servers. combination of versions.
Copyright © 2023 IDG Communications, Inc.
https://www.infoworld.com/article/3689161/edbs-postgres-distributed-50-boosts-availability-performance.html#tk.rss_all EDB’s Postgres Distributed 5.0 Improves Availability and Performance