再提mysql-proxy读写分离脚本（rw-splitting.lua）BUG问题

nianzong

如题，这个问题在本版帖子：
MYSQl Proxy 多连接的错误can't change DB to on slave (已解决)
http://bbs.chinaunix.net/thread-1104131-1-1.html

根据文章的方法修改了脚本，确实在客户端没有再出现这个问题。不过我在进行压力测试（mysqlslap）时，仍然出现错误，而单独对某个数据库直接测试则正常。
mysql-proxy：192.168.3.19
master：192.168.3.21
slave：192.168.3.22

./mysqlslap -a -uadmin -p29019853 -h 192.168.3.19 -P3306 --concurrency=30 --number-of-queries=100 --debug-info
./mysqlslap: Cannot run query INSERT INTO t1 VALUES (1804289383,'mxvtvmC9127qJNm06sGB8R92q2j7vTiiITRDGXM9ZLzkdekbWtmXKwZ2qG1llkRw5m9DHOFilEREk3q7oce8O3BEJC0woJsm6uzFAEynLH2xCsw1KQ1lT4zg9rdxBL') ERROR : No database selected
这是不是说明rw-splitting.lua脚本仍然还有BUG呢？

[ 本帖最后由 nianzong 于 2008-12-26 15:49 编辑 ]

枫影谁用了

那个只能解决连接的问题。

分离的脚本本版的KDr2发过一个，不错的。

枫影谁用了

刚帮你搜索了一下，这个贴子。

http://bbs.chinaunix.net/viewthr ... p;page=1#pid9347176

yoyoo1625

KDr2的脚本 已经得到论证成功:wink:  应用正常

radkitty

请问这个脚本是运行在哪个版本下面的？
我现在的版本是：
mysql-proxy 0.7.2
  glib2: 2.16.6
  libevent: 1.4.6-stable
  lua: Lua 5.1.2
    LUA_PATH: /usr/local/mysql-proxy/lib/mysql-proxy/lua/?.lua
    LUA_CPATH: /usr/local/mysql-proxy/lib/mysql-proxy/lua/?.so
  == plugins ==
  admin: 0.7.0
  proxy: 0.7.0


登录后执行use databaes 会提示出错：
mysql> show databases;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    173
Current database: *** NONE ***

ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql> show databases;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    174
Current database: *** NONE ***

ERROR 2013 (HY000): Lost connection to MySQL server during query

日志文件：
2011-12-14 15:36:50: (critical) (read_query) [string "/usr/local/mysql-proxy/script/rw-splitting...."]:129: attempt to get length of field 'backends' (a nil value)
2011-12-14 15:36:50: (critical) proxy-plugin.c.1129: I have no server backend, closing connection
2011-12-14 15:36:50: (critical) network-mysqld.c.1188: plugin_call(CON_STATE_READ_QUERY) failed
2011-12-14 15:36:50: (debug) [network-mysqld.c:784]: error on a connection (fd: -1 event: 0). closing client connection.
2011-12-14 15:36:50: (critical) proxy-plugin.c.1684: (disconnect_client) [string "/usr/local/mysql-proxy/script/rw-splitting...."]:195: attempt to get length of field '
backends' (a nil value)
2011-12-14 15:36:57: (critical) proxy-plugin.c:1389: (connect_server) [string "/usr/local/mysql-proxy/script/rw-splitting...."]:47: attempt to get length of field 'back
ends' (a nil value)
2011-12-14 15:36:57: (critical) (read_query) [string "/usr/local/mysql-proxy/script/rw-splitting...."]:129: attempt to get length of field 'backends' (a nil value)
2011-12-14 15:36:57: (critical) proxy-plugin.c.1129: I have no server backend, closing connection
2011-12-14 15:36:57: (critical) network-mysqld.c.1188: plugin_call(CON_STATE_READ_QUERY) failed
2011-12-14 15:36:57: (debug) [network-mysqld.c:784]: error on a connection (fd: -1 event: 0). closing client connection.
2011-12-14 15:36:57: (critical) proxy-plugin.c.1684: (disconnect_client) [string "/usr/local/mysql-proxy/script/rw-splitting...."]:195: attempt to get length of field '
backends' (a nil value)