[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: [ADMIN] Database replication to 50-80 nodes
From:       Jaime Casanova <jaime () 2ndquadrant ! com>
Date:       2013-10-03 4:47:15
Message-ID: CAJKUy5iKy7BBcmckJ+K5Xs4MRTem7OsgtsdQ4w1rRDfv7wvf9Q () mail ! gmail ! com
[Download RAW message or body]

On Wed, Oct 2, 2013 at 3:20 AM, Nikolay Morozov <nmorozoffap@gmail.com> wrote:
> Can I you database Master-Slave replication on cluster with 50-80 nodes.
> Database is small (configuration), changed rarely. If there any problems
> with such nodes count.
> One master other slaves.

Yes, you can... just set max_wal_senders to the maximum number of
nodes you plan to have.
Because the slave is the one connecting to the master and requesting
the info it needs, the master get hurts very low -if any- for every
standby so you can have effectivelly a lot of them.

Still, the question remains... you really need so many standbys?

-- 
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
Phone: +593 4 5107566         Cell: +593 987171157


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
[prev in list] [next in list] [prev in thread] [next in thread]