关于mysql-proxy错误的问题

wbftp

mysql      主 192.168.1.77
mysql      从 192.168.1.78
mysql-proxy 192.168.1.79

mysql-proxy 下载的是mysql-proxy-0.7.2-linux-rhel5-x86-32bit 二进制包

mysql-prpxy启动参数:
mysql-proxy \
--proxy-read-only-backend-addresses=192.168.1.78:3306 \
--proxy-backend-addresses=192.168.1.77:3306 \
--proxy-lua-script=/usr/local/share/mysql-proxy/rw-splitting.lua \
--log-file=/var/log/mysql-proxy.log \
--keepalive &

使用Navicat Lite for MySQL，SQL Manager for MySQL 等客户端软件连接mysql-proxy 提示no data select

使用mysql自带的连接可以。mysql -h192.168.1.79 -uvhost -P4040 -p
有时候经常出现mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| vhost            |
| test               |
+--------------------+
3 rows in set (0.00 sec)

mysql> show databases;
ERROR 1046 (3D000): No database
mysql> show databases;
ERROR 2006 (HY000): MySQL serve
No connection. Trying to reconn
Connection id:    4210
Current database: *** NONE ***
-------------------------------------------------------------
mysql-proxy服务器报错误

2009-12-11 17:18:57: (critical) proxy-plugin.c:259: read_query_result() in /usr/local/share/mysql-proxy/rw-splitting.lua tries to modify the resultset, but hasn't asked to buffer it in proxy.query:append(..., { resultset_is_needed = true }). We ignore the change to the result-set.
2009-12-11 17:18:57: (critical) proxy-plugin.c:1238: proxy.queries:append() in /usr/local/share/mysql-proxy/rw-splitting.lua can only have one injected query without { resultset_is_needed = true } set. We close the client connection now.

client default db: vhost
    syncronizing
    server default db:



请问一下，是不是rw-splitting.lua 脚本的问题啊。谢谢大家!

justlooks

proxy.query:append这个函数改了，脚本还是老版本，就这个问题，看下官方网站的说明