DM8读写分离集群

规划
主机 192.168.100.112
备机 192.168.100.114
监视器 192.168.100.114

数据库安装路径:/home/dmdba/dmdbms
数据库实例路径:/home/dmdba/dmdbms/data
搭建前关闭防火墙

systemctl stop firewalld 禁用防火墙
systemctl disable firewalld 停止并禁用开机启动
systemctl start firewalld 启动防火墙
systemctl enable firewalld 设置开机启动
systemctl status firewalld  查看防火墙状态

1.初始化实例(主机备机相同操作)

cd /home/dmdba/dmdbms/bin
./dminit path=/home/dmdba/dmdbms/data/ 

2.启停数据库一次

./dmserver /home/dmdba/dmdbms/data/DAMENG/dm.ini 

exit

出现SYSTEM IS READY后输入exit关闭数据库

二.脱机备份
1.主机上备份:

./dmrman ctlstmt="backup database '/home/dmdba/dmdbms/data/DAMENG/dm.ini' full to backup01 backupset '/home/dmdba/backup01/'"

2.发送给备机:

scp -r /home/dmdba/backup01/ dmdba@192.168.100.114:/home/dmdba

3.备机上还原

 ./dmrman ctlstmt="restore database '/home/dmdba/dmdbms/data/DAMENG/dm.ini' from backupset '/home/dmdba/backup01'"

4.备机上恢复

./dmrman ctlstmt="recover database '/home/dmdba/dmdbms/data/DAMENG/dm.ini' from backupset '/home/dmdba/backup01'"

5.备机上更新

./dmrman ctlstmt="recover database '/home/dmdba/dmdbms/data/DAMENG/dm.ini' update db_magic"

三.配置主库
修改dm.ini文件参数,创建dmmal.ini,dmarch.ini,dmwatcher.ini文件
1.dm.ini文件

INSTANCE_NAME=DM01
ARCH_INI=1
MAL_INI=1
ALTER_MODE_STATUS= 0
ENABLE_OFFLINE_TS = 2

2.dmmal.ini

MAL_CHECK_INTERVAL = 5 
MAL_CONN_FAIL_INTERVAL = 5 
[MAL_INST1] 
MAL_INST_NAME = DM01
MAL_HOST = 192.168.100.112
MAL_PORT = 61141 
MAL_INST_HOST = 192.168.100.112
MAL_INST_PORT = 5236
MAL_DW_PORT = 52141 
MAL_INST_DW_PORT = 33141 
[MAL_INST2] 
MAL_INST_NAME = DM02 
MAL_HOST = 192.168.100.114
MAL_PORT = 61142 
MAL_INST_HOST = 192.168.100.114
MAL_INST_PORT = 5236 
MAL_DW_PORT = 52142 
MAL_INST_DW_PORT = 33142

3.dmarch.ini

ARCH_WAIT_APPLY=1
[ARCHIVE_REALTIME1] 
ARCH_TYPE = REALTIME 
ARCH_DEST = DM02 
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL 
ARCH_DEST = /home/dmdba/dmdbms/data/DAMENG/arch 
ARCH_FILE_SIZE = 512 
ARCH_SPACE_LIMIT = 10240

读写分离集群要求实时归档+事务一致性

4.dmwatcher.ini

[GRP1]
DW_TYPE = GLOBAL 
DW_MODE = AUTO 
DW_ERROR_TIME = 10 
INST_RECOVER_TIME = 60 
INST_ERROR_TIME = 10 
INST_OGUID = 453331 
INST_INI = /home/dmdba/dmdbms/data/DAMENG/dm.ini 
INST_AUTO_RESTART = 1 
INST_STARTUP_CMD = /home/dmdba/dmdbms/bin/dmserver 
RLOG_SEND_THRESHOLD = 0 
RLOG_APPLY_THRESHOLD = 0

将1,2,3,4发给备库

scp dm.ini dmmal.ini dmarch.ini dmwatcher.ini dmdba@192.168.100.114:/home/dmdba/dmdbms/data/DAMENG

配置备库
1.修改dm.ini
将INSTANCE_NAME设置为DM02

INSTANCE_NAME=DM02

2.修改dmarch.ini
将ARCH_DEST参数修改为主库的

ARCH_DEST = DM01

配置监视器
1.dmmonitor.ini

MON_DW_Confirm = 1
MON_LOG_PATH = /home/dmdba/log
MON_LOG_INTERVAL = 60
MON_LOG_FILE_SIZE = 32
MON_LOG_SPACE_LIMIT = 0
[GRP1]
MON_INST_OGUID = 453331 
MON_DW_IP = 192.168.100.112:52141
MON_DW_IP = 192.168.100.114:52142

四.注册服务(root 用户下)
1.实例服务(主备库相同)
安装路径script/root目录下:

./dm_service_installer.sh -t dmserver -m mount  -dm_ini  /home/dmdba/dmdbms/data/DAMENG/dm.ini  -p DM

2.watcher服务(主备库相同
安装路径script/root目录下:

./dm_service_installer.sh -t dmwatcher -watcher_ini /home/dmdba/dmdbms/data/DAMENG/dmwatcher.ini  -p DM

3.监视器服务(备库)
安装路径script/root目录下:

./dm_service_installer.sh -t dmmonitor   -monitor_ini  /home/dmdba/dmdbms/data/DAMENG/dmmonitor.ini  -p DM

五.配置OGUID
主库,启动服务,连接数据库,修改参数

./DmServiceDM start
./disql
sp_set_oguid(453331);
alter database primary;

备库,启动服务,连接数据库,修改参数

./DmServiceDM start
./disql
SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1);
sp_set_oguid(453331);
alter database standby;
SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 0);

六.启动集群
主备库启动watcher服务:

./DmWatcherServiceDM start

备库启动监视器:

./DmMonitorServiceDM start

主库

备库

进入log下查看dmmonitor***.log

cd /home/dmdba/log

tail -100f dmmonitor***.log