Hi Sumitra,
You can achieve this by using the pgpool which support load balancing/load
connections and allow huge insert/updates. Either you can divert your read
queries to slave for read and write to master for read/write operations
Thanks & Regards,
*Shreeyansh DBA Team*
www.shreeyansh.com
On
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
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 .
