达梦dm8读写分离安装过程

达梦dm8读写分离安装过程

1. 主备机分配

数据库名 实例名 PORT_NUM MAL_INST_DW_PORT MAL_HOST MAL_PORT MAL_DW_PORT
DAMENG DMSVR01 5236 45101 192.168.1.18 55101 65101
DAMENG DMSVR02 5236 45121 192.168.1.20 55121 65121

2. 备份主库

停库才能导出
./dmrman CTLSTMT=“BACKUP DATABASE ‘/dm8/data/DM01/dm.ini’ FULL TO BACKUP_FILE1 BACKUPSET ‘/dm8/backup/BACKUP_FILE_01’”

拷到备机上：
./dmrman CTLSTMT=“RESTORE DATABASE ‘/dm8/data/DM01/dm.ini’ FROM BACKUPSET ‘/dm8/backup/BACKUP_FILE_01’”
./dmrman CTLSTMT=“RECOVER DATABASE ‘/dm8/data/DM01/dm.ini’ FROM BACKUPSET ‘/dm8/backup/BACKUP_FILE_01’”
./dmrman CTLSTMT=“RECOVER DATABASE ‘/dm8/data/DM01/dm.ini’ UPDATE DB_MAGIC”

3. 主机上操作

dm.ini--------------------
INSTANCE_NAME = DMSVR01
PORT_NUM = 5236
DW_INACTIVE_INTERVAL = 60
ALTER_MODE_STATUS = 0
ENABLE_OFFLINE_TS = 2
MAL_INI = 1
ARCH_INI = 1
RLOG_SEND_APPLY_MON = 64

dmmal.ini--------------------
MAL_CHECK_INTERVAL = 5
MAL_CONN_FAIL_INTERVAL = 5
[MAL_INST1]
MAL_INST_NAME = DMSVR01
MAL_HOST = 192.168.0.210
MAL_PORT = 55101
MAL_INST_HOST = 192.168.0.210
MAL_INST_PORT = 5236
MAL_DW_PORT = 65101
MAL_INST_DW_PORT = 45101
[MAL_INST2]
MAL_INST_NAME = DMSVR02
MAL_HOST = 192.168.0.3
MAL_PORT = 55121
MAL_INST_HOST = 192.168.0.3
MAL_INST_PORT = 5236
MAL_DW_PORT = 65121
MAL_INST_DW_PORT = 45121

dmarch.ini--------------------
[ARCHIVE_REALTIME]
ARCH_TYPE = REALTIME
ARCH_DEST = DMSVR02
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /dm8/arch
ARCH_FILE_SIZE = 128
ARCH_SPACE_LIMIT = 0

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

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

SQL>
SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1); 
sp_set_oguid(453331); 
SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 0);
alter database primary;

---

二、备库上standby

dm.ini--------------------

INSTANCE_NAME = DMSVR02
PORT_NUM = 5236
DW_INACTIVE_INTERVAL = 60
ALTER_MODE_STATUS = 0
ENABLE_OFFLINE_TS = 2
MAL_INI = 1
ARCH_INI = 1
RLOG_SEND_APPLY_MON = 64

dmmal.ini--------------------
MAL_CHECK_INTERVAL = 5
MAL_CONN_FAIL_INTERVAL = 5
[MAL_INST1]
MAL_INST_NAME = DMSVR01
MAL_HOST = 192.168.0.210
MAL_PORT = 55101
MAL_INST_HOST = 192.168.0.210
MAL_INST_PORT = 5236
MAL_DW_PORT = 65101
MAL_INST_DW_PORT = 45101
[MAL_INST2]
MAL_INST_NAME = DMSVR02
MAL_HOST = 192.168.0.3
MAL_PORT = 55121
MAL_INST_HOST = 192.168.0.3
MAL_INST_PORT = 5236
MAL_DW_PORT = 65121
MAL_INST_DW_PORT = 45121

dmarch.ini--------------------
[ARCHIVE_REALTIME]
ARCH_TYPE = REALTIME
ARCH_DEST = DMSVR01
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /dm8/arch
ARCH_FILE_SIZE = 128
ARCH_SPACE_LIMIT = 0

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

以 Mount 方式启动备库
./dmserver /dm8/data/DM01/dm.ini mount
SQL>
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);

---

三、监控机上配置：

dmmonitor.ini
MON_DW_CONFIRM = 1 
MON_LOG_PATH = /dm8/monitor/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.0.210:65101 
MON_DW_IP = 192.168.0.3:65121

---

四.启动验证

1.守护进程
主备库都要启动
./dmwatcher /dm8/data/DM01/dmwatcher.ini &

2.启动监视器
可在主库上运行，或单独一台
/dmmonitor /dm8/monitor/dmmonitor.ini
五、验证是否安装成功：
-----主库创建表test1
SQL> create table test1 as select * from sysobjects;
-----备库查询
SQL> select count(*) from test1;

=============================================================

可选：

主备机上：
/dm/script/root/dm_service_installer.sh -t dmwatcher -p DM01 -i /dm7/data/DAMENG/dmwatcher.ini
在监控机上：
/dm_service_installer.sh -t dmmonitor -p dmmonitor -i /dm7/data/DAMENG/dmmonitor.ini