达梦数据库DSC搭建

1.dmdba用户创建目录
节点一：
mkdir -p /data/dmdbms
mkdir -p /data/dmdsc/dsc0
mkdir -p /data/dmdsc/monitor_log
节点二：
mkdir -p /data/dmdbms
mkdir -p /data/dmdsc/dsc1
mkdir -p /data/dmdsc/monitor_log

2.绑定磁盘(uuid方式)
###获取磁盘ID
/usr/lib/udev/scsi_id -g -u /dev/<disk_name>
###创建udev绑定脚本
#!/bin/bash
for i in b c d e f ;
do
echo “KERNEL==“sd*”,SUBSYSTEM==“block”,PROGRAM==”/lib/udev/scsi_id -g -u -d /dev/$name",RESULT==“/lib/udev/scsi_id -g -u -d /dev/sd$i”,SYMLINK+=“dm/ASM-xxx”,OWNER=“dmdba”,GROUP=“dinstall”,MODE=“0660"”
done
注意：执行uuid.sh后输出的内容复制粘贴到 vi /etc/udev/rules.d/dm-asm.rules
###重启udev服务
systemctl restart systemd-udev-trigger
###授权所有节点
chown -R dmdba:dinstall /dev/dm
###查看映射关系
ls -lth /dev/dm/

3.DM8软件安装
./DMInstall.bin -i

4.创建dmdcr_cfg.ini
###配置文件
DCR_N_GRP= 3
DCR_VTD_PATH=/dev/dm/ASM-vote ##与实际绑定的vote一致
DCR_OGUID= 115612 ##dmcssm.ini文件要一致
[GRP]
DCR_GRP_TYPE = CSS
DCR_GRP_NAME = GRP_CSS
DCR_GRP_N_EP = 2 ##节点数 max=8
DCR_GRP_DSKCHK_CNT = 60

[GRP_CSS]
DCR_EP_NAME = CSS0
DCR_EP_HOST = 192.168.56.11 ##内网通讯IP
DCR_EP_PORT = 11286 ##dmcssm.ini监控端口

[GRP_CSS]
DCR_EP_NAME = CSS1
DCR_EP_HOST = 192.168.56.12 ##内网通讯IP
DCR_EP_PORT = 11286 ##dmcssm.ini监控端口

[GRP]
DCR_GRP_TYPE= ASM
DCR_GRP_NAME= GRP_ASM
DCR_GRP_N_EP= 2
DCR_GRP_DSKCHK_CNT= 60

[GRP_ASM]
DCR_EP_NAME= ASM0 ##dmasvrmal.ini要一致
DCR_EP_SHM_KEY= 5611 ##每个ASM唯一，以ip起名
DCR_EP_SHM_SIZE= 512 ##根据实际内存分配
DCR_EP_HOST= 192.168.56.11 ##内网通讯IP
DCR_EP_PORT= 11276
DCR_EP_ASM_LOAD_PATH= /dev/dm ##与绑定udev目录一致

[GRP_ASM]
DCR_EP_NAME= ASM1 ##dmasvrmal.ini要一致
DCR_EP_SHM_KEY= 5612 ##每个ASM唯一，以ip起名
DCR_EP_SHM_SIZE= 512
DCR_EP_HOST= 192.168.56.12 ##内网通讯IP
DCR_EP_PORT= 11276
DCR_EP_ASM_LOAD_PATH= /dev/dm

[GRP]
DCR_GRP_TYPE= DB
DCR_GRP_NAME= GRP_DSC
DCR_GRP_N_EP= 2
DCR_GRP_DSKCHK_CNT= 60

[GRP_DSC]
DCR_EP_NAME= DSC0 ##dmdcr.ini要一致
DCR_EP_SEQNO= 0
DCR_EP_PORT= 5236 ##数据库端口
DCR_CHECK_PORT= 11256 ##DCR 检查端口
[GRP_DSC]
DCR_EP_NAME= DSC1
DCR_EP_SEQNO= 1
DCR_EP_PORT= 5236
DCR_CHECK_PORT= 11256 ##DCR 检查端口

5.初始化ASM磁盘（主节点执行即可）
./dmasmcmd
create dcrdisk ‘/dev/dm/ASM-dcr’ ‘DCR’
create votedisk ‘/dev/dm/ASM-vote’ ‘VOTE’
init dcrdisk ‘/dev/dm/ASM-dcr’ from ‘/data/dmdsc/dmdcr_cfg.ini’ identified by ‘SYSDBA’
init votedisk ‘/dev/dm/ASM-vote’ from ‘/data/dmdsc/dmdcr_cfg.ini’
create asmdisk ‘/dev/dm/ASM-data’ ‘DATA’
create asmdisk ‘/dev/dm/ASM-log’ ‘LOG’
create asmdisk ‘/dev/dm/ASM-arch’ ‘ARCH’

6.创建dmasvrmal.ini
[MAL_INST1]
MAL_INST_NAME= ASM0 #与dmdcr_cfg.ini中一致
MAL_HOST= 192.168.56.11
MAL_PORT= 11266 #ASM内部通讯端口
[MAL_INST2]
MAL_INST_NAME= ASM1
MAL_HOST= 192.168.56.12
MAL_PORT= 11266

7.创建dmdcr.ini
DMDCR_PATH = /dev/dm/ASM-dcr #udev绑定的dcr盘
DMDCR_MAL_PATH = /data/dmdsc/dmasvrmal.ini
DMDCR_SEQNO = <0/1> #每个节点唯一
DMDCR_AUTO_OPEN_CHECK = 111
DMDCR_ASM_TRACE_LEVEL = 2
#DMDCR_ASM_RESTART_INTERVAL = 60
#DMDCR_ASM_STARTUP_CMD = /data/dmdbms/bin/DmASMSvrServiceASM start
#DMDCR_DB_RESTART_INTERVAL = 60
#DMDCR_DB_STARTUP_CMD = /data/dmdbms/bin/DmServiceDSC start
#DMDCR_LINK_CHECK_IP=<第三方机器IP>

8.启动css,asm服务
###主节点先启动CSS，其它节点再启动
/data/dmdbms/bin/dmcss DCR_INI=/data/dmdsc/dmdcr.ini
###主节点先启动ASM，其它节点再启动（ASM两节点都起来才会没有invalid）
/data/dmdbms/bin/dmasmsvr DCR_INI=/data/dmdsc/dmdcr.ini

9.划分ASM磁盘组
###主节点启动dmasmtool
/data/dmdbms/bin/dmasmtool DCR_INI=/data/dmdsc/dmdcr.ini
create diskgroup ‘DMLOG’ asmdisk ‘/dev/dm/ASM-log’
create diskgroup ‘DMDATA’ asmdisk ‘/dev/dm/ASM-data’
create diskgroup ‘DMARCH’ asmdisk ‘/dev/dm/ASM-arch’

10.初始化实例（主节点执行此步）
###上传dminit.ini文件
###初始化实例
/data/dmdbms/bin/dminit control=/data/dmdsc/dminit.ini
DB_NAME = DSC
SYSDBA_PWD = SYSDBA_PWD
SYSTEM_PATH = +DMDATA/data
SYSTEM = +DMDATA/data/SYSTEM.dbf
SYSTEM_SIZE = 1024
ROLL = +DMDATA/data/ROLL.dbf
ROLL_SIZE = 10240
MAIN = +DMDATA/data/MAIN.dbf
MAIN_SIZE = 1024
CTL_PATH = +DMDATA/data/dm.ctl
CTL_SIZE = 8
LOG_SIZE = 2048
DCR_PATH = /dev/dm/ASM-dcr
DCR_SEQNO = 0
AUTO_OVERWRITE = 1
PAGE_SIZE = 32
EXTENT_SIZE = 16
BLANK_PAD_MODE = 1

[DSC0]
CONFIG_PATH = /data/dmdsc/dsc0/
PORT_NUM = 5236
MAL_HOST = 192.168.56.11
MAL_PORT = 11246
LOG_PATH = +DMLOG/DSC0_LOG01.log
LOG_PATH = +DMLOG/DSC0_LOG02.log
[DSC1]
CONFIG_PATH = /data/dmdsc/dsc1/
PORT_NUM = 5236
MAL_HOST = 192.168.56.12
MAL_PORT = 11246
LOG_PATH = +DMLOG/DSC1_LOG01.log
LOG_PATH = +DMLOG/DSC1_LOG02.log
###注意[DSC实例名] 与dmdcr_cfg.ini一样,初始化后会出现dsc2目录，scp到其它对应节点。

11.配置归档
###修改dm.ini
ARCH_INI=1
###注意内存相关参数设置
###上传配置dmarch.ini
ARCH_WAIT_APPLY = 0
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = +DMARCH/ARCH/DSC0/arch
ARCH_FILE_SIZE = 2048
ARCH_SPACE_LIMIT = 102400
[ARCHIVE_REMOTE1]
ARCH_TYPE = REMOTE
ARCH_DEST = DSC1 #对端节点
ARCH_INCOMING_PATH = +DMARCH/ARCH/DSC1/arch #对端节点目录
ARCH_FILE_SIZE = 2048
ARCH_SPACE_LIMIT = 102400

12.启动实例dmserver
###主节点先启动
/data/dmdbms/bin/dmserver /data/dmdsc/dsc0/dm.ini dcr_ini=/data/dmdsc/dmdcr.ini
###其它节点启动
/data/dmdbms/bin/dmserver /data/dmdsc/dsc1/dm.ini dcr_ini=/data/dmdsc/dmdcr.ini

13.监视器配置dmcssm.ini
###上传dmcssm.ini文件
CSSM_OGUID = 115612 #与dmdcr_cfg.ini一致
CSSM_CSS_IP = 192.168.56.11:11286 #与dmdcr_cfg.ini一致
CSSM_CSS_IP = 192.168.56.12:11286
CSSM_LOG_PATH = /data/dmdsc/monitor_log
CSSM_LOG_FILE_SIZE = 512
CSSM_LOG_SPACE_LIMIT = 2048

14.root授权ping
sudo setcap cap_net_raw,cap_net_admin=eip /data/dmdbms/bin/dmserver
sudo setcap cap_net_raw,cap_net_admin=eip /data/dmdbms/bin/dmasmsvr
###验证是否回文
getcap /data/dmdbms/bin/dmserver
getcap /data/dmdbms/bin/dmasmsvr

15.root注册服务
###注册CSS
/data/dmdbms/script/root/dm_service_installer.sh -t dmcss -dcr_ini /data/dmdsc/dmdcr.ini -p CSS
###注册ASM
/data/dmdbms/script/root/dm_service_installer.sh -t dmasmsvr -dcr_ini /data/dmdsc/dmdcr.ini -y DmCSSServiceCSS.service -p ASM
###注册DSC 目录变化
/data/dmdbms/script/root/dm_service_installer.sh -t dmserver -dm_ini /data/dmdsc/dsc0/dm.ini -dcr_ini /data/dmdsc/dmdcr.ini -y DmASMSvrServiceASM.service -p DSC
###注册monitor
/data/dmdbms/script/root/dm_service_installer.sh -t dmcssm -cssm_ini /data/dmdsc/dmcssm.ini -p Monitor

附加：注销服务
/data/dmdbms/script/root/dm_service_uninstaller.sh -n DmCSSServiceCSS
/data/dmdbms/script/root/dm_service_uninstaller.sh -n DmASMSvrServiceASM
/data/dmdbms/script/root/dm_service_uninstaller.sh -n DmServiceDSC
/data/dmdbms/script/root/dm_service_uninstaller.sh -n DmCSSMonitorServiceMonitor

16.验证DSC集群
###启动monitor，连接
DmCSSMonitorServiceMonitor start
dmcssm ini_path=/data/dmdsc/dmcssm.ini

17.服务启动和关闭DSC
1/2 机器： /data/dmdbms/bin/DmServiceDSC stop
1/2 机器： /data/dmdbms/bin/DmASMSvrServiceASM stop
1/2 机器： /data/dmdbms/bin/DmCSSServiceCSS stop