Re: Load balancing in postgres master slave HA cluster

Поиск
Список
Период
Сортировка
От Prince Pathria
Тема Re: Load balancing in postgres master slave HA cluster
Дата
Msg-id CAON0DawMF6Q9S8eTc_n7ofJdYGzMmNafH+9Z=ciKwiZyNqjoBA@mail.gmail.com
обсуждение исходный текст
Ответ на Load balancing in postgres master slave HA cluster  (soumitra bhandary <soumitra.bhandary@hotmail.com>)
Список 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.bhandary@hotmail.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 

В списке pgsql-admin по дате отправления:

Предыдущее
От: soumitra bhandary
Дата:
Сообщение: Load balancing in postgres master slave HA cluster
Следующее
От: Shreeyansh Dba
Дата:
Сообщение: Re: Load balancing in postgres master slave HA cluster