mysql proxy分表_Mysql-Oneproxy读写分离+分库分表

3、配置oneproxy中间件(oneproxy服务器)

①安装oneproxy

[root@localhost ~]# tar zxf oneproxy-rhel6-linux64-v6.2.0-ga.tar.gz -C /usr/local/

②在预启动脚本中修改oneproxy目录

[root@localhost ~]# 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目录

[root@localhost ~]#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加密后的密文密码

[root@localhost ~]# cd /usr/local/oneproxy/bin/

[root@localhost bin]# ls

[root@localhost bin]# ./mysqlpwd 123456

9D7E55EAF8912CCBF32069443FAC452794F8941B

⑤修改oneproxy主配文件

[root@localhost ~]# mysql --version

[root@localhost bin]# vim /usr/local/oneproxy/conf/proxy.conf

[oneproxy]

#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并查看端口

[root@localhost bin]# cd ..

[root@localhost oneproxy]# chmod +x demo.sh

[root@localhost oneproxy]# ./demo.sh

[root@localhost oneproxy]# ./oneproxy.service start

[root@localhost oneproxy]# ss -anpt | grep 3307

[root@localhost oneproxy]# ss -anpt | grep 4041