oneproxy增加多个用户配置

时间:2021-03-04 03:04:13
# oneproxy增加多个用户配置如下
# by  coco
# 2016-03-09

增加 proxy-user-list.1——n   项,表示新增加不同的用户。前提是这些用户必须可以登录mysql,并在mysql中有响应的操作权限。

[root@hadoop94 conf]# vim 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 = 192.168.8.94:3306@server1

proxy-user-list.1          = test/1378F6CC3A8E8A43CA388193FBED5405982FBBD3@test
proxy-user-list.2          = mha_user/389433BDF5A642E23483ED08E6E62D91E7E5B7CF@wwn                                       
proxy-user-group         = server1:test/1378F6CC3A8E8A43CA388193FBED5405982FBBD3

#proxy-part-template      = conf/template.txt
#proxy-part-tables.1      = conf/part.txt
proxy-part-tables.2      = conf/part2.txt
#proxy-charset            = gbk_chinese_ci
proxy-charset            = utf8_general_ci
#proxy-group-policy       = server1:master-only
proxy-group-policy       = server1:0
proxy-table-security    =  pdcheck_hlbr:0
proxy-secure-client      = 192.168.8.94

remote-address           = 192.168.8.94:4041
vip-address              = 192.168.1.120/eth0:0