On Fri, Jun 14, 2024 at 12:08:51PM +0000, Smith, Travis wrote: > Hello Beautiful People, > > > > I have a question regarding a good performing BDR system for Postgres. I am > currently evaluating/prototyping a primary-primary/master-master replication > system. I have a question around the experience held by the community at > large. Has anyone worked in a production environment with a solid BDR > platform that performs well? I am currently testing SymmetricDS but I am > worried about a few things although the feature set is salivating. > > > > Any hints to other software would be great, the organization has budget cap to > bring a talented consultant or consultant firm in to fulfill an advisory role. > > So far I have reviewed: > > Greenplum -- always lagging in version > > PG 16 logical replication – very basic – manual conflict resolution. > > SymmetricDS – trigger based replication > > EDB BDR (PGD) – not an option at this time Well, I think you have the right data above. There isn't much demand for multi-master in the community because the usefulness of it is limited; see: https://momjian.us/main/blogs/pgblog/2018.html#December_24_2018 We are working on expanding logical replication to handle DDL changes and conflicts, but that work is a few years away from completion. -- Bruce Momjian <bruce@xxxxxxxxxx> https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.
