1、下载oneproxy-rhel6-linux64-v5.8.2-ga.tar.gz
2、tar zxvf oneproxy-rhel6-linux64-v5.8.2-ga.tar.gz -C /usr/local
3、读写分离的配置
[root@mysql_test1 oneproxy]# vim /usr/local/oneproxy/conf/proxy.conf
[oneproxy]
keepalive = 1
event-threads = 4
log-file = log/oneproxy.log
pid-file = log/oneproxy.pid
lck-file = log/oneproxy.lck
mysql-version = 5.6.27
proxy-address = :3307
proxy-master-addresses = 10.0.20.1:38141@default
proxy-slave-addresses = 10.0.20.2:38141@default
proxy-user-list = test/956C97523BADD23B6091B09E332A77B5CBDBBEEF@test
proxy-charset = gbk_chinese_ci
proxy-group-policy = default:read_slave
proxy-secure-client = 127.0.0.1
proxy-sequence.1 = default
remote-address = 10.0.20.1:4041
vip-address = 10.0.20.5/eth0:0
4、启动服务
sh /usr/local/oneproxy/demo.sh
5、查看监听
[root@mysql_test1 oneproxy]# netstat -nltp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 0.0.0.0:111 0.0.0.0:* LISTEN 1633/rpcbind
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 6082/sshd
tcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN 6161/master
tcp 0 0 0.0.0.0:41402 0.0.0.0:* LISTEN 1655/rpc.statd
tcp 0 0 :::38141 :::* LISTEN 18801/mysqld
tcp 0 0 :::111 :::* LISTEN 1633/rpcbind
tcp 0 0 :::34388 :::* LISTEN 1655/rpc.statd
tcp 0 0 :::22 :::* LISTEN 6082/sshd
tcp 0 0 ::1:25 :::* LISTEN 6161/master
--------------------------------------------------------------------------------------------------------------
分表设计的配置
[root@mysql_test1 oneproxy]# vim conf/proxy.conf
[oneproxy]
keepalive = 1
event-threads = 4
log-file = log/oneproxy.log
pid-file = log/oneproxy.pid
lck-file = log/oneproxy.lck
mysql-version = 5.6.27
proxy-address = :3307
proxy-master-addresses.1 = 10.0.20.1:38141@data1
proxy-master-addresses.2 = 10.0.20.2:38141@data2
proxy-user-list = test/956C97523BADD23B6091B09E332A77B5CBDBBEEF@test
proxy-charset = utf8_general_ci
proxy-group-policy = default:0
proxy-part-template = conf/template.txt
proxy-part-tables.1 = conf/part.txt
proxy-part-tables.2 = conf/part2.txt
proxy-secure-client = 127.0.0.1
proxy-sequence.1 = default
remote-address = 10.0.20.1:4041
~