pgEdge Announces pgEdge Platform Constellation Release (v24.7)
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.
pgEdge, Inc. ha rilasciato pgEdge Platform v24.7, conosciuto come Constellation Release, che introduce funzionalità avanzate di replicazione logica Postgres. Le principali migliorie includono:
1. Replicazione logica di oggetti di grandi dimensioni (LOLOR) per la compatibilità con i media
2. Migliorata gestione delle eccezioni di replicazione e logging
3. Nuova modalità di riparazione della replicazione per un controllo maggiore
4. Replicazione automatica dei comandi DDL
5. Sequenza Snowflake nell'estensione Postgres per una sequenziazione unica
L'azienda ha anche annunciato prossime funzionalità di Replicazione Parallela per il Q4, promettendo un aumento del throughput di replicazione. La pgEdge Platform offre una soluzione PostgreSQL distribuita con capacità multi-master, riducendo la latenza e garantendo alta disponibilità in diverse regioni geografiche.
pgEdge, Inc. ha lanzado pgEdge Platform v24.7, conocido como el Constellation Release, que introduce funciones avanzadas de replicación lógica de Postgres. Las principales mejoras incluyen:
1. Replicación lógica de objetos grandes (LOLOR) para la compatibilidad con activos multimedia
2. Mejor gestión de excepciones y registro de replicación
3. Nueva modo de reparación de replicación para un mayor control
4. Replicación automática de comandos DDL
5. Secuencia Snowflake en la extensión de Postgres para secuenciación única
La empresa también anunció próximas funciones de replicación paralela para el Q4, prometiendo un aumento en el rendimiento de replicación. pgEdge Platform ofrece una solución PostgreSQL distribuida con capacidad multi-master, reduciendo la latencia y asegurando alta disponibilidad en diferentes regiones geográficas.
pgEdge, Inc.는 pgEdge Platform v24.7, 즉 Constellation Release를 발표하였으며, 이는 Postgres 논리 복제 기능을 개선한 것입니다. 주요 개선 사항은 다음과 같습니다:
1. 대용량 객체 논리 복제 (LOLOR)로 미디어 자산 호환성 제공
2. 향상된 복제 예외 처리 및 로깅
3. 제어를 강화하기 위한 새로운 복제 수리 모드
4. DDL 명령의 자동 복제
5. Snowflake 시퀀스를 통한 고유한 순서 지정의 Postgres 확장
회사는 Q4에 대한 병렬 복제 기능도 발표하며, 복제 처리량의 증가를 약속했습니다. pgEdge Platform은 다양한 지역에서의 높은 가용성을 보장하면서 지연 시간을 줄이는 분산 PostgreSQL 솔루션을 제공합니다.
pgEdge, Inc. a lancé la pgEdge Platform v24.7, connue sous le nom de Constellation Release, introduisant des fonctionnalités avancées de réplication logique Postgres. Les principales améliorations comprennent :
1. Réplication logique d'objets volumineux (LOLOR) pour la compatibilité avec les actifs multimédias
2. Amélioration de la gestion des exceptions de réplication et de l'enregistrement
3. Nouveau mode de réparation de la réplication pour un contrôle accru
4. Réplication automatique des commandes DDL
5. Séquence Snowflake dans l'extension Postgres pour un séquençage unique
La société a également annoncé les prochaines fonctionnalités de réplication parallèle pour le quatrième trimestre, promettant un débit de réplication accru. La pgEdge Platform offre une solution PostgreSQL distribuée avec une capacité multi-master, réduisant la latence et assurant une haute disponibilité dans différentes régions géographiques.
pgEdge, Inc. hat die pgEdge Platform v24.7 veröffentlicht, bekannt als das Constellation Release, das fortschrittliche logische Replikationsfunktionen von Postgres einführt. Zu den wichtigsten Verbesserungen gehören:
1. Logische Replikation großer Objekte (LOLOR) für die Medienkompatibilität
2. Verbesserte Umgang mit Replikationsausnahmen und Logging
3. Neuer Reparaturmodus für die Replikation für mehr Kontrolle
4. Automatische Replikation von DDL-Befehlen
5. Snowflake-Sequenz in der Postgres-Erweiterung für einzigartige Sequenzierung
Das Unternehmen kündigte außerdem kommende Parallel-Replikations Funktionen für das vierte Quartal an und verspricht eine höhere Replikationsdurchsatz. Die pgEdge Platform bietet eine verteilte PostgreSQL-Lösung mit Multi-Master-Fähigkeit, die die Latenz verringert und eine hohe Verfügbarkeit in verschiedenen geografischen Regionen sichert.
- 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
- None.
Insights
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.
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
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
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?
When will pgEdge introduce Parallel Replication features?
How does pgEdge Platform v24.7 improve large object support?
What benefits does the new replication repair mode in pgEdge Platform v24.7 offer?
