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.
At 9:54 in the video, should the “dbserver1” following the addr in the config file be “dbserver1IP”?
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.
The answer is "you can't", this must be done at the application layer and have an haproxy config which reflect this.