mysql proxy 2讀調(diào)度不生效

a6447

1、 /opt/mysql-proxy/bin/mysql-proxy --defaults-file=/opt/mysql-proxy/conf/mysql-proxy.conf來(lái)啟動(dòng)proxy的時(shí)候：寫沒問(wèn)題，但是讀總是會(huì)調(diào)給213這一臺(tái)機(jī)器，如果213的mysql關(guān)閉之后，讀才會(huì)調(diào)給215.當(dāng)213重新上線，讀請(qǐng)求還是只調(diào)給215.   不知是不是要達(dá)到一線的鏈接數(shù)，讀請(qǐng)求才會(huì)輪詢調(diào)度。

2、lua腳本用的是proxy自帶的，就改了下
min_idle_connections = 1,
max_idle_connections = 1,

期望效果：讀請(qǐng)求能夠輪詢調(diào)度到213和218，寫調(diào)度給215；

======================================================
mysql-proxy.conf
[mysql-proxy]
daemon=true
pid-file=/opt/mysql-proxy/mysql-proxy.pid
log-file=/opt/mysql-proxy/mysql.log
log-level=debug

LUA_PATH="/opt/mysql-proxy/lib/mysql-proxy/lua/?.lua"
proxy-lua-script=/opt/mysql-proxy/share/doc/mysql-proxy/rw-splitting.lua

proxy-address=172.18.21.212:3306
proxy-read-only-backend-addresses=172.18.21.213:3306,172.18.21.218:3306
proxy-backend-addresses=172.18.21.215:3306

keepalive=true
proxy-skip-profiling=true
admin-address=:4041

mysql.log
2013-12-11 14:58:44: (debug) chassis-unix-daemon.c:157: waiting for 4951
2013-12-11 14:58:44: (message) mysql-proxy 0.8.2 started
2013-12-11 14:58:44: (debug) max open file-descriptors = 1024
2013-12-11 14:58:44: (message) proxy listening on port 172.18.21.212:3306
2013-12-11 14:58:44: (message) added read/write backend: 172.18.21.215:3306
2013-12-11 14:58:44: (message) added read-only backend: 172.18.21.213:3306
2013-12-11 14:58:44: (message) added read-only backend: 172.18.21.218:3306