2ndQuadrant is pleased to announce the availability of pglogical, the next generation in replication systems for PostgreSQL.
pglogical offers Logical Replication as a PostgreSQL extension, which provides the flexibility of trigger-based replication with the efficiency of log-based replication. This ground-breaking new technology has benefits for many key use cases, including:
- UPGRADE Upgrade PostgreSQL from 9.4 to 9.5, without downtime
- SCALE OUT Copy all or a selection of database tables to other nodes in a cluster
- AGGREGATE Accumulate changes from sharded database servers into a Data Warehouse
- INTEGRATE Feed database changes in real-time to other systems
- PROTECT Provide backup or high availability for clusters, replacing earlier technologies
Existing PostgreSQL users will find the efficiency of pglogical particularly exciting with preliminary testing demonstrating a significant increase in transaction throughput (without lag) over other replication methods. For example, pglogical performed up to 5 times faster than Slony and Londiste3 on OLTP workloads using pgbench .
For more details and access to binary packages for both the current stable release PostgreSQL 9.4 and the soon to be announced PostgreSQL 9.5 version, visit http://2ndquadrant.com/pglogical/
- Download PostgreSQL
- View Press Release
- Visit PostgreSQL
|