PostgreSQL BDR

[babak]

Hi
This is one page of Giovanni Maruzzelli presentation:

PostgreSQL BDR
● Bi Directional Replication (BDR) is a new addition by
2ndQuadrant to PostgreSQL. Is being integrated into
mainline and will be in a future official release
● BDR allows for master-master low latency clustering
● BDR automatically replicate new tables and table
modifications
● To use BDR you must have uniq Pks inserted (UUIDs)
● Two ways for doing that from FS

https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=3&cad=rja&uact=8&ved=0ahUKEwjYnuKG5dbWAhVhGsAKHcZ_ATsQFgg4MAI&url=http://opensips.org/pub/events/2016-05-10_OpenSIPS-Summit_Amsterdam/Giovanni_Maruzzelli-OpenSIPS_Summit2016-FreeSWITCH_HA.pdf&usg=AOvVaw2xGbrDZr9oZ4XLGbS0Khqi

It mentioned to use BDR you must have uniq Pks inserted (UUIDs)
1- Freeswitch internal database when used as "odbc or postgresql in the core" has these Pks ?
2- Fusionpbx database has these Pks ?

 

[DigitalDaz]

@babak We have a script to make the freeswitch uuids and yes fusionpbx has uuid, we have been using bdr for a few years now

 

[babak]

@DigitalDaz , Hi As I know you are not fan of loadbalancing single domain over multiple freeswitch servers ( because of call conference, call park, contact center, queue..)
Please read comments part of this blog (when craig answered my question) :
https://blog.2ndquadrant.com/when-are-we-going-to-contribute-bdr-to-postgresql/
Craig One of developers of bdr recommend not using that if not absolutely necessary.My question is in your case why you use bdr instead of other methods.
Thanks

 

[DigitalDaz]

@babak Because as far as I am aware we are doing nothing that will cause the problems he is highlighting, particularly the way I use it now, I do not even replicate freeswitch db, just fusionpbx.

I too have read that post and another where he advises not to use BDR so for example I would never use it in a billing system.

When I do use it for freeswitch, rather than the mcrane method where each fusionpbx has its own db, I make TWO dedicated db servers with BDR and have them always writing to the first and just using the second for failover, all fusionpbx use same db. This probably means it would be just as good though with active/standby.