当前位置:Gxlcms > mysql > 采用MySQL-Proxy进行读写分离时的一点疑问

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

时间:2021-07-01 10:21:17 帮助过:30人阅读

今天在采用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-proxy daemon = true keepalive = true proxy-address = 0.0.0.0:3306 max-open-files = 65535 proxy-fix-bug-25371 = true event-threads = 8 proxy-backend-addresses = 10.222.5.224:3306 proxy-read-only-backend-addresses = 10.137.23.179:3306 plugin-dir = /usr/local/mysql-proxy/lib/mysql-proxy/plugins plugins = admin,proxy admin-lua-script = /usr/local/mysql-proxy/lib/mysql-proxy/lua/admin.lua proxy-lua-script = /usr/local/mysql-proxy/lib/mysql-proxy/lua/rw-splitting.lua admin-address = 10.209.6.102:3307 admin-username = root admin-password = 123456 pid-file= /usr/local/mysql-proxy/run/mysql-proxy.pid log-file = /usr/local/mysql-proxy/log/mysql-proxy.log log-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/bin DAEMON="/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=0 start() { 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 $LOCKFILE return $RETVAL } stop() { echo -n $"Stopping ${PROG}......" if [[ `ps aux | grep bin/mysql-proxy | grep -v grep | wc -l` -gt 0 ]]; then kill -TERM `ps -A -oppid,pid,cmd | grep bin/mysql-proxy | grep -v grep | awk '{print $2}'` fi RETVAL=$? echo [[ $RETVAL -eq 0 ]] && rm -f $LOCKFILE $PIDFILE return $RETVAL } restart() { stop sleep 1 start } case "$1" in start) start ;; stop) stop ;; restart) restart ;; condrestart) [[ -e $LOCKFILE ]] && restart ;; *) echo "Usage: $0 {start|stop|restart|condrestart}" RETVAL=1 ;; esac exit $RETVAL

WIFSIGNALED(status)
returns true if the child process exited because of a signal which was not caught.

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


更详细的描述,可以参考这里(服务器开发之 Daemon 和 Keepalive):


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


人气教程排行