2011-04-15
2011-04-04
MySQL Proxy mysql-proxy.cnf
- [mysql-proxy]
- keepalive = true
- proxy-address = 127.0.0.1:3306
- proxy-backend-addresses = masterdb1:3306
- proxy-read-only-backend-addresses = slavedb1:3306,slavedb2:3306
- proxy-lua-script = /usr/local/mysql-proxy/share/doc/mysql-proxy/rw-splitting.lua
- daemon = true
- log-use-syslog = true
- log-level = message
- user = mysql-proxy
[mysql-proxy] keepalive = true proxy-address = 127.0.0.1:3306 proxy-backend-addresses = masterdb1:3306 proxy-read-only-backend-addresses = slavedb1:3306,slavedb2:3306 proxy-lua-script = /usr/local/mysql-proxy/share/doc/mysql-proxy/rw-splitting.lua daemon = true log-use-syslog = true log-level = message user = mysql-proxy
MySQL Proxy 起動スクリプト
- #!/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
- # Source function library.
- . /etc/rc.d/init.d/functions
- PROXY_PATH=/opt/mysql-proxy/sbin
- prog="mysql-proxy"
- # Source networking configuration.
- . /etc/sysconfig/network
- # Check that networking is up.
- [ ${NETWORKING} = "no" ] && exit 0
- # Set default mysql-proxy configuration.
- PROXY_OPTIONS="--daemon"
- PROXY_PID=/var/run/mysql-proxy.pid
- # Source mysql-proxy configuration.
- if [ -f /etc/sysconfig/mysql-proxy ] ; then
- . /etc/sysconfig/mysql-proxy
- fi
- PATH=$PATH:/usr/bin:/usr/local/bin:$PROXY_PATH
- # By default it's all good
- RETVAL=0
- # See how we were called.
- case "$1" in
- start)
- # Start daemon.
- echo -n $"Starting $prog: "
- daemon $NICELEVEL $PROXY_PATH/mysql-proxy $PROXY_OPTIONS --pid-file $PROXY_PID
- RETVAL=$?
- echo
- if [ $RETVAL = 0 ]; then
- touch /var/lock/subsys/mysql-proxy
- fi
- ;;
- stop)
- # Stop daemons.
- echo -n $"Stopping $prog: "
- killproc $prog
- RETVAL=$?
- echo
- if [ $RETVAL = 0 ]; then
- rm -f /var/lock/subsys/mysql-proxy
- rm -f $PROXY_PID
- fi
- ;;
- restart)
- $0 stop
- sleep 3
- $0 start
- ;;
- condrestart)
- [ -e /var/lock/subsys/mysql-proxy ] && $0 restart
- ;;
- status)
- status mysql-proxy
- RETVAL=$?
- ;;
- *)
- echo "Usage: $0 {start|stop|restart|status|condrestart}"
- RETVAL=1
- ;;
- esac
- exit $RETVAL
#!/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 # Source function library. . /etc/rc.d/init.d/functions PROXY_PATH=/opt/mysql-proxy/sbin prog="mysql-proxy" # Source networking configuration. . /etc/sysconfig/network # Check that networking is up. [ ${NETWORKING} = "no" ] && exit 0 # Set default mysql-proxy configuration. PROXY_OPTIONS="--daemon" PROXY_PID=/var/run/mysql-proxy.pid # Source mysql-proxy configuration. if [ -f /etc/sysconfig/mysql-proxy ] ; then . /etc/sysconfig/mysql-proxy fi PATH=$PATH:/usr/bin:/usr/local/bin:$PROXY_PATH # By default it's all good RETVAL=0 # See how we were called. case "$1" in start) # Start daemon. echo -n $"Starting $prog: " daemon $NICELEVEL $PROXY_PATH/mysql-proxy $PROXY_OPTIONS --pid-file $PROXY_PID RETVAL=$? echo if [ $RETVAL = 0 ]; then touch /var/lock/subsys/mysql-proxy fi ;; stop) # Stop daemons. echo -n $"Stopping $prog: " killproc $prog RETVAL=$? echo if [ $RETVAL = 0 ]; then rm -f /var/lock/subsys/mysql-proxy rm -f $PROXY_PID fi ;; restart) $0 stop sleep 3 $0 start ;; condrestart) [ -e /var/lock/subsys/mysql-proxy ] && $0 restart ;; status) status mysql-proxy RETVAL=$? ;; *) echo "Usage: $0 {start|stop|restart|status|condrestart}" RETVAL=1 ;; esac exit $RETVAL
登録:
投稿 (Atom)