采用MySQL-Proxy进行读写分离时的一点疑问

今天在采用MySQL-Proxy0.8.3测试读写分离时，功能都正常，但出现了一些让人有些疑惑的提示信息，不太确定算不算异常。。。。。。配置文件“/usr/local/mysql-pro

今天在采用 MySQL-Proxy 0.8.3 测试读写分离时，，功能都正常，但出现了一些让人有些疑惑的提示信息，

不太确定算不算异常。。。。。。

配置文件“/usr/local/mysql-proxy/etc/mysql-proxy.cnf”如下：

[mysql-proxy]basedir = /usr/local/mysql-proxydaemon = truekeepalive = trueproxy-address = 0.0.0.0:3306max-open-files = 65535proxy-fix-bug-25371 = trueevent-threads = 8proxy-backend-addresses = 10.222.5.224:3306proxy-read-only-backend-addresses = 10.137.23.179:3306plugin-dir = /usr/local/mysql-proxy/lib/mysql-proxy/pluginsplugins = admin,proxyadmin-lua-script = /usr/local/mysql-proxy/lib/mysql-proxy/lua/admin.luaproxy-lua-script = /usr/local/mysql-proxy/lib/mysql-proxy/lua/rw-splitting.luaadmin-address = 10.209.6.102:3307admin-username = rootadmin-password = 123456pid-file= /usr/local/mysql-proxy/run/mysql-proxy.pidlog-file = /usr/local/mysql-proxy/log/mysql-proxy.loglog-level = warning

：

#!/bin/sh## mysql-proxy This script starts and stops the mysql-proxy daemon## chkconfig: – 78 30# processname: mysql-proxy# description: mysql-proxy is a proxy daemon to mysql# config: /usr/local/mysql-proxy/etc/mysql-proxy.cnf# pidfile: /usr/local/mysql-proxy/run/mysql-proxy.pid#PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/binDAEMON=”/usr/local/mysql-proxy/bin/mysql-proxy”CONFIGFILE=”/usr/local/mysql-proxy/etc/mysql-proxy.cnf”PIDFILE=”/usr/local/mysql-proxy/run/mysql-proxy.pid”LOCKFILE=”/var/lock/subsys/mysql-proxy”PROG=`basename $DAEMON`RETVAL=0start() {echo -n $”Starting ${PROG}……”[ -x $DAEMON ] || exit 5[ -f $CONFIGFILE ] || exit 6${DAEMON} –defaults-file=${CONFIGFILE} || echo -n “${PROG} already running”RETVAL=$?echo[[ $RETVAL -eq 0 ]] && touch $LOCKFILEreturn $RETVAL}stop() {echo -n $”Stopping ${PROG}……”if [[ `ps aux | grep bin/mysql-proxy | grep -v grep | wc -l` -gt 0 ]]; thenkill -TERM `ps -A -oppid,pid,cmd | grep bin/mysql-proxy | grep -v grep | awk ‘{print $2}’`fiRETVAL=$?echo[[ $RETVAL -eq 0 ]] && rm -f $LOCKFILE $PIDFILEreturn $RETVAL}restart() {stopsleep 1start}case “$1” instart)start;;stop)stop;;restart)restart;;condrestart)[[ -e $LOCKFILE ]] && restart;;*)echo “Usage: $0 {start|stop|restart|condrestart}”RETVAL=1;;esacexit $RETVAL

WIFSIGNALED(status)
returns true if the child process exited because of a signal which was not caught.本文来源gaodaimacom搞#代%码@网-

也就是说，如果是因为子进程未能正常捕获信号而退出时，就返回true。

更详细的描述，可以参考这里（服务器开发之 Daemon 和 Keepalive）：

目前针对此类的提示信息，还不太确定是否属于异常，希望各位多提些建议。。。。。。

喜欢 (0)赏

[搞代码]

分享 (0)