56,679
社区成员
发帖
与我相关
我的任务
分享
#!/bin/bash
export LUA_PATH=/usr/local/lib/mysql-proxy/lua/?.lua
mode=$1
if [ -z "$mode" ] ; then
mode="start"
fi
case $mode in
'start')
mysql-proxy
--keepalive=true
--admin-address=:4040
--proxy-address=:3307
--proxy-backend-addresses=172.19.32.192:3306
--proxy-read-only-backend-addresses=172.19.32.191:3306
--proxy-lua-script=/root/InstallFile/rw-splitting.lua
--log-file=/root/InstallFile/mysql-proxy.log &
;;
'stop')
killall mysql-proxy
;;
'restart')
if $0 stop ; then
$0 start
else
echo "retart failed!!!"
exit 1
fi
;;
esac
exit 0
mysql-proxy 0.8.0
glib2: 2.22.5
libevent: 2.0.19-stable
lua: Lua 5.1.4
LUA_PATH: /usr/local/lib/mysql-proxy/lua/?.lua
LUA_CPATH: /usr/local/lib/mysql-proxy/lua/?.so
== plugins ==
admin: 0.7.0
proxy: 0.7.0
if not proxy.global.config.rwsplit then
proxy.global.config.rwsplit = {
min_idle_connections = 1,
max_idle_connections = 1,
is_debug = true
}
end
[mysql-proxy]
admin-username = zhanghu
admin-password = mima
keepalive=true
proxy-backend-addresses = 172.19.32.192:3306
proxy-read-only-backend-addresses = 172.19.32.191:3306
proxy-lua-script = /root/InstallFile/rw-splitting.lua
admin-lua-script = /root/InstallFile/rw-splitting.lua
log-file = /root/InstallFile/mysql-proxy.log
log-level = debug
vi /etc/profile增加LUA_PATH=" /usr/local/lib/mysql-proxy/lua/?.lua"
export LUA_PATH
export PATH=$PATH:/usr/local /bin
source /etc/profile
vi /etc/init.d/mysql-proxy
#!/bin/bash
mode=$1
if [ -z "$mode" ] ; then
mode="start"
fi
case $mode in
start)
mysql-proxy --defaults-file=/etc/mysql-proxy.cnf>/root/InstallFile/mysql-proxy.log &
;;
stop)
killall -9 mysql-proxy
;;
restart)
if $0 stop ; then
$0 start
else
echo "Restart failed!"
exit 1
fi
;;
esac
exit 0
现在启动可以看到日志了,登陆mysql-proxy的时候报错了
(critical) (lua-error) [/root/InstallFile/rw-splitting.lua]
error loading module 'mysql.tokenizer' from file '/usr/local/lib/mysql-proxy/lua/mysql.so':
dynamic libraries not enabled; check your Lua installation
[string "/root/InstallFile/rw-splitting.lua"]:29: loop or previous error loading module 'proxy.tokenizer'
目前看来是lua哪里没安装好