Next generation PostgreSQL replication with pglogical 3 and BDR 3
Presented by:
Peter Eisentraut
Peter has been a contributor to PostgreSQL development since 1999. He is a committer, core team member, and is involved in many aspects of the community.
He works at 2ndQuadrant, a global service and support provider for PostgreSQL.
No video of the event yet, sorry!
This talk will present the PostgreSQL replication solutions pglogical 3 and BDR 3.
pglogical is a PostgreSQL extension for logical replication between two nodes. Most of the code for built-in logical replication in PostgreSQL 10 was derived from pglogical, while pglogical offers a larger feature set, such as row and column filtering, conflict resolution, and compatibility back to PostgreSQL 9.4. The new major release pglogical 3 was rearchitected to support even more functionality including failover support, improved table synchronization, and Kafka integration.
BDR is a PostgreSQL extension for asynchronous multimaster replication. The upcoming BDR 3 was completely reengineered and built on top of pglogical 3. It will support multiple consistency models, new node management, and transparent DDL replication.
- Date:
- 2018 April 20 10:50 EDT
- Duration:
- 50 min
- Room:
- Enterprise
- Conference:
- PostgresConf US 2018
- Language:
- English
- Track:
- Operations and Administration
- Difficulty:
- Medium