5.2. CentOS
# yum install mysql-proxy
# cat /etc/sysconfig/mysql-proxy # Options for mysql-proxy ADMIN_USER="admin" ADMIN_PASSWORD="" ADMIN_LUA_SCRIPT="/usr/lib64/mysql-proxy/lua/admin.lua" PROXY_USER="mysql-proxy" PROXY_OPTIONS="--daemon --log-level=info --log-use-syslog"
修改PROXY_OPTIONS选项
#PROXY_OPTIONS="--daemon --log-level=info --log-use-syslog" PROXY_OPTIONS="--defaults-file=/etc/mysql/mysql-proxy.cnf"
# mkdir /etc/mysql # vim /etc/mysql/mysql-proxy.cnf [mysql-proxy] daemon = true user = mysql-proxy proxy-skip-profiling = true keepalive = true ;max-open-files = 2048 event-threads = 512 pid-file = /var/run/mysql-proxy.pid log-file = /var/log/mysql-proxy.log log-level = debug admin-address=:4401 admin-username=admin admin-password=passw0rd admin-lua-script=/usr/lib64/mysql-proxy/lua/admin.lua proxy-address = 0.0.0.0:3307 proxy-backend-addresses = 192.168.2.1:3306 proxy-read-only-backend-addresses=192.168.6.2:3306, 192.168.6.1:3306 proxy-lua-script=/usr/lib64/mysql-proxy/lua/proxy/balance.lua
修复启动脚本BUG
# vim /etc/init.d/mysql-proxy #daemon $prog $PROXY_OPTIONS --pid-file=$PROXY_PID --user=$PROXY_USER --admin-username="$ADMIN_USER" --admin-lua-script="$ADMIN_LUA_SCRIPT" --admin-password="$ADMIN_PASSWORD" 注视这行，改为下面的一行代码 daemon $prog $PROXY_OPTIONS --pid-file=$PROXY_PID
日志
# cat /var/log/messages | grep mysql-proxy
