Postgres-BDR Archives - Page 3 of 4 - 2ndQuadrant

Posts

When to use Postgres-BDR or Postgres-XL?

August 25, 2016/0 Comments/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon Riggs

The right answer is of course “Use PostgreSQL”. It’s the main distro and we want you to use that as often as possible. The Postgres-BDR and Postgres-XL projects are also fully open source projects, using the same copyright and licence as the main PostgreSQL project. So if you’re using PostgreSQL, they are also options to […]

Postgres-BDR: 2 Years in Production

August 18, 2016/0 Comments/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon Riggs

Postgres-BDR has now reached 1.0 production status. Over the last 2 years, Postgres-BDR has been used daily for mission critical production systems. As you might imagine, it’s been improved by both bug fixes and feature enhancements that allow it to be used smoothly, so its mature, robust and feature-rich. The BDR Project introduced logical replication […]

BDR 1.0

August 12, 2016/7 Comments/in Craig's PlanetPostgreSQL /by craig.ringer

I’m pleased to say that we’ve just released Postgres-BDR 1.0, based on PostgreSQL 9.4.9. This release contains significant improvements to DDL replication locking, global sequences, documentation, performance, and more. It also removes the deprecated UDR component in favour of

PostgreSQL Solutions Roadmap

August 5, 2016/0 Comments/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon Riggs

In a recent blog, I described features for PostgreSQL Core that we’ve been working on https://www.2ndquadrant.com/en/blog/postgresql-solutions-roadmap/ Many people have asked for a similar roadmap for BDR and Postgres-XL. I can confirm that both are under active development and in active use. Postgres-XL (link) XL 9.5 v1.2 is now available, with more updates coming. XL 9.6 […]

The Physics of Multi-Master

January 8, 2016/4 Comments/in Simon's PlanetPostgreSQL /by Simon Riggs

If you try to update the same data at the same time in multiple locations, your application has a significant problem, period. That’s what I call the physics of multi-master. How that problem manifests itself is really based upon your choice of technology. Choosing Postgres, Oracle or ProblemoDB won’t change the problem, just gives you […]

When are we going to contribute BDR to PostgreSQL?

December 4, 2015/10 Comments/in Craig's PlanetPostgreSQL /by craig.ringer

My colleagues and I are often asked “when will you (2ndQuadrant) contribute BDR to PostgreSQL?” This makes an interesting assumption: that we have not already done so. We have. Much of BDR has already been contributed to core PostgreSQL, with more to come. All of BDR is under the PostgreSQL license and could be merged […]

BDR 0.9.2 and BDR-PostgreSQL 9.4.4 released

July 8, 2015/2 Comments/in Craig's PlanetPostgreSQL /by craig.ringer

Version 0.9.2 of the BDR (Bi-Directional Replication) extension for PosgreSQL has been released. This is a maintenance release in the current stable 0.9.x series, focused on bug fixes, stability and usability improvements. In particular bdr_init_copy, the pg_basebackup-based node bring-up tool, is significantly improved in this update. This release also updates the BDR-patched version of PostgreSQL […]

Dynamic SQL-level configuration for BDR 0.9.0

March 20, 2015/1 Comment/in Craig's PlanetPostgreSQL /by craig.ringer

The BDR team has recently introduced support for dynamically adding new nodes to a BDR group from SQL into the current development builds. Now no configuration file changes are required to add nodes and there’s no need to restart the existing or newly joining nodes. This change does not appear in the current 0.8.0 stable […]

BDR for PostgreSQL: Present and future

December 8, 2014/11 Comments/in Craig's PlanetPostgreSQL /by craig.ringer

For a couple of years now a team at 2ndQuadrant led by Andres Freund have been working on adding bi-directional asynchronous multi-master replication support for PostgreSQL. This effort has become known as the BDR project. We’re really excited to see these efforts leading to new PostgreSQL features and have a great deal more still to […]

PostgreSQL 9.4 for administrators (part one)

November 13, 2014/1 Comment/in Francesco's PlanetPostgreSQL /by 2ndQuadrant Press

Version 9.4 of PostgreSQL, soon to be released, has many innovations for administrators, including the introduction of support for logical replication, which is the first step towards the integration of multi-master replication into core PostgreSQL. In this two-part article we will show you the main new features for administrators; we begin with […]

2ndQuadrant is now part of EDB