mysql mmm proxy_mysql proxy+mysql-mmm遇到问题

测试环境：

mysql A：192.168.128.6  master

mysql B：192.168.128.7  master

mysql proxy+mysql-mmm：192.168.128.5

数据库写操作：192.168.128.8

数据库读操作：192.168.128.9,192.168.128.10

mysql proxy和mysql-mmm都已经正常启动，在客户端连接时提示错误：

[root@mysql log]# mysql -u proxy -h 192.168.128.5 -P4040

ERROR 1105 (HY000): (proxy) all backends are down

mysql proxy配置文件：

[mysql-proxy]

user=root

proxy-address=192.168.128.5:4040

proxy-read-only-backend-addresses=192.168.128.9:3306

proxy-read-only-backend-addresses=192.168.128.10:3306

proxy-backend-addresses=192.168.128.8:3306

proxy-lua-script=/usr/local/mysql-proxy/scripts/rw-splitting.lua

log-file=/usr/local/mysql-proxy/log/mysql-proxy.log

log-level=debug

daemon=true

mysql proxy日志：

2012-09-18 15:34:52: (critical) proxy-plugin.c.1773: Cannot connect, all backends are down.

2012-09-18 15:43:44: (debug) network-backend.c.184: backend 192.168.128.8:3306 was down for more than 4 sec, waking it up

2012-09-18 15:43:44: (debug) network-backend.c.184: backend 192.168.128.9:3306 was down for more than 4 sec, waking it up

2012-09-18 15:43:46: (debug) proxy-plugin.c:221: connecting to 192.168.128.8:3306 timed out after 2.00 seconds. Trying another backend.

2012-09-18 15:43:48: (debug) proxy-plugin.c:221: connecting to 192.168.128.9:3306 timed out after 2.00 seconds. Trying another backend.

2012-09-18 15:43:48: (critical) proxy-plugin.c.1773: Cannot connect, all backends are down.

mysql-mmm状态：

[root@centos scripts]# mmm_control show

db1(192.168.128.6) master/ONLINE. Roles: reader(192.168.128.9), writer(192.168.128.8)

db2(192.168.128.7) master/ONLINE. Roles: reader(192.168.128.10)

求高手解答

分享至：