| From: | Prince Pathria <prince(dot)pathria(at)goevive(dot)com> |
|---|---|
| To: | soumitra bhandary <soumitra(dot)bhandary(at)hotmail(dot)com> |
| Cc: | "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>, "pgadmin-support(at)lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Load balancing in postgres master slave HA cluster |
| Date: | 2019-02-19 09:20:57 |
| Message-ID: | CAON0DawMF6Q9S8eTc_n7ofJdYGzMmNafH+9Z=ciKwiZyNqjoBA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support pgsql-admin |
Use pgpool to achieve query balancing. It can send inserts/updates etc to
master and selects to all nodes.
Flow: app_server(app+pgpool) -> db_servers(pg_master +pg_slave1+pg_slave2)
Happy to help :)
Prince Pathria Systems Architect Intern Evive +91 9478670472 goevive.com
On Tue, Feb 19, 2019 at 2:44 PM soumitra bhandary <
soumitra(dot)bhandary(at)hotmail(dot)com> wrote:
> Hi ,
>
> Any one has experience on working with HA proxy set up with Postgres
> Master Slave replication .
>
> Query : I would like to divert the Write requests to Master and all read
> requests to Slave server .
>
> To achieve that can I use HA proxy server ? If any one has already
> implemented the same . Please share me the steps .
>
> Or ,
>
> Any other method can be used to achieve the same using freeware .
>
> Thanks
> Soumitra
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shreeyansh Dba | 2019-02-19 09:40:56 | Re: Load balancing in postgres master slave HA cluster |
| Previous Message | soumitra bhandary | 2019-02-19 09:13:51 | Load balancing in postgres master slave HA cluster |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shreeyansh Dba | 2019-02-19 09:40:56 | Re: Load balancing in postgres master slave HA cluster |
| Previous Message | soumitra bhandary | 2019-02-19 09:13:51 | Load balancing in postgres master slave HA cluster |