Mysql-Oneproxy读写分离+分库分表
3、配置oneproxy中间件（oneproxy服务器）①安装oneproxy
# wget http://www.onexsoft.com/software/oneproxy-rhel6-linux64-v6.2.0-ga.tar.gz
# tar zxf oneproxy-rhel6-linux64-v6.2.0-ga.tar.gz -C /usr/local/
②在预启动脚本中修改oneproxy目录
# vim /usr/local/oneproxy/demo.sh
~
#/bin/bash
export ONEPROXY_HOME=/usr/local/oneproxy
ulimit -c unlimited
valgrind --leak-check=full \
${ONEPROXY_HOME}/bin/oneproxy --defaults-file=${ONEPROXY_HOME}/conf/proxy.conf
③修改启动脚本oneproxy目录
#vim /usr/local/oneproxy/oneproxy.service
............................
OneProxy Settings
ONEPROXY_HOME=/usr/local/oneproxy
ONEPROXY_SBIN="${ONEPROXY_HOME}/bin/oneproxy"
ONEPROXY_CONF="${ONEPROXY_HOME}/conf/proxy.conf"
ONEPROXY_PID="${ONEPROXY_HOME}/log/oneproxy.pid"
RETVAL=0
prog="OneProxy"
④获取oneproxy加密后的密文密码
# cd /usr/local/oneproxy/bin/
# ls
# ./mysqlpwd 123456
9D7E55EAF8912CCBF32069443FAC452794F8941B
⑤修改oneproxy主配文件
# mysql --version
# vim /usr/local/oneproxy/conf/proxy.conf
#proxy-license = A2FF461456A67F28,D2F6A5AD70C9042D
keepalive = 1
event-threads = 4
proxy-group-policy = test:read-slave
log-file = log/oneproxy.log
pid-file = log/oneproxy.pid
lck-file = log/oneproxy.lck
proxy-auto-readonly = 1
proxy-forward-clientip = 1
proxy-trans-debug = 1
mysql-version = 5.7.21
proxy-master-addresses.1 = 192.168.32.150:3306@test
proxy-slave-addresses.2 = 192.168.32.129:3306@test
proxy-user-list = oneproxy/9D7E55EAF8912CCBF32069443FAC452794F8941B@test
proxy-part-template = conf/template.txt
proxy-part-tables.1 = conf/part.txt
proxy-part-tables.2 = conf/part2.txt
proxy-part-tables.3 = conf/cust1.txt
proxy-charset = utf8_bin
proxy-secure-client = 127.0.0.1
proxy-httpserver = :8080
proxy-httptitle = OneProxy Monitor
proxy-auto-readonly：自动切换读写角色
proxy-group-policy： 预定义策略，对应真实要管理的数据库
proxy-user-list： 指明连接数据库用户密文密码要与真实数据库用户密码对应@符后指的是数据库
启动oneproxy并查看端口
# cd ..
# chmod +x demo.sh
# ./demo.sh
# ./oneproxy.service start
# ss -anpt | grep 3307
# ss -anpt | grep 4041
页:
[1]