mysql proxy搭建_mysql-proxy 负载均衡、读写分离搭建

最新推荐文章于 2021-03-17 05:29:14 发布

陈冠男

最新推荐文章于 2021-03-17 05:29:14 发布

阅读量123

点赞数

文章标签： mysql proxy搭建

本文链接：https://blog.csdn.net/weixin_29055137/article/details/113910019

版权

wget https://downloads.mysql.com/archives/get/file/mysql-proxy-0.8.5-linux-glibc2.3-x86-64bit.tar.gz

tar zxvf mysql-proxy-0.8.5-linux-glibc2.3-x86-64bit.tar.gz

echo "export MYSQL_PROXY=/data/mysql-proxy-0.8.5-linux-glibc2.3-x86-64bit">>/etc/profile

echo "export PATH=$MYSQL_PROXY/bin:$PATH">>/etc/profile

source /etc/profile

mkdir -p /data/mysql-proxy-0.8.5-linux-glibc2.3-x86-64bit/logs/

firewall-cmd --add-port=4040/tcp --permanent

firewall-cmd --reload

vi /data/mysql-proxy-0.8.5-linux-glibc2.3-x86-64bit/mysql-proxy-readwrite.cnf

[mysql-proxy]

user=root

admin-username=root

admin-password=xmrbi3967968@

proxy-address=10.0.39.90:4040

proxy-read-only-backend-addresses=realmysqlip

proxy-backend-addresses=realmysqlip

proxy-lua-script=/data/mysql-proxy-0.8.5-linux-glibc2.3-x86-64bit/share/doc/mysql-proxy/rw-splitting.lua

admin-lua-script=/data/mysql-proxy-0.8.5-linux-glibc2.3-x86-64bit/share/doc/mysql-proxy/admin-sql.lua

log-file=/data/mysql-proxy-0.8.5-linux-glibc2.3-x86-64bit/logs/mysql-proxy.log

log-level=info

daemon=true

keepalive=true

保存退出

chmod 600 /data/mysql-proxy-0.8.5-linux-glibc2.3-x86-64bit/mysql-proxy-readwrite.cnf

修改/data/mysql-proxy-0.8.5-linux-glibc2.3-x86-64bit/share/doc/mysql-proxy/rw-splitting.lua

if not proxy.global.config.rwsplit then

proxy.global.config.rwsplit = {

min_idle_connections = 1, #默认超过4个连接数时，才开始读写分离，改为1

max_idle_connections = 1, #默认8，改为1

is_debug = false

}

end

启动:

mysql-proxy --defaults-file=/data/mysql-proxy-0.8.5-linux-glibc2.3-x86-64bit/mysql-proxy-readwrite.cnf

编写服务:

vi /usr/lib/systemd/system/mysql-proxy-readwrite.service

[Unit]

Description=Mysql Proxy read write

After=rc-local.service

[Service]

Type=forking

ExecStart=/data/mysql-proxy-0.8.5-linux-glibc2.3-x86-64bit/bin/mysql-proxy --defaults-file=/data/mysql-proxy-0.8.5-linux-glibc2.3-x86-64bit/mysql-proxy-readwrite.cnf

ExecReload=/usr/bin/pkill mysql-proxy && /data/mysql-proxy-0.8.5-linux-glibc2.3-x86-64bit/bin/mysql-proxy --defaults-file=/data/mysql-proxy-0.8.5-linux-glibc2.3-x86-64bit/mysql-proxy-readwrite.cnf

ExecStop=/usr/bin/pkill mysql-proxy

Restart=on-failure

RestartSec=42s

PrivateTmp=true

[Install]

WantedBy=multi-user.target

保存退出

chmod 754 /usr/lib/systemd/system/mysql-proxy-readwrite.service

获取进程号：ps -ef|grep mysql-proxy|grep -v 'grep'|awk '{print $2}'

关掉进程：kill -9 ps -ef|grep mysql-proxy|grep -v 'grep'|awk '{print $2}'

编写负载均衡脚本

!/bin/bash