Postgres BDR EOL

[sudoRmRf]

With Postgres BDR end of life this month is there a recommended way to continue doing Multi-Master replication with Postgres?

 

[DigitalDaz]

Just keep using it.

 

[sudoRmRf]

So I am not the one making these decisions, my boss is and I am tasked with finding an alternative for our new cluster build. Is there a reason as to why it is okay to continue using BDR that I can report back with?

 

[sudoRmRf]

I underestimated my superiors willingness to accept this as an answer. That being said is there any replacement for BDR in the roadmap for Fusion? I recall Mark saying in one of his Advanced Classes videos that he was working on something to replace BDR, but I can find nothing at all about alternatives.

 

[ad5ou]

The best answer to report back with "why keep using it" is because it will keep working.

Mark has mentioned several times he planned on finding an alternative replication method but has not shared any progress.

I haven't tried it yet but Bucardo might work as an alternative.

 

[ad5ou]

OR pglogical https://github.com/2ndQuadrant/pglogical maybe

 

[markjcrane]

Bucardo replication last I heard used triggers if they still are then its likely to be a slower than BDR.

 

[DigitalDaz]

I don't understand why the 'EOL' tag means anything in this context. I have BDR running since 2015 and have never had to touch it. We have to use an old version of Postgres in order to use it anyway. Though I have never used it, I do see a number of voices raising the question of Galera.

With regards to BDR, apart from a typo in an error message that was fixed, BDR 1 hasn't been touched since April anyway.

 

[markjcrane]

I underestimated my superiors willingness to accept this as an answer. That being said is there any replacement for BDR in the roadmap for Fusion? I recall Mark saying in one of his Advanced Classes videos that he was working on something to replace BDR, but I can find nothing at all about alternatives.

Yes its definitely on the roadmap. We should be able to keep using BDR until then.

 

[KonradSC]

I found this post. I'm curious if this would work for a BDR replacement.

http://eradman.com/posts/active-active-pglogical.html