| From: | Jaime Casanova <jaime(at)2ndquadrant(dot)com> |
|---|---|
| To: | Nikolay Morozov <nmorozoffap(at)gmail(dot)com> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Database replication to 50-80 nodes |
| Date: | 2013-10-03 04:47:15 |
| Message-ID: | CAJKUy5iKy7BBcmckJ+K5Xs4MRTem7OsgtsdQ4w1rRDfv7wvf9Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Wed, Oct 2, 2013 at 3:20 AM, Nikolay Morozov <nmorozoffap(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rajagopalan, Jayashree | 2013-10-03 14:00:59 | postgres connections in IDLE state.. |
| Previous Message | Sergey Konoplev | 2013-10-03 01:57:34 | Re: Database replication to 50-80 nodes |