1.主备节点数据库安装,主节点需要初始化,备节点不需要初始化
主:192.168.75.128:9088
备:192.168.75.129:9088
2.修改主节点onconfig文件以下参数,具体根据实际情况进行修改
LOG_INDEX_BUILDS 1
DRAUTO 3
DRINTERVAL 30
DRTIMEOUT 30
DRIDXAUTO 0
UPDATABLE_SECONDARY 0
3.将主节点onconfig文件拷贝到rss节点,并修改以下参数
SERVERNUM 28
DBSERVERNAME gbaseserver_rss
TEMPTAB_NOLOG 1
4.配置sqlhosts文件,主节点和备节点文件一致
gbaseserver onsoctcp 192.168.75.128 9088
gbaseserver_rss onsoctcp 192.168.75.129 9088
5.配置节点互信
主节点:
vim /home/gbasedbt/.rhosts
192.168.75.129 gbasedbt
备节点:
vim /home/gbasedbt/.rhosts
192.168.75.128 gbasedbt
6.配置主备节点的profile文件
主节点:
vim /home/gbasedbt/profile.gbaseserver
export GBASEDBTSERVER=gbaseserver
export GBASEDBTDIR=/opt/gbase
export GBASEDBTSQLHOSTS=/opt/gbase/etc/sqlhosts.gbaseserver
export ONCONFIG=onconfig.gbaseserver
export PATH=/opt/gbase/bin:$PATH
unset DB_LOCALE CLIENT_LOCALE
备节点:
vim /home/gbasedbt/profile.gbaseserver_rss
export GBASEDBTSERVER=gbaseserver_rss
export GBASEDBTDIR=/opt/gbase
export GBASEDBTSQLHOSTS=/op