ubuntu下mysql proxy 安装配置_ubuntu安装mysql-proxy-优快云博客

本文链接：https://blog.youkuaiyun.com/jared_he2017/article/details/80539307

本文详细介绍了在Ubuntu系统中如何安装和配置MySQL Proxy，包括安装LUA、下载预编译的MySQL Proxy、编写启动脚本、配置参数文件、设置环境变量以及验证安装过程。通过这些步骤，可以实现MySQL读写分离和高可用性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1. 安装 LUA

2. 官网下载预编译班的mysql-proxy： https://downloads.mysql.com/archives/proxy/

3. 解压：tar zxf mysql-proxy-0.6.0-linux-rhas4-x86.tar.gz，并将解压后的文件夹复制到（自定义）/var/www/program/mysql-proxy

4. 进入目录： cd /var/www/program/mysql-proxy

5. 编写启动脚本：vim start.sh

#!/bin/bash
mode=$1
if [ -z "$mode" ] ; then
mode="start"
fi
case $mode in
start)
/var/www/program/mysql-proxy/bin/mysql-proxy --defaults-file=/etc/mysql-proxy.cnf(第四步编辑的参数文件)>/var/log/proxy-mysql/cn.log &
;;
stop)
killall -9 mysql-proxy
;;
restart)
if $0 stop ; then
$0 start
else
echo "Restart failed!"
exit 1
fi
;;
esac

exit 0

6. 编写：参数配置文件 vim /etc/mysql-proxy.cnf

[mysql-proxy]
admin-username = root
admin-password = 123
daemon = true
keepalive = true
proxy-backend-addresses = 127.0.0.1:3306
proxy-read-only-backend-addresses = 127.0.0.1:3307
proxy-lua-script = /var/www/program/mysql-proxy/share/doc/mysql-proxy/rw-splitting.lua
admin-lua-script = /var/www/program/mysql-proxy/share/doc/mysql-proxy/admin-sql.lua
log-file = /var/log/proxy-mysql/cn.log

log-level = debug

7. 配置环境变量： vim /etc/profile

###########

LUA_PATH="/var/www/program/mysql-proxy/share/doc/mysql-proxy/?.lua"
export LUA_PATH

export PATH=$PATH:/var/www/program/mysql-proxy/bin

#################

退出编辑并执行命令： source /etc/profile

通过命令: mysql-proxy -V 查看是否成功

over！！！