一次完整的达梦数据库实时主备集群搭建过程（测试）

前言
实时主备系统由主库、实时备库、守护进程和监视器组成。通过部署实时主备系统，可以及时检测并处理各种硬件故障、数据库实例异常，确保持续提供数据库服务。
在本次搭建测试在笔者的笔记本搭建虚拟机平台下完成，以麒麟10和dm8完成集群测试。

一、主备机规划

dwp 192.168.254.10
dws 192.168.254.30
dwm 192.168.254.10

数据库名实例名 PORT_NUM MAL_INST_DW_PORT MAL_HOST MAL_PORT MAL_DW_PORT
DMDW LEO1 5246 45101 192.168.254.10 55101 65101
DMDW LEO2 5246 45121 192.168.254.30 55121 65121

二、实施过程
1、主备库安装

主库
su - dmdba
dminit path=/dm8/data db_name=DMDW instance_name=LEO1 port_num=5246 sysdba_pwd=dameng123

root用户下
cd /dm8/script/root/
./dm_service_installer.sh -t dmserver -dm_ini /dm8/data/DMDW/dm.ini -p LEO1

备库
su - dmdba
dminit path=/dm8/data db_name=DMDW instance_name=LEO2 port_num=5246 sysdba_pwd=dameng123
root用户下
cd /dm8/script/root/
./dm_service_installer.sh -t dmserver -dm_ini /dm8/data/DMDW/dm.ini -p LEO2

2、备库初始化

主库dmrman备份并传到备库
DmServiceLEO1 stop
mkdir -p /dm8/backup/
dmrman
backup database ‘/dm8/data/DMDW/dm.ini’ full to backup1 backupset ‘/dm8/backup/BACKUPFILE_01’

cd /dm8/backup/BACKUPFILE_01
scp . 192.168.254.30:/dm8/backup/

备库dmrman恢复
DmServiceLEO2 stop
dmrman
RESTORE DATABASE ‘/dm8/data/DMDW/dm.ini’ FROM BACKUPSET ‘/dm8/backup’
RECOVER DATABASE ‘/dm8/data/DMDW/dm.ini’ FROM BACKUPSET ‘/dm8/backup’
RECOVER DATABASE ‘/dm8/data/DMDW/dm.ini’ UPDATE DB_MAGIC

3、主备库参数配置
vi dm.ini

INSTANCE_NAME = LEO1
PORT_NUM = 5246
DW_INACTIVE_INTERVAL = 60
ALTER_MODE_STATUS = 0
ENABLE_OFFLINE_TS = 2
MAL_INI = 1
ARCH_INI = 1
RLOG_SEND_APPLY_MON = 64

vi dmmal.ini

MAL_CHECK_INTERVAL = 5
MAL_CONN_FAIL_INTERVAL = 5
[MAL_INST1]
MAL_INST_NAME = LEO1
MAL_HOST = 192.168.254.10
MAL_PORT = 55101
MAL_INST_HOST = 192.168.254.10
MAL_INST_PORT = 5246
MAL_DW_PORT = 65101
MAL_INST_DW_PORT = 45101
[MAL_INST2]
MAL_INST_NAME = LEO2
MAL_HOST = 192.168.254.30
MAL_PORT = 55121
MAL_INST_HOST = 192.168.254.30
MAL_INST_PORT = 5246
MAL_DW_PORT = 65121
MAL_INST_DW_PORT = 45121

vi dmarch.ini

[ARCHIVE_REALTIME]
ARCH_TYPE = REALTIME
ARCH_DEST = LEO2
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /dm8/arch
ARCH_FILE_SIZE = 128
ARCH_SPACE_LIMIT = 0

vi 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 = /dm8/data/DMDW/dm.ini
INST_AUTO_RESTART = 1
INST_STARTUP_CMD = /dm8/bin/dmserver
RLOG_SEND_THRESHOLD = 0
RLOG_APPLY_THRESHOLD = 0

配置 standby
vi dm.ini

INSTANCE_NAME = LEO2
PORT_NUM = 5246
DW_INACTIVE_INTERVAL = 60
ALTER_MODE_STATUS = 0
ENABLE_OFFLINE_TS = 2
MAL_INI = 1
ARCH_INI = 1
RLOG_SEND_APPLY_MON = 64

vi dmmal.ini

vi dmarch.ini

[ARCHIVE_REALTIME]
ARCH_TYPE = REALTIME
ARCH_DEST = LEO1
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /dm8/arch
ARCH_FILE_SIZE = 128
ARCH_SPACE_LIMIT = 0

vi dmwatcher.ini

四、启动主备库

主库启动
./dmserver /dm8/data/DMDW/dm.ini mount

备库启动
./dmserver /dm8/data/DMDW/dm.ini mount

五、启动守护进程

主库启动守护进程
cd /dm8/bin
./dmwatcher /dm8/data/DMDW/dmwatcher.ini

备库启动守护进程
cd /dm8/bin
./dmwatcher /dm8/data/DMDW/dmwatcher.ini

六配置并启动视器

vi dmmonitor.ini

MON_DW_CONFIRM = 1
MON_LOG_PATH = /dm8/data/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.254.10:65101
MON_DW_IP = 192.168.254.30:65121
启动监视器
./dmmonitor /dm8/dmmonitor.ini

七、验证集群

主库读写数据

备库只读查询