Thread: [GENERAL] BDR, limit number of groups in a cluster

[GENERAL] BDR, limit number of groups in a cluster

From

milist ujang

Date:

11 September 2017, 07:32:10

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

Re: [GENERAL] BDR, limit number of groups in a cluster

From

Craig Ringer

Date:

11 September 2017, 07:55:29

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