pgEdge Announces pgEdge Platform Constellation Release (v24.7)

Rhea-AI Summary

pgEdge, Inc. has released pgEdge Platform v24.7, known as the Constellation Release, introducing advanced Postgres logical replication features. Key enhancements include:

1. Large Object Logical Replication (LOLOR) for media asset compatibility
2. Improved replication exception handling and logging
3. New replication repair mode for increased control
4. Automatic replication of DDL commands
5. Snowflake Sequence in Postgres extension for unique sequencing

The company also announced upcoming Parallel Replication features for Q4, promising increased replication throughput. pgEdge Platform offers a distributed PostgreSQL solution with multi-master capability, reducing latency and ensuring high availability across geographic regions.

Positive

• Introduction of advanced Postgres logical replication features in v24.7
• Large Object Logical Replication (LOLOR) enhances compatibility with existing applications
• Improved replication exception handling and logging for better error management
• New replication repair mode offers increased control over distributed PostgreSQL clusters
• Automatic replication of DDL commands simplifies schema updates across nodes
• Integration of Snowflake Sequence for unique sequencing in multi-master replication scenarios
• Upcoming Parallel Replication features promise increased replication throughput

Negative

• None.

Insights

Database Technology Expert

The release of pgEdge Platform v24.7 (Constellation Release) represents a significant advancement in distributed PostgreSQL technology. Key features like Large Object Logical Replication (LOLOR) and enhanced error handling address critical needs in enterprise database management. The introduction of Replication Repair Mode and automatic DDL replication offers improved control and ease of use for database administrators.

The upcoming Parallel Replication feature, slated for Q4, could be a game-changer for high-traffic OLTP workloads. This could potentially position pgEdge as a strong competitor in the distributed database market, especially against established players. However, the real-world performance and reliability of these features will be important for market adoption.

For investors, this release signals pgEdge's commitment to innovation and addressing enterprise needs, which could translate to increased market share and revenue growth in the competitive database market.

Cloud Infrastructure Analyst

pgEdge's latest release strengthens its position in the cloud-native database landscape. The ability to self-host on major cloud providers like AWS, Azure and Google Cloud enhances its appeal to enterprises pursuing multi-cloud strategies. The upcoming pgEdge Cloud managed service (Q3 availability) could be a significant revenue driver, tapping into the growing demand for fully managed database services.

The Snowflake Sequence extension is particularly noteworthy, as it addresses a common challenge in distributed systems without requiring application changes. This could lower the barrier for enterprises considering a move to distributed PostgreSQL.

However, pgEdge will face stiff competition from established cloud database services and other distributed SQL solutions. Its success will depend on demonstrating clear performance, cost and reliability advantages over these alternatives.

Introduces Advanced Replication Features, Offering a Reliable Alternative to Legacy Multi-master Replication Technologies

ALEXANDRIA, Va., Aug. 7, 2024 /PRNewswire/ -- pgEdge, Inc., the leading company dedicated to distributed Postgres, today announces the availability of pgEdge Platform v24.7, also known as the Constellation Release. This latest release introduces advancements in Postgres logical replication, including parallel processing and large object support and enhanced error handling, providing users with greater throughput, flexibility and control. This makes pgEdge a viable open source distributed PostgreSQL alternative for legacy database workloads requiring multi-master capability.

pgEdge remains the only fully distributed PostgreSQL solution that is open (source available) and completely based on the standard PostgreSQL database. With its unique multi-master (active-active) replication that runs across geographic regions, pgEdge reduces latency and ensures ultra-high availability.

pgEdge has collaborated with its customers, partners and community to deliver a number of key new features:

• Large Object Logical Replication (LOLOR): LOLOR is a PostgreSQL extension that makes large objects compatible with logical replication. This provides compatibility with a variety of existing applications that store media assets and other large files in PostgreSQL databases. Applications that previously stored media assets or large files in the database can now run on pgEdge without modification. For instance, migrating from legacy database workloads to PostgreSQL often involves large object support, which LOLOR seamlessly handles.
  
  
• Replication Exception Handling and Logging: This feature introduces a new exception log table, where replication errors are logged to prevent them from blocking subsequent replication changes. This ensures a more robust and user-friendly experience when managing replication. Graceful error handling means that replication errors in unexpected situations are appropriately managed without interrupting overall system operation. Users gain visibility into replication errors for easier troubleshooting and can utilize tools like the pgEdge Anti-Chaos Engine (ACE) for future error remediation.
  
  
• Replication Repair Mode: A new function that allows users to enable and disable "repair mode," giving them the option to opt-out of replicating changes made on a specific database node. This provides end-users increased control over replication in a distributed PostgreSQL cluster and prevents unwanted replication of changes while resolving errors or modifying the state of a single database node. It also offers flexibility in managing replication processes and supports error remediation by external tools without affecting the entire cluster.
  
  
• Automatic Replication of DDL Commands: With this feature, developers can now update the database schema on a single node, and the changes are automatically propagated to other nodes in the cluster. This makes it far easier to support distributed PostgreSQL applications where the database schema is frequently updated due to active development or maintenance.
  
  
• Snowflake Sequence in Postgres Extension: pgEdge has integrated Snowflake sequences into a PostgreSQL extension to make it easier to manage sequences in distributed PostgreSQL multi-master replication scenarios. A Snowflake sequence allows for the utilization of a guaranteed unique sequence within a cluster without the need for application code or schema modifications. By automatically installing the Snowflake extension in pgEdge Platform and pgEdge Cloud databases, users can easily maintain unique sequence numbers across different regions, eliminating conflicts and enhancing scalability.

High Performance Parallel Replication Coming to pgEdge Platform in Q4
pgEdge will also provide Parallel Replication features which will be available in pgEdge Platform in Q4 of this year. This feature leverages multiple replication slots to enable parallel replication processing within a distributed PostgreSQL cluster. By doing so, it significantly increases replication throughput in high-traffic, cross-region OLTP workloads. Parallel processing of replication tasks substantially boosts replication speed, enhancing overall system performance. PostgreSQL users can now efficiently manage larger volumes of data replication across distributed clusters, supporting high-demand environments. It also reduces replication lag and ensures timely data synchronization across all nodes, maintaining data consistency and reliability.

"We are excited to announce the latest version of pgEdge Platform built on open standard-based PostgreSQL," said Phillip Merrick, Co-founder and CEO of pgEdge. "With these new features and enhancements, we continue our commitment to advance distributed PostgreSQL capabilities within the community as well as make it easier to deliver applications that are always available and always responsive."

pgEdge Platform packages pgEdge distributed PostgreSQL as downloadable software that can be self-hosted and self-managed in either on-premises environments and/or in the cloud with major providers such as AWS, Microsoft Azure and Google Cloud Platform. Enterprise class support is also available from pgEdge. pgEdge Cloud, a fully managed cloud service based on pgEdge Platform, will be generally available in Q3.

For more information and to download the latest product version visit www.pgedge.com/download.

About pgEdge
pgEdge, the leading company dedicated to distributed Postgres, has made its mission to make it easy for developers to build and deploy highly distributed database applications across the global network. Founded by industry veterans who have championed enterprise usage of the PostgreSQL database for several decades and helped run the world's largest managed database cloud services, pgEdge is headquartered in Northern Virginia. The founders have previously founded and/or led successful companies such as webMethods (NASDAQ: WEBM), EnterpriseDB (acquired by Bain Capital), SparkPost (acquired by MessageBird), OpenSCG (acquired by AWS) and Fugue (acquired by Snyk). Investors in pgEdge include Sands Capital Ventures, Grotech Ventures and Sand Hill East.

View original content to download multimedia:https://www.prnewswire.com/news-releases/pgedge-announces-pgedge-platform-constellation-release-v24-7-302214594.html

SOURCE pgEdge

FAQ

What new features does pgEdge Platform v24.7 (Constellation Release) introduce?

pgEdge Platform v24.7 introduces Large Object Logical Replication (LOLOR), improved replication exception handling and logging, replication repair mode, automatic replication of DDL commands, and Snowflake Sequence in Postgres extension.

When will pgEdge introduce Parallel Replication features?

pgEdge plans to introduce Parallel Replication features in Q4 of this year, which will significantly increase replication throughput in high-traffic, cross-region OLTP workloads.

How does pgEdge Platform v24.7 improve large object support?

The new Large Object Logical Replication (LOLOR) feature makes large objects compatible with logical replication, allowing applications that store media assets or large files in the database to run on pgEdge without modification.

What benefits does the new replication repair mode in pgEdge Platform v24.7 offer?

The replication repair mode allows users to enable and disable 'repair mode,' giving them the option to opt-out of replicating changes made on a specific database node, providing increased control over replication in a distributed PostgreSQL cluster.