Load Balancing & High Availability on Postgres using HAProxy | Vignesh Ravichandran

[@陈靖珏]

At 9:54 in the video, should the “dbserver1” following the addr in the config file be “dbserver1IP”?

[@fabiochamorro4663]

How can I implement a read/write splitting in Haproxy? I'm also using pgbouncer, but I haven't been able to split the read and write request in the haproxy.cfg. I can't modify the request from the client part so I need to modify Haproxy or pgbouncer. Thanks in advanced for any comment/suggestion.

[@HAProxyTechnologies]

The answer is "you can't", this must be done at the application layer and have an haproxy config which reflect this.