mysql-proxy配置安装

wget https://cdn.mysql.com/archives/mysql-proxy/mysql-proxy-0.8.5-linux-glibc2.3-x86-64bit.tar.gz
cd /usr/local/
tar zxf mysql-proxy-0.8.5-linux-glibc2.3-x86-64bit.tar.gz
mv mysql-proxy-0.8.5-linux-glibc2.3-x86-64bit mysql-proxy
mkdir /usr/local/mysql-proxy/{conf,log} -p

vi /etc/profile

LUA_PATH="/usr/local/mysql-proxy/share/doc/mysql-proxy/?.lua"
export LUA_PATH
export PATH=$PATH:/usr/local/mysql-proxy/bin

 

 vi /usr/local/mysql-proxy/conf/test-proxy.conf

[mysql-proxy]
user=root
daemon=true
keepalive=true
plugins=proxy,admin
###日志级别
log-level=info
log-file=/usr/local/mysql-proxy/log/mysql-proxy.log
###本机ip地址
proxy-address=192.168.3.20:20000

##backend主   注意addresses
proxy-backend-addresses=192.168.3.21:3306

##proxy的管理用户admin的IP和端口
admin-address=192.168.3.26:20001

###下面的三个参数必须设定，否则mysql-proxy服务启动不了的
admin-username=admin
admin-password=passwd
###admin的lua脚本地址;
admin-lua-script=/usr/local/mysql-proxy/lib/mysql-proxy/lua/admin.lua

启动

/usr/local/mysql-proxy/libexec/mysql-proxy --defaults-file=/usr/local/mysql-proxy/conf/test-proxy.conf

启动时提示错误：

/usr/local/mysql-proxy/libexec/mysql-proxy: error while loading shared libraries: libmysql-chassis.so.0: cannot open shared object file: No such file or directory

vi /etc/ld.so.conf
加入一行
/usr/local/mysql-proxy/lib

再执行ldconfig

2021-06-09 10:10:21: (critical) mysql-proxy-cli.c:326: loading config from '/usr/local/mysql-proxy/conf/prod-proxy.conf' failed: permissions of /usr/local/mysql-proxy/conf/prod-proxy.conf aren't secure (0660 or stricter required)
2021-06-09 10:10:21: (message) Initiating shutdown, requested from mysql-proxy-cli.c:328
2021-06-09 10:10:21: (message) shutting down normally, exit code is: 1


chmod 0660 /usr/local/mysql-proxy/conf/prod-proxy.conf