pglogical announced

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:

*             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

 

--

Howard Rolph 

 <http://www.2ndquadrant.com/> http://www.2ndQuadrant.com/ 

PostgreSQL Development, 24x7 Support, RemoteDBA, Training & Services


-- 
Sent via pgsql-announce mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-announce