使用人大金仓集群的DB VIP(192.168.7.211这里就是DB的VIP)初始化OA后 ,weaver.properties内容如下:
DriverClasses = com.kingbase8.Driver
ecology.url = jdbc:kingbase8://192.168.7.211:54321/ecology?prepareThreshold=0
ecology.user = ecology
ecology.password = weaver2020
ecology.charset = ISO
ecology.maxconn = 300
ecology.minconn = 50
ecology.maxusecount = 6000
ecology.maxidletime = 600
ecology.maxalivetime = 10
ecology.checktime = 3600
ecology.isgoveproj = 0
LOG_FORMAT = yyyy.MM.dd'-'hh:mm:ss
DEBUG_MODE = false
修改该weaver.properties配置文件,使之实现读写分离效果
vim ... /ecology/WEB-INF/prop/weaver.properties
目标内容如下:
DriverClasses = com.kingbase8.Driver
ecology.url = jdbc:kingbase8://192.168.7.211:54321/ecology?prepareThreshold=0&USEDISPATCH=TRUE&SLAVE_ADD=192.168.7.212&SLAVE_PORT=54321&HOSTLOADRATE=33&WhiteList=min,max,nvl,rownum,count
ecology.user = ecology
ecology.password = weaver2020
ecology.charset = ISO
ecology.maxconn = 300
ecology.minconn = 50
ecology.maxusecount = 6000
ecology.maxidletime = 600
ecology.maxalivetime = 10
ecology.checktime = 3600
ecology.isgoveproj = 0
LOG_FORMAT = yyyy.MM.dd'-'hh:mm:ss
DEBUG_MODE = false
解释:
注意上面背景为黄色的部分是开启读写分离功能必须要设置的,ip和端口根据实际调整,其它保持上面的默认。
USEDISPATCH=TRUE表示开启读写分离功能
192.168.7.211表示集群里面DB的VIP地址
192.168.7.212表示备机的IP
54321表示备机的端口号
HOSTLOADRATE=33表示主机读负载率
WhiteList=min,max,nvl,rownum,count表示存储过程/函数白名单,在此白名单的走从库,其它的都转发到主库执行,参数必须要有的,至少要添加一个函数,多余一个用分号间隔
如果从库不止一个,通过逗号分隔,参考如下:
......&SLAVE_ADD=xxx.xxx.xxx.xxx,xxx.xxx.xxx.xxx&SLAVE_PORT=54321,54321&......