3 ms·
As the linked page doesn't describe what it is: Bi-Directional Replication for PostgreSQL (Postgres-BDR, or BDR) is an asynchronous multi-master replication sys
by sinatra 10y ago
As the linked page doesn't describe what it is: Bi-Directional Replication for PostgreSQL (Postgres-BDR, or BDR) is an asynchronous multi-master replication system for PostgreSQL, specifically designed to allow geographically distributed clusters. Supporting more than 48 nodes, BDR is a low overhead, low maintenance technology for distributed databases. [0]
[0]: https://2ndquadrant.com/en/resources/bdr/ https://2ndquadrant.com/en/resources/bdr/
- rattray 10y ago> Supporting more than 48 nodes Hmm, on the mailing list announcement they claim 2-48 nodes. EDIT: perhaps they're referring to support for read-replica's that can go beyond the 48 primaries. https://www.postgresql.org/message-id/CAH%2BGA0qO0q9NJhKxaoo8CV-QR9Cuw6LtDGDb33pq16rU88F_dA%40mail.gmail.com https://www.postgresql.org/message-id/CAH%2BGA0qO0q9NJhKxaoo...
- pgaddict 10y agoAFAIK there's no explicit limit per se - the BDR developers tested it with 48 nodes, but it will work with more nodes. But there are things you'll probably run into - for example this only supports full mesh topology, i.e. each node speaks to every other node. So the more nodes you have, the higher the number of management connections.