MySQL读写分离之One Proxy

一、配置准备

1、Innodb Cluster +Rounter 集群+Keepalived 配置(略)见上文

2、环境说明：

MySQL Router VIP地址：192.168.2.100

MySQL Router 写入端口：6446

MySQL Router 读取端口：6447

One Proxy1 信息：

IP：192.168.2.109

主机名：rdc-manager1

One Proxy2 信息：

IP：192.168.2.110

主机名：rdc-manager2

One Proxy VIP 192.168.2.98

二、配置

1、下载One Proxy

wget http://www.onexsoft.com/software/oneproxy-rhel6-linux64-v6.2.0-ga.tar.gz

2、解压安装One Proxy

tar -zvxf oneproxy-rhel6-linux64-v6.2.0-ga.tar.gz 
mv oneproxy-rhel6-linux64-v6.2.0-ga /usr/local/oneproxy

3、配置oneproxy（rdc-manager1）

cd /usr/local/oneproxy
vim conf/proxy.conf

[oneproxy]
event-threads              = 1
proxy-license              = A2FF461456A67F28,D2F6A5AD70C9042D
proxy-httpserver           = 0.0.0.0:8080
proxy-security-level       = 0
proxy-auto-readonly        = 0
proxy-slave-addresses.1    = 192.168.2.100:6447@default
proxy-master-addresses.2   = 192.168.2.100:6446@default
# proxy-slave-addresses.3  = ...

proxy-group-policy         = default:read_slave
proxy-user-list            = default:root/9D7E55EAF8912CCBF32069443FAC452794F8941B@rdc_manager

remote-address.1           = 192.168.2.110:4041
vip-address                = 192.168.2.98/ens33:vip

proxy-part-template        = conf/template.txt
proxy-part-tables          = conf/part.txt

proxy-sequence-group       = default
proxy-sequence.1           = seq1
network-blocking           = 0

4、配置oneproxy（rdc-manager2）

[oneproxy]
event-threads              = 1
proxy-license              = A