DMDW数据守护搭建
1、主服务器安装数据库
./dminit charset=0 CASE_SENSITIVE=1 path=/dm/data PORT_NUM=5237
2、备服务器安装数据库
./dminit charset=0 CASE_SENSITIVE=1 path=/dm/data PORT_NUM=5236
- 注册服务主备的服务名不能相同
用root用户su - root
-t代表就是达梦服务固定就是dmserver、dmwatcher
./dm_service_installer.sh -t dmserver -p tmm -dm_ini /home/dmdba/data/DAMENG/dm.ini -m mount
- 第一次注册完需要起库用dmserver起库
./dmserver path=/home/dmdba/data/DAMENG/dm.ini修改参数
./disql sysdba:5237
SP_SET_PARA_VALUE (2,'DW_INACTIVE_INTERVAL',60);
SP_SET_PARA_VALUE (2,'ALTER_MODE_STATUS',0);
SP_SET_PARA_VALUE (2,'ENABLE_OFFLINE_TS',2);
SP_SET_PARA_VALUE (2,'MAL_INI',1);
SP_SET_PARA_VALUE (2,'RLOG_SEND_APPLY_MON',64);
- 配置文件修改
A机器
vi /home/dmdba/data/DAMENG/dmarch.ini
[ARCHIVE_LOCAL]
ARCH_TYPE =LOCAL
ARCH_DEST =/home/dmdba/data/arch
ARCH_FILE_SIZE =1024
ARCH_SPACE_LIMIT =51200
[ARCHIVE_REALTIME]
ARCH_TYPE =REALTIME
ARCH_DEST =tmm2 #填备库的实例名(dm.ini的instance_name如果相同则需要修改,主备库的需要不一致)
B机器
[dmdba@localhost bin]$ cat /home/dmdba/data/DAMENG/dmarch.ini
[ARCHIVE_LOCAL]
ARCH_TYPE =LOCAL
ARCH_DEST =/home/dmdba/data/arch
ARCH_FILE_SIZE =1024
ARCH_SPACE_LIMIT =51200
[ARCHIVE_REALTIME]
ARCH_TYPE =REALTIME
ARCH_DEST =tmm2
配置dmmal.ini参数(两台机器配置一样)
[dmdba@localhost bin]$ cat /home/dmdba/data/DAMENG/dmmal.ini
MAL_CHECK_INTERVAL = 10 #MAL链路检测时间间隔
MAL_CONN_FAIL_INTERVAL = 10 #判定MAL链路断开的时间
MAL_TEMP_PATH = /opt/tmp #临时文件目录
MAL_BUF_SIZE = 512 #单个MAL缓存大小,单位MB
MAL_SYS_BUF_SIZE = 2048 #MAL总大小限制,单位MB
MAL_COMPRESS_LEVEL = 0 #MAL消息压缩等级,0表示不压缩
[MAL_INST1]
MAL_INST_NAME = tmm #实例名,和 dm.ini的INSTANCE_NAME一致
MAL_HOST = 192.168.162.133 #MAL系统监听TCP连接的IP地址
MAL_PORT = 5230 #MAL系统监听TCP连接的端口
MAL_INST_HOST = 192.168.162.133 #实例的对外服务IP地址
MAL_INST_PORT = 5237 #实例对外服务端口,和dm.ini的PORT_NUM一致
MAL_DW_PORT = 4447 #实例对应的守护进程监听TCP连接的端口
MAL_INST_DW_PORT = 4448 #实例监听守护进程TCP连接的端口
[MAL_INST2]
MAL_INST_NAME = tmm2
MAL_HOST = 192.168.162.134
MAL_PORT = 5231
MAL_INST_HOST = 192.168.162.134
MAL_INST_PORT = 5236
MAL_DW_PORT = 4447
MAL_INST_DW_PORT = 4448
配置dmwatcher.ini(两台机器配置一样)
[dmdba@localhost bin]$ cat /home/dmdba/data/DAMENG/dmwatcher.ini
[GDW1]
DW_TYPE =GLOBAL
DW_MODE =AUTO
DW_ERROR_TIME =20
INST_ERROR_TIME =20
INST_RECOVER_TIME =60
INST_OGUID =453333
INST_INI =/home/dmdba/data/DAMENG/dm.ini
INST_AUTO_RESTART =1
INST_STARTUP_CMD =/home/dmdba/dmdbms/bin/dmserver
RLOG_SEND_THRESHOLD =0
RLOG_APPLY_THRESHOLD =0
在第3个机器
确认监视器配置:
[dmdba@localhost bin]$ cat /home/dmdba/data/DAMENG/dmmonitor.ini
MON_DW_CONFIRM =1(1是确认监视器,是非确认监视器)
MON_LOG_PATH =/home/dmdba/dmdbms/log/monitor_log
MON_LOG_INTERVAL =60
MON_LOG_FILE_SIZE =512
MON_LOG_SPACE_LIMIT =2048
[GDW1]
MON_INST_OGUID =453333(要跟底下的SP_SET_OGUID一样,主跟主)
MON_DW_IP =192.168.162.133:4447
MON_DW_IP =192.168.162.134:4447
普通监视器配置
MON_DW_CONFIRM =0 #(1是确认监视器,是非确认监视器)
MON_LOG_PATH =/home/dmdba/dmdbms/log/monitor_log
MON_LOG_INTERVAL =60
MON_LOG_FILE_SIZE =512
MON_LOG_SPACE_LIMIT =2048
[GDW1]
MON_INST_OGUID =453333 #(要跟底下的SP_SET_OGUID一样,主跟主)
MON_DW_IP =192.168.162.133:4447
MON_DW_IP =192.168.162.134:4447
6、主库停机备份
./dmrman
backup database '/home/dmdba/data/DAMENG/dm.ini' full backupset '/home/dmdba/backup';
scp -r /home/dmdba/backup dmdba@192.168.162.134:/home/dmdba/
7、备库恢复
./dmrman
restore database '/home/dmdba/data/DAMENG/dm.ini' from backupset '/home/dmdba/backup';
recover database '/home/dmdba/data/DAMENG/dm.ini' from backupset '/home/dmdba/backup';
recover database '/home/dmdba/data/DAMENG/dm.ini' update db_magic;
8、注册服务(两个节点都执行)
用root用户su - root
-t代表就是达梦服务固定就是dmserver、dmwatcher
./dm_service_installer.sh -t dmserver -p tmm -dm_ini /home/dmdba/data/DAMENG/dm.ini -m mount
./dm_service_installer.sh -t dmwatcher -p watcher -watcher_ini /home/dmdba/data/DAMENG/dmwatcher.ini
./dm_service_installer.sh -t dmmonitor -p monitor -monitor_ini /home/dmdba/data/DAMENG/dmmonitor.ini(监视器服务器执行)
9、启动数据库改配置
主库:
[dmdba@localhost bin]$ ls -l DmSer*
-rwxr-xr-x. 1 dmdba dinstall 17383 Jun 13 15:40 DmServiceDMSERVER
-rwxr-xr-x. 1 dmdba dinstall 17386 Jun 13 15:55 DmServiceDMSERVERttt
-rwxr-xr-x 1 dmdba dinstall 17379 Jun 14 00:15 DmServicetmm
-rwxr-xr-x 1 dmdba dinstall 17379 Jun 13 23:50 DmServicewzp
./DmServicetmm start
./disql
SP_SET_PARA_VALUE(1,'ALTER_MODE_STATUS',1);
SP_SET_OGUID(453333);
alter database primary;
SP_SET_PARA_VALUE(1,'ALTER_MODE_STATUS',0);
停库
备库:
[dmdba@localhost bin]$ ls -l DmService*
-rwxr-xr-x. 1 dmdba dinstall 17383 Jun 13 15:40 DmServiceDMSERVER
-rwxr-xr-x. 1 dmdba dinstall 17386 Jun 13 15:55 DmServiceDMSERVERttt
-rwxr-xr-x 1 dmdba dinstall 17380 Jun 14 00:07 DmServicetmm2
./DmServicetmm2 start
./disql
SP_SET_PARA_VALUE(1,'ALTER_MODE_STATUS',1);
SP_SET_OGUID(453333);
alter database standby;
SP_SET_PARA_VALUE(1,'ALTER_MODE_STATUS',0);
停库
10、启动数据守护程序(主备都执行)
./DmWatcherServicewatcher start
11、监视器服务器启动监视器服务
./DmMonitorServicemonitor start
12用普通监视器查看是否监控成功
./dmmonitor path=/home/dmdba/data/DAMENG/dmmonitor_nor.ini
用show命令能看到集群信息即为成功
http://eco.dameng.com