BDR that performs

[Smith, Travis]

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




Thank you in advance,

[cid:image001.jpg@01DABD84.CDF83720]
Travis Smith
VP Business Technology
Circana

travis.sm...@circana.com
C: 773.349.1415
203 North LaSalle Street, Suite 1500

circana.com 
LinkedIn 
Twitter 
Facebook 
YouTube 
Instagram

We Are Now Circana! IRI and NPD have come together to form Circana, the world's 
leading advisor on the complexity of consumer behavior. Learn 
more.

Re: BDR that performs

[Bruce Momjian]

On Fri, Jun 14, 2024 at 12:08:51PM +, 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  https://momjian.us
  EDB  https://enterprisedb.com

  Only you can decide what is important to you.

Re: BDR that performs

[Hari Kiran]

Hi Travis,

On Fri, Jun 14, 2024 at 5:39 PM 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
>

One alternative you might consider is pgEdge Platform. Specifically
tailored for robust PostgreSQL MMR replication and high availability
scenarios. pgEdge offers comprehensive support and extensive documentation,
which could be beneficial for your current evaluation and prototyping phase.

See https://docs.pgedge.com/ for more info.

>
>
>
>
>
>
>
>
> Thank you in advance,
>
>
>
> *Travis Smith*
>
> VP Business Technology
>
> Circana
>
>
>
> travis.sm...@circana.com
>
> C: 773.349.1415
>
> 203 North LaSalle Street, Suite 1500
>
>
>
> circana.com  LinkedIn
>  Twitter
>  Facebook
>  YouTube
>  Instagram
> 
>
>
>
> *We Are Now Circana! *IRI and NPD have come together to form Circana, the
> world’s leading advisor on the complexity of consumer behavior. Learn
> more.
> 
>
>
>

Re: BDR that performs

[P C]

Hello Travis,

We have had this requirement (true BDR that also handles DDLs & Conflict
Resolution) and have been researching the options for a long time and I'll
send you more details soon, but meanwhile curious to understand why EDB BDR
is not an option?

Thanks

On Fri, 14 Jun 2024 at 17:39, 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
>
>
>
>
>
>
>
>
>
> Thank you in advance,
>
>
>
> *Travis Smith*
>
> VP Business Technology
>
> Circana
>
>
>
> travis.sm...@circana.com
>
> C: 773.349.1415
>
> 203 North LaSalle Street, Suite 1500
>
>
>
> circana.com  LinkedIn
>  Twitter
>  Facebook
>  YouTube
>  Instagram
> 
>
>
>
> *We Are Now Circana! *IRI and NPD have come together to form Circana, the
> world’s leading advisor on the complexity of consumer behavior. Learn
> more.
> 
>
>
>

Re: BDR that performs

[Bruce Momjian]

On Fri, Jun 14, 2024 at 06:11:53PM +0530, P C wrote:
> Hello Travis,
> 
> We have had this requirement (true BDR that also handles DDLs & Conflict
> Resolution) and have been researching the options for a long time and I'll 
> send
> you more details soon, but meanwhile curious to understand why EDB BDR is not
> an option?

I agree pgEdge is worth considering:

https://www.pgedge.com/products/pgedge-platform

and perhaps EDB BDR/PGD was not being considered due to cost.

-- 
  Bruce Momjian  https://momjian.us
  EDB  https://enterprisedb.com

  Only you can decide what is important to you.