mysqlproxy0.8版本读写分离测试总结

虽说&＃xff0c;mysql-proxy0.8版本出来的时候&＃xff0c;标榜自己解决了哪些问题&＃xff0c;但是根据我实际测试的情况&＃xff0c;测试过程中还有重启的记录&＃xff0c;

测试环境3台64位centos5.4虚拟机:

192.168.0.26 mysql-proxy

192.168.0.24 mysql-master

192.168.0.10 mysql-slave

启动debug模式&＃xff0c;修改后的rw-splitting.lua&＃xff0c;在终端我们会看到以下提示信息&＃xff1a;

简单的通过命令行&＃xff0c;测试一下&＃xff0c;

通过终端可以显示

代码

[root&＃64;sunss-26 ~]# sh mysql-proxy.sh
[root&＃64;sunss-26 ~]#
[connect_server] 192.168.0.26:46062
[1].connected_clients &＃61; 0
[1].pool.cur_idle &＃61; 0
[1].pool.max_idle &＃61; 8
[1].pool.min_idle &＃61; 4
[1].type &＃61; 1
[1].state &＃61; 0
[1] idle-conns below min-idle
[read_query] 192.168.0.26:46062
current backend &＃61; 0
client default db &＃61;
client username &＃61; root
query &＃61; select &＃64;&＃64;version_comment limit 1
sending to backend : 192.168.0.24:3306
is_slave : false
server default db:
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true

[connect_server] 192.168.0.26:46064
[1].connected_clients &＃61; 0
[1].pool.cur_idle &＃61; 0
[1].pool.max_idle &＃61; 8
[1].pool.min_idle &＃61; 4
[1].type &＃61; 1
[1].state &＃61; 1
[1] idle-conns below min-idle
[read_query] 192.168.0.26:46064
current backend &＃61; 0
client default db &＃61;
client username &＃61; root
query &＃61; select &＃64;&＃64;version_comment limit 1
sending to backend : 192.168.0.24:3306
is_slave : false
server default db:
server username : root
in_trans : false
in_calc_found : false
COM_QUERY : true

出现的问题是&＃xff1a;

1.在命令端&＃xff0c;输入命令后无响应&＃xff0c;查看日志&＃xff0c;显示&＃xff1a;

代码

2010-10-28 23:29:24: (critical) network-mysqld.c:510: received packet-id 0, but expected 3 ... out of sync.
2010-10-28 23:29:24: (critical) network-mysqld.c.1254: network_mysqld_read(CON_STATE_READ_QUERY) returned an error

2.使用压力测试工具测试&＃xff0c;跟踪表明mysql-proxy创建的子进程无法退出&＃xff0c;导致进程挂起&＃xff0c;别连接要么连接失败&＃xff0c;要么连接没响应&＃xff0c;如果连接越来越过&＃xff0c;这些堆积的子进程也会越来越多&＃xff0c;资源无法释放&＃xff08;kill&＃xff0c;或者CTRL&＃43;C除外&＃xff09;

3.读写分离倒是可以做到的&＃xff0c;但是目前mysql-proxy目前还不支持预编译语句&＃xff08;prepare statement&＃xff09;

       最后总结下吧&＃xff0c;mysql-proxy还是不够稳定&＃xff0c;大家遇到这种情况是怎么处理的&＃xff0c;不妨说出来&＃xff0c;呵呵