LAMP+redis搭建discuz论坛，基于mysql-proxy插件主从同步

[mysql-proxy]
user=root
admin-username=root
admin-password=123456
proxy-address=192.168.72.134

proxy-backend-addresses=192.168.72.139:3306
proxy-read-only-backend-addresses=192.168.72.130:3306

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

admin-lua-script=/usr/local/src/mysql-proxy/etc/admin-sql.lua
log-file=/usr/local/src/mysql-proxy/logs/mysql-proxy.log
log-level=info
daemon=true
keepalive=true

[root@SQL-proxy ~]# vim /etc/init.d/mysql-proxy
#!/bin/bash
#
# mysql-proxy This script starts and stops the mysql-proxy daemon
#
# chkconfig: - 78 30
# processname: mysql-proxy
# description: mysql-proxy is a proxy daemon for mysql

# Source function library.
. /etc/rc.d/init.d/functions

prog="/usr/local/mysql-proxy/bin/mysql-proxy"

# Source networking configuration.
if [ -f /etc/sysconfig/network ]; then
    . /etc/sysconfig/network
fi

# Check that networking is up.
[ ${NETWORKING} = "no" ] && exit 0


DEFAULT_FILE=/etc/mysql-proxy.cnf
PROXY_PID=/var/run/mysql-proxy.pid

RETVAL=0

start() {
    echo -n $"Starting MySQL-proxy...  : "
    daemon $prog --defaults-file=$DEFAULT_FILE
    RETVAL=$?
    echo
    if [ $RETVAL -eq 0 ]; then
        touch /var/lock/subsys/mysql-proxy.lock
    fi
}

stop() {
    echo -n $"Stopping MySQL-proxy...  : "
    killproc -p $PROXY_PID -d 3 $prog
    RETVAL=$?
    echo
    if [ $RETVAL -eq 0 ]; then
        rm -f /var/lock/subsys/mysql-proxy.lock
        rm -f $PROXY_PID
    fi
}
# See how we were called.
case "$1" in
    start)
        start
        ;;
    stop)
        stop
        ;;
    restart)
        stop
        start
        ;;
    condrestart|try-restart)
        if status -p $PROXY_PIDFILE $prog >&/dev/null; then
            stop
            start
        fi
        ;;
    status)
        status -p $PROXY_PID $prog
        ;;
    *)
        echo "Usage: $0 {start|stop|restart|reload|status|condrestart|try-restart}"
        RETVAL=1
        ;;
esac

exit $RETVAL

[root@SQL-proxy ~]# /etc/init.d/mysql-proxy status
mysql-proxy (pid  3086) is running...
[root@SQL-proxy ~]# 
[root@SQL-proxy ~]# /etc/init.d/mysql-proxy stop
Stopping MySQL-proxy...  :                                 [  OK  ]
[root@SQL-proxy ~]# 
[root@SQL-proxy ~]# /etc/init.d/mysql-proxy status
mysql-proxy is stopped
[root@SQL-proxy ~]# netstat -lntup
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address               Foreign Address             State       PID/Program name   
tcp        0      0 0.0.0.0:22                  0.0.0.0:*                   LISTEN      1079/sshd           
tcp        0      0 :::22                       :::*                        LISTEN      1079/sshd           
[root@SQL-proxy ~]# /etc/init.d/mysql-proxy start
Starting MySQL-proxy...  :                                 [  OK  ]
[root@SQL-proxy ~]# /etc/init.d/mysql-proxy restart
Stopping MySQL-proxy...  :                                 [  OK  ]
Starting MySQL-proxy...  :                                 [  OK  ]
[root@SQL-proxy ~]# 
[root@SQL-proxy ~]# netstat -lntup               
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address               Foreign Address             State       PID/Program name   
tcp        0      0 192.168.0.86:3306           0.0.0.0:*                   LISTEN      3143/mysql-proxy