Re: R/W splitting. All requests only to write server.

[Emmanuel Dyan]

Hello,

I am facing the same issue than Pavel but it's mandatory for me to send each and every read request to the slave which is located in Asia and write request to the master.. No read should be done on the master

I have the version 0.7.2. I have tested with the standard rw-splitting.lua file by changing min_idle_connections from 4 to 0 but no effect :(

I launch the proxy with :
mysql-proxy --pid-file=/var/run/mysql-proxy.pid --proxy-lua-script /share/doc/mysql-proxy/rw-splitting.lua --proxy-read-only-backend-addresses=localhost:3306 --proxy-backend-addresses=master:3306

Does anybody knows a solution ?
Thanks