BDR, limit number of groups in a cluster
Hi all,
Based on the docs and look at the processes, it seems 1 wal sender on each
node per group.
If there is scenario of consolidating many databases (say hundreds) into 1
database (in this central cluster there are hundreds wal sender), what is
the limit number of groups?
I wonder if anyone has runs such the scenario?
--
regards
ujang jaenudin | DBA Consultant (Freelancer)
http://ora62.wordpress.com
http://id.linkedin.com/pub/ujang-jaenudin/12/64/bab
On 11 September 2017 at 09:32, milist ujang <ujang.milist@gmail.com> wrote:
Hi all,
Based on the docs and look at the processes, it seems 1 wal sender on each
node per group.If there is scenario of consolidating many databases (say hundreds) into 1
database (in this central cluster there are hundreds wal sender), what is
the limit number of groups?
It's not a use case I've paid much attention to. I expect it'll be limited
by performance and memory, rather than have any firm limit.
Maybe you should look into pglogical. This seems like a weird use for BDR.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services