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
