学习版本:mysql-proxy-0.8.5-1.el6.x86_64
环境准备:
MySQL_A(10.0.13-MariaDB)读写:n1.test.com;172.16.2.11
MySQL_B(10.0.13-MariaDB)只读:n2.test.com;172.16.2.12
MySQL-proxy(0.8.5):n3.test.com;172.16.2.13
mysql-proxy:
epel源:yum -y install mysql-proxy
使用官方二进制格式文件中的rw-splitting.lua脚本进行读写分离
# mysql-proxy --help-all==>命令帮助
配置文件:/etc/mysql-proxy.cnf
[mysql-proxy]
daemon = true
pid-file = /var/run/mysql-proxy.pid
log-file = /var/log/mysql-proxy.log
log-level = debug #调试级别
max-open-files = 1024
plugins = admin,proxy