热门搜索
分布式
数据库一体机
云数据库
建设银行
保险核心
密集交易
注册
DSC三节点部署
技术分享/ 文章详情 /

DSC三节点部署

为什么小孩不听话 2022/11/28 1688 0 0

达梦三节点DSC部署方案

达梦数据库公司
2022年11月17日
目录

目录
1.环境规划 4
1.1 架构图 4
1.2服务器配置 4
1.3集群信息 6
2.操作系统调整 7
2.1创建用户和组 7
2.2操作系统资源限制要求 7
2.3防火墙策略要求 7
2.4磁盘调度算法检查 8
2.5操作系统内存参数检查 8
2.6 操作系统内核参数连接存储模式 8
2.7操作系统内核参数相关配置 8
2.8禁用SELinux 8
2.9关闭透明大页 9
2.10关闭numa 9
2.11调整core文件路径 9
2.12开启CPU高性能模式 9
3.共享磁盘绑定 10
3.1 rules配置 10
4.数据库软件安装 11
4.1数据库软件安装 11
5.DMDSC搭建 12
5.1配置dmdcr_cfg.ini 12
5.2 DMASMCMD工具初始化磁盘 14
5.3配置dmasvrmal.ini 15
5.4配置dmdcr.ini 15
5.5启动CSS ASM服务 16
5.6 DMASMTOOL工具创建ASM磁盘组 17
5.7配置dminit.ini 17
5.8初始化数据库 19
5.9配置归档 19
5.10启动dmserver 22
5.11启动DSC集群 22
5.12配置监视器 24
6.其他配置 25
6.1dm_svc.conf配置 25
6.2 sqllog配置 25
6.3 设置备份策略 26

1.环境规划
1.1 架构图

1.2服务器配置
机器名 心跳IP 业务ip
DSC0 10.10.228.246 10.10.228.246
DSC1 10.10.228.247 10.10.228.247
DSC2 10.10.228.238 10.10.228.238
具体配置请跟据业务实际需求进行合理规划

1.3集群信息

数据库名 类型 路径
dsc0_config、dsc1_config、
dsc2_config 软件安装目录 /opt/sy/DM/bin
DSC配置文件目录 /opt/sy/dsc/
临时表空间目录 临时表空间可存放在本地或者ASM共享存储上，在本地磁盘速度大于等于asm的时候建议放本地，可根据实际情况调整dm.ini配置文件中TEMP_PATH参数，自定义路径

+DMDATA/data/dsc

SQL日志目录	/opt/sy/dsc/dsc0_config/logcommit
备份目录	/opt/sy/DM_BAK
实例相关参数
实例目录	/opt/sy/dsc/dsc*_config
实例名	DSC0、DSC1、DSC2
页大小	32
簇大小	32
端口	5236
字符集	UTF-8
是否以字符为单位	1
结尾空格填充模式是否兼容ORACLE	0
大小写是否敏感	0
redo日志目录	+LOG/log/
redo日志大小	2048M*2/每节点
归档日志目录	+LOG/DSC/arch_0

+LOG/DSC/arch_1
+LOG/DSC/arch_2
归档日志大小及上限 1024M 25600M/每节点

2.操作系统调整

r2.1创建用户和组
#创建安装用户组 dinstall
groupadd dinstall
#在dinstall组内创建安装用户dmdba
useradd -g dinstall -m -d /home/dmdba -s /bin/bash dmdba
#修改密码
passwd dmdba
dmdba

2.2操作系统资源限制要求
vi /etc/security/limits.conf
#增加下述内容
dmdba soft nice 0
dmdba hard nice 0
dmdba soft as unlimited
dmdba hard as unlimited
dmdba soft fsize unlimited
dmdba hard fsize unlimited
dmdba soft nproc 131072
dmdba hard nproc 131072
dmdba soft nofile 131072
dmdba hard nofile 131072
dmdba soft core unlimited
dmdba hard core unlimited
dmdba soft data unlimited
dmdba hard data unlimited
dmdba soft memlock unlimited
dmdba hard memlock unlimited

2.3防火墙策略要求

建议关闭操作系统防火墙，如果防火墙开启，需要配置端口开放策略
iptables -F
systemctl stop firewalld.service
systemctl disable firewalld.service
2.4磁盘调度算法检查
要求磁盘调度算法采用deadline
#查看
cat /sys/block/sda/queue/scheduler
#如果不是deadline，需要按如下步骤进行调整：
vim /lib/udev/rules.d/60-block-scheduler.rules
修改为mq-deadline
#重启后生效

2.5操作系统内存参数检查
要求设置为0
#查看
cat /proc/sys/vm/overcommit_memory
#如果不是0，需要按如下步骤进行调整：
vim /etc/sysctl.conf
修改vm.overcommit_memory=0
执行sysctl -p 使配置文件生效

2.6 关闭numa和透明大页uos20
root@PC:/boot/grub/# cd /boot/grub/
root@PC:/boot/grub/# chmod 644 grub.cfg
root@PC:/boot/grub/# vi /boot/grub/grub.cfg
----搜索DEEPIN_GFXMODE关键字，在行末尾添加参数:
numa=off transparent_hugepage=never
root@PC:/boot/grub/# chmod 444 grub.cfg
reboot重启

2.7调整core文件路径
cat << EOF >> /etc/sysctl.d/coredump.conf
kernel.core_uses_pid = 0
kernel.core_pattern = /opt/corefile/core-%p-%u-%g-%s-%t-%h-%e
EOF
sysctl -p /etc/sysctl.d/coredump.conf
验证：
kill -s 11 dmpid
对应路径/opt/corefile/会生成core文件

3.共享磁盘绑定
3.1 rules配置
下面举例共享存储划分的4块盘分别为sdc（用做DATA数据盘,日志盘）、sdd（用做DCR盘）、sde（用做VOTE盘）、sdf（用做LOG数据盘）、
1.cat uuid.sh
curr=$(cd “$(dirname “$0”)”;pwd)
rm -f $curr/88-dm-asmdevices.rules
for i in c d e f;
do
echo “KERNEL==“sd?”,SUBSYSTEM==“block”, PROGRAM==”/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT==“/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/sd$i”, SYMLINK+=“asm-disk$i”,OWNER=“dmdba”, GROUP=“dinstall”,MODE=“0660"” >> $curr/88-dm-asmdevices.rules
done
2.将uuid脚本放至DSC集群DSC0节点上，执行脚本会在当前路径下生成88-dm-asmdevices.rules配置文件
chmod +x uuid.sh
./uuid.sh

3.cat 88-dm-asmdevices.rules
KERNEL==“sd?”,SUBSYSTEM==“block”, PROGRAM==“/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name”,RESULT==“36dcef801005585a17c302803000001e3”, SYMLINK+=“asm-diskc”,OWNER=“dmdba”, GROUP=“dinstall”,MODE=“0660”
KERNEL==“sd?”,SUBSYSTEM==“block”, PROGRAM==“/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name”,RESULT==“36dcef801005585a17e62817d000001ea”, SYMLINK+=“asm-diskd”,OWNER=“dmdba”, GROUP=“dinstall”,MODE=“0660”
KERNEL==“sd?”,SUBSYSTEM==“block”, PROGRAM==“/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name”,RESULT==“36dcef801005585a17e6281c0000001eb”, SYMLINK+=“asm-diske”,OWNER=“dmdba”, GROUP=“dinstall”,MODE=“0660”
KERNEL==“sd?”,SUBSYSTEM==“block”, PROGRAM==“/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name”,RESULT==“36dcef801005585a17e62bb58000001ec”, SYMLINK+=“asm-diskf”,OWNER=“dmdba”, GROUP=“dinstall”,MODE=“0660”

  1. 复制 88-dm-asmdevices.rules 配置文件到DSC集群的所有节点的/etc/udev/rules.d/目录下
    scp 88-dm-asmdevices.rules /etc/udev/rules.d/88-dm-asmdevices.rules
  2. 使配置文件生效，执行下述命令：
    udevadm control --reload-rules
    udevadm trigger
    6.检查是否生效：
    ls -ll /dev/asm-disk*
    4.数据库软件安装
    4.1数据库软件安装
    每个节点分别进行DM程序安装
    mount -o loop dm8.iso /mnt
    su – dmdba
    cd /mnt/
    ./DMInstall.bin -i

5.DMDSC搭建
5.1配置dmdcr_cfg.ini
DSC0机器的/opt/sy/dsc下编辑dmdcr_cfg.ini文件：
DCR_N_GRP = 3
DCR_VTD_PATH = /dev/asm-diske
DCR_OGUID = 221114

[GRP]
DCR_GRP_TYPE = CSS
DCR_GRP_NAME = GRP_CSS
DCR_GRP_N_EP = 3
DCR_GRP_DSKCHK_CNT = 60

[GRP_CSS]
DCR_EP_NAME = CSS0
DCR_EP_HOST = 10.10.228.246
DCR_EP_PORT = 9341
[GRP_CSS]
DCR_EP_NAME = CSS1
DCR_EP_HOST = 10.10.228.247
DCR_EP_PORT = 9343
[GRP_CSS]
DCR_EP_NAME = CSS2
DCR_EP_HOST = 10.10.228.238
DCR_EP_PORT = 9345

[GRP]
DCR_GRP_TYPE = ASM
DCR_GRP_NAME = GRP_ASM
DCR_GRP_N_EP = 3
DCR_GRP_DSKCHK_CNT = 60
[GRP_ASM]
DCR_EP_NAME = ASM0
DCR_EP_SHM_KEY = 93360
DCR_EP_SHM_SIZE = 20
DCR_EP_HOST = 10.10.228.246
DCR_EP_PORT = 9349
DCR_EP_ASM_LOAD_PATH = /dev
[GRP_ASM]
DCR_EP_NAME = ASM1
DCR_EP_SHM_KEY = 93361
DCR_EP_SHM_SIZE = 20
DCR_EP_HOST = 10.10.228.247
DCR_EP_PORT = 9351
DCR_EP_ASM_LOAD_PATH = /dev
[GRP_ASM]
DCR_EP_NAME = ASM2
DCR_EP_SHM_KEY = 93363
DCR_EP_SHM_SIZE = 20
DCR_EP_HOST = 10.10.228.238
DCR_EP_PORT = 9353
DCR_EP_ASM_LOAD_PATH = /dev

[GRP]
DCR_GRP_TYPE = DB
DCR_GRP_NAME = GRP_DSC
DCR_GRP_N_EP = 3
DCR_GRP_DSKCHK_CNT = 60
[GRP_DSC]
DCR_EP_NAME = DSC0
DCR_EP_SEQNO = 0
DCR_EP_PORT = 5236
DCR_CHECK_PORT = 9741
[GRP_DSC]
DCR_EP_NAME = DSC1
DCR_EP_SEQNO = 1
DCR_EP_PORT = 5236
DCR_CHECK_PORT = 9742
[GRP_DSC]
DCR_EP_NAME = DSC2
DCR_EP_SEQNO = 2
DCR_EP_PORT = 5236
DCR_CHECK_PORT = 9743

5.2 DMASMCMD工具初始化磁盘
DSC0机器上操作
[dmdba@DSC0 ~]$ cd /opt/sy/DM/bin
[dmdba@DSC0 bin]$ ./dmasmcmd
DMASMCMD V8
ASM> create dcrdisk ‘/dev/asm-diskd’ ‘dcr’
ASM> create votedisk ‘/dev/asm-diske’ ‘vote’
ASM> create asmdisk ‘/dev/asm-diskf’ ‘LOG’
ASM> create asmdisk ‘/dev/asm-diskc’ ‘DMDATA’
ASM> init dcrdisk ‘/dev/asm-diskd’ from ‘/opt/sy/dsc/dmdcr_cfg.ini’ identified by ‘abcd’
ASM> init votedisk ‘/dev/asm-diske’ from ‘/opt/sy/dsc/dmdcr_cfg.ini’
ASM> exit
5.3配置dmasvrmal.ini
DSC0机器的 /opt/sy/dsc下编辑dmasvrmal.ini文件，并复制到DSC1、DSC2上
MAL_INST_NAME = ASM0
MAL_HOST = 10.10.228.246
MAL_PORT = 7236
[MAL_INST2]
MAL_INST_NAME = ASM1
MAL_HOST = 10.10.228.247
MAL_PORT = 7237
[MAL_INST3]
MAL_INST_NAME = ASM2
MAL_HOST = 10.10.228.238
MAL_PORT = 7238
拷贝至DSC1、DSC2
scp -r /opt/sy/dsc/dmasvrmal.ini dmdba@10.10.228.247:/opt/sy/dsc/
scp -r /opt/sy/dsc/dmasvrmal.ini dmdba@10.10.228.238:/opt/sy/dsc/

5.4配置dmdcr.ini
DSC0机器的 /opt/sy/dsc下编辑dmdcr.ini文件，注意每个DSC节点上DMDCR_SEQNO一定不同 （注意，第一次搭建时先不开自动拉起，DMDCR_ASM_RESTART_INTERVAL和DMDCR_DB_RESTART_INTERVAL先设置为0或注释掉，搭建成功后续创建服务后，再改回）
DMDCR_PATH = /dev/asm-diskd
DMDCR_MAL_PATH =/opt/sy/dsc/dmasvrmal.ini #dmasmsvr 使用的 MAL 配置文件路径
DMDCR_SEQNO = 0
#ASM重启参数，命令行方式启动
#DMDCR_ASM_RESTART_INTERVAL = 30
#DMDCR_ASM_STARTUP_CMD = /opt/sy/DM/bin/DmASMSvrServiceDSC0 start
#DB重启参数，命令行方式启动
#DMDCR_DB_RESTART_INTERVAL = 60
#DMDCR_DB_STARTUP_CMD =/opt/sy/DM/bin/DmServiceDSC0 start
#DMDCR_AUTO_OPEN_CHECK=60
DSC1机器的/opt/sy/dsc下编辑dmdcr.ini文件
DMDCR_PATH = /dev/asm-diskd
DMDCR_MAL_PATH =/opt/sy/dsc/dmasvrmal.ini #dmasmsvr 使用的 MAL 配置文件路径
DMDCR_SEQNO = 1
#ASM重启参数，命令行方式启动
#DMDCR_ASM_RESTART_INTERVAL = 30
#DMDCR_ASM_STARTUP_CMD = /opt/sy/DM/bin/DmASMSvrServiceDSC1 start
#DB重启参数，命令行方式启动
#DMDCR_DB_RESTART_INTERVAL = 60
#DMDCR_DB_STARTUP_CMD =/opt/sy/DM/bin/DmServiceDSC1 start
#DMDCR_AUTO_OPEN_CHECK=60
DSC2机器的/opt/sy/dsc下编辑dmdcr.ini文件
DMDCR_PATH = /dev/asm-diskd
DMDCR_MAL_PATH =/opt/sy/dsc/dmasvrmal.ini #dmasmsvr 使用的 MAL 配置文件路径
DMDCR_SEQNO = 2
#ASM重启参数，命令行方式启动
#DMDCR_ASM_RESTART_INTERVAL = 30
#DMDCR_ASM_STARTUP_CMD = /opt/sy/DM/bin/DmASMSvrServiceDSC2 start
#DB重启参数，命令行方式启动
#DMDCR_DB_RESTART_INTERVAL = 60
#DMDCR_DB_STARTUP_CMD =/opt/sy/DM/bin/DmServiceDSC2 start
#DMDCR_AUTO_OPEN_CHECK=60
5.5启动CSS ASM服务
#先按照序号顺序前台启动每个DSC节点的CSS服务
cd /opt/sy/DM/bin
./dmcss DCR_INI=/opt/sy/dsc/dmdcr.ini
#再按照序号顺序前台启动每个DSC节点的ASM服务
cd /opt/sy/DM/bin
./dmasmsvr DCR_INI=/opt/sy/dsc/dmdcr.ini
5.6 DMASMTOOL工具创建ASM磁盘组
DSC0机器上操作
cd /opt/sy/DM/bin
/opt/sy/DM/bin/dmasmtool DCR_INI=/opt/sy/dsc/dmdcr.ini
#创建日志磁盘组
create diskgroup ‘LOG’ asmdisk ‘/dev/asm-diskf’
#创建数据(和日志)磁盘组
create diskgroup ‘DMDATA’ asmdisk ‘/dev/asm-diskc’

5.7配置dminit.ini
DSC0机器/opt/sy/dsc下编辑dminit.ini文件：
db_name = dsc
system_path = +DMDATA/data
system = +DMDATA/data/dsc/SYSTEM.DBF
system_size = 128
roll = +DMDATA/data/dsc/ROLL.DBF
roll_size = 128
main = +DMDATA/data/dsc/MAIN.DBF
main_size = 128
ctl_path = +DMDATA/data/dsc/dm.ctl
ctl_size = 8
log_size = 2048
dcr_path = /dev/asm-diskd
dcr_seqno = 0
auto_overwrite = 1
PAGE_SIZE = 32
EXTENT_SIZE = 32
CASE_SENSITIVE =0
length_in_char=1
CHARSET = 1
[DSC0]
config_path = /opt/sy/dsc/dsc0_config
port_num = 5236
mal_host = 10.10.228.246
mal_port = 9140
log_path = +LOG/log/dsc0_log01.log
log_path = +LOG/log/dsc0_log02.log
[DSC1]
config_path = /opt/sy/dsc/dsc1_config
port_num = 5236
mal_host = 10.10.228.247
mal_port = 9141
log_path = +LOG/log/dsc1_log01.log
log_path = +LOG/log/dsc1_log02.log
[DSC2]
config_path = /opt/sy/dsc/dsc2_config
port_num = 5236
mal_host = 10.10.228.238
mal_port = 9142
log_path = +LOG/log/dsc2_log01.log
log_path = +LOG/log/dsc2_log02.log

5.8初始化数据库
##在DSC0上启动dminit工具初始化数据库
./dminit control=/opt/sy/dsc/dminit.ini
##会在/opt/sy/dsc目录下生成三个实例相关配置文件目录，将dsc1_config目录拷贝至DSC1机器/opt/sy/dsc/，将dsc2_config目录拷贝至DSC2机器/opt/sy/dsc/
scp -r /opt/sy/dsc/dsc1_config dmdba@10.10.228.247:/opt/sy/dsc/
scp -r /opt/sy/dsc/dsc2_config dmdba@10.10.228.238:/opt/sy/dsc/
5.9配置归档
在三台服务器/opt/sy/dsc/dsc*config目录下配置dmarch.ini文件

DSC0:
ARCH_LOCAL_SHARE = 1
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = +LOG/DSC/arch_0
ARCH_FILE_SIZE = 1024
ARCH_SPACE_LIMIT = 25600
[ARCH_REMOTE1]
ARCH_TYPE = REMOTE
ARCH_DEST = DSC1
ARCH_INCOMING_PATH = +LOG/DSC/arch_1
ARCH_FILE_SIZE = 1024
ARCH_SPACE_LIMIT = 25600
[ARCH_REMOTE2]
ARCH_TYPE = REMOTE
ARCH_DEST = DSC2
ARCH_INCOMING_PATH = +LOG/DSC/arch_2
ARCH_FILE_SIZE = 1024
ARCH_SPACE_LIMIT = 25600
DSC1:
ARCH_LOCAL_SHARE = 1
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = +LOG/DSC/arch_1
ARCH_FILE_SIZE = 1024
ARCH_SPACE_LIMIT = 25600
[ARCH_REMOTE1]
ARCH_TYPE = REMOTE
ARCH_DEST = DSC0
ARCH_INCOMING_PATH = +LOG/DSC/arch_0
ARCH_FILE_SIZE = 1024
ARCH_SPACE_LIMIT = 25600
[ARCH_REMOTE2]
ARCH_TYPE = REMOTE
ARCH_DEST = DSC2
ARCH_INCOMING_PATH = +LOG/DSC/arch_2
ARCH_FILE_SIZE = 1024
ARCH_SPACE_LIMIT = 25600
DSC2:
ARCH_LOCAL_SHARE = 1
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = +LOG/DSC/arch_2
ARCH_FILE_SIZE = 1024
ARCH_SPACE_LIMIT = 25600
[ARCH_REMOTE1]
ARCH_TYPE = REMOTE
ARCH_DEST = DSC0
ARCH_INCOMING_PATH = +LOG/DSC/arch_0
ARsCH_FILE_SIZE = 1024
ARCH_SPACE_LIMIT = 25600
[ARCH_REMOTE2]
ARCH_TYPE = REMOTE
ARCH_DEST = DSC1
ARCH_INCOMING_PATH = +LOG/DSC/arch_1
ARCH_FILE_SIZE = 1024
ARCH_SPACE_LIMIT = 25600
5.10启动dmserver
#分别前台启动三台服务器实例
cd /opt/sy/DM/bin
./dmserver /opt/sy/dsc/dsc0_config/dm.ini dcr_ini=/opt/sy/dsc/dmdcr.ini
./dmserver /opt/sy/dsc/dsc1_config/dm.ini dcr_ini=/opt/sy/dsc/dmdcr.ini
./dmserver /opt/sy/dsc/dsc2_config/dm.ini dcr_ini=/opt/sy/dsc/dmdcr.ini

5.11启动DSC集群
#前台服务全部exit退出后，root用户注册服务

DSC0:

cd /opt/sy/DM/script/root
./dm_service_installer.sh -t dmcss -p DSC0 -dcr_ini /opt/sy/dsc/dmdcr.ini
./dm_service_installer.sh -t dmasmsvr -p DSC0 -dcr_ini /opt/sy/dsc/dmdcr.ini -y DmCSSServiceDSC0
./dm_service_installer.sh -t dmserver -p DSC0 -dm_ini /opt/sy/dsc/dsc0_config/dm.ini -dcr_ini /opt/sy/dsc/dmdcr.ini -y DmASMSvrServiceDSC0

DSC1:

cd /opt/dmdbms/script/root/
./dm_service_installer.sh -t dmcss -p DSC1 -dcr_ini /opt/sy/dsc/dmdcr.ini
./dm_service_installer.sh -t dmasmsvr -p DSC1 -dcr_ini /opt/sy/dsc/dmdcr.ini -y DmCSSServiceDSC1
./dm_service_installer.sh -t dmserver -p DSC1 -dm_ini /opt/sy/dsc/dsc1_config/dm.ini -dcr_ini /opt/sy/dsc/dmdcr.ini -y DmASMSvrServiceDSC1

DSC2:

cd /opt/dmdbms/script/root/
./dm_service_installer.sh -t dmcss -p DSC2 -dcr_ini /opt/sy/dsc/dmdcr.ini
./dm_service_installer.sh -t dmasmsvr -p DSC2 -dcr_ini /opt/sy/dsc/dmdcr.ini -y DmCSSServiceDSC2
./dm_service_installer.sh -t dmserver -p DSC2 -dm_ini /opt/sy/dsc/dsc2_config/dm.ini -dcr_ini /opt/sy/dsc/dmdcr.ini -y DmASMSvrServiceDSC2
#修改三个节点的dmdcr.ini文件，将部署时自动拉起注释的内容重新加上，如下：
#DSC0：
DMDCR_PATH = /dev/asm-diskd
DMDCR_MAL_PATH =/opt/sy/dsc/dmasvrmal.ini #dmasmsvr 使用的 MAL 配置文件路径
DMDCR_SEQNO = 0
#ASM重启参数，命令行方式启动
DMDCR_ASM_RESTART_INTERVAL = 30
DMDCR_ASM_STARTUP_CMD = /opt/sy/DM/bin/DmASMSvrServiceDSC0 start
#DB重启参数，命令行方式启动
DMDCR_DB_RESTART_INTERVAL = 60
DMDCR_DB_STARTUP_CMD =/opt/sy/DM/bin/DmServiceDSC0 start
DMDCR_AUTO_OPEN_CHECK=60
#DSC1：
DMDCR_PATH = /dev/asm-diskd
DMDCR_MAL_PATH =/opt/sy/dsc/dmasvrmal.ini #dmasmsvr 使用的 MAL 配置文件路径
DMDCR_SEQNO = 1
#ASM重启参数，命令行方式启动
DMDCR_ASM_RESTART_INTERVAL = 30
DMDCR_ASM_STARTUP_CMD = /opt/sy/DM/bin/DmASMSvrServiceDSC0 start
#DB重启参数，命令行方式启动
DMDCR_DB_RESTART_INTERVAL = 60
DMDCR_DB_STARTUP_CMD =/opt/sy/DM/bin/DmServiceDSC0 start
DMDCR_AUTO_OPEN_CHECK=60
#DSC2：
DMDCR_PATH = /dev/asm-diskd
DMDCR_MAL_PATH =/opt/sy/dsc/dmasvrmal.ini #dmasmsvr 使用的 MAL 配置文件路径
DMDCR_SEQNO = 2
#ASM重启参数，命令行方式启动
DMDCR_ASM_RESTART_INTERVAL = 30
DMDCR_ASM_STARTUP_CMD = /opt/sy/DM/bin/DmASMSvrServiceDSC0 start
#DB重启参数，命令行方式启动
DMDCR_DB_RESTART_INTERVAL = 60
DMDCR_DB_STARTUP_CMD =/opt/sy/DM/bin/DmServiceDSC0 start
DMDCR_AUTO_OPEN_CHECK=60

#后台启动服务,三个节点在/opt/sy/DM/bin下dmdba用户启动CSS服务，会自动拉起ASM和DB服务

DSC0:

./DmCSSServiceDSC0 start

DSC1:

./DmCSSServiceDSC1 start

DSC2:

./DmCSSServiceDSC2 start
5.12配置监视器
vim /opt/sy/DM/bin/dmcssm.ini
CSSM_OGUID = 221114
CSSM_CSS_IP = 10.10.228.246:9341
CSSM_CSS_IP = 10.10.228.247:9343
CSSM_CSS_IP = 10.10.228.238:9345
CSSM_LOG_PATH =/opt/sy/dmcssmlog #监视器日志文件存放路径
CSSM_LOG_FILE_SIZE = 32 #每个日志文件最大32M
CSSM_LOG_SPACE_LIMIT = 0 #不限定日志文件总占用空间

#dmdba用户启动监视器查看集群状态
cd /opt/sy/DM/bin
./dmcssm /opt/sy/DM/bin/dmcssm.ini
#确认状态正常exit退出
6.其他配置
6.1dm_svc.conf配置
Linux机器存放在/etc/dm_svc.conf
Windows机器存放在system32目录(64位程序)、syswow64目录(32位程序)

TIME_ZONE=(480)
LANGUAGE=(cn)
DSC=(10.10.228.246:5236,10.10.228.247:5236,10.10.228.248:5236)

[DSC]
CLUSTER=(DSC)
6.2 sqllog配置
DSC集群每个节点均进行配置
vim /opt/sy/dsc/dsc*_config/sqllog.ini
BUF_TOTAL_SIZE = 20480 #SQLs Log Buffer Total Size(K)(1024~1024000)
BUF_SIZE = 2048 #SQLs Log Buffer Size(K)(50~409600)
BUF_KEEP_CNT = 10 #SQLs Log buffer keeped count(1~100)

[SLOG_ALL]
FILE_PATH = /opt/sy/dsc/dsc*_config/logcommit
PART_STOR = 0
SWITCH_MODE = 2
SWITCH_LIMIT = 512
ASYNC_FLUSH = 1
FILE_NUM = 100
ITEMS = 0
SQL_TRACE_MASK = 1
MIN_EXEC_TIME = 0
USER_MODE = 0
USERS =
6.3 设置备份策略
该备份策略为举例说明，可根据实际情况进行调整
每周日0点全备，周一到周六0点增备，每周日0点自动清理备份，备份保留8天
call SP_CREATE_JOB(‘full_bak’,1,0,‘’,0,0,‘’,0,‘全量备份’);

call SP_JOB_CONFIG_START(‘full_bak’);

call SP_JOB_SET_EP_SEQNO(‘full_bak’, 0);

call SP_ADD_JOB_STEP(‘full_bak’, ‘full_bak’, 6, ‘00000000/opt/sy/DM_BAK/’, 3, 1, 0, 0, NULL, 0);

call SP_ADD_JOB_STEP(‘full_bak’, ‘del_bak’, 0, ‘CALL SF_BAKSET_BACKUP_DIR_ADD(’‘DISK’‘,’‘/opt/sy/DM_BAK’‘);
CALL SP_DB_BAKSET_REMOVE_BATCH(’‘DISK’‘,SYSDATE-8);’, 1, 1, 0, 0, NULL, 0);

call SP_ADD_JOB_SCHEDULE(‘full_bak’, ‘BAK’, 1, 2, 1, 1, 0, ‘00:00:00’, NULL, ‘2022-11-17 14:39:47’, NULL, ‘’);

call SP_JOB_CONFIG_COMMIT(‘full_bak’);
call SP_CREATE_JOB(‘INCBAK’,1,0,‘’,0,0,‘’,0,‘’);

call SP_JOB_CONFIG_START(‘INCBAK’);

call SP_JOB_SET_EP_SEQNO(‘INCBAK’, 0);

call SP_ADD_JOB_STEP(‘INCBAK’, ‘INCBAK1’, 6, ‘10000000/opt/sy/DM_BAK|/opt/sy/DM_BAK’, 1, 3, 0, 0, NULL, 0);

call SP_ADD_JOB_STEP(‘INCBAK’, ‘FULLBAK’, 6, ‘00000000/opt/sy/DM_BAK’, 1, 1, 0, 0, NULL, 0);

call SP_ADD_JOB_SCHEDULE(‘INCBAK’, ‘INCBAK’, 1, 2, 1, 126, 0, ‘00:00:00’, NULL, ‘2022-11-17 14:42:24’, NULL, ‘’);

call SP_JOB_CONFIG_COMMIT(‘INCBAK’);

上一篇：
dm.ini参数静态修改方式
评论
后发表回复

作者

文章

阅读量

获赞

扫一扫
联系客服
logo
logo
logo
鄂Copyright © 达梦国产化应用创新实验室
达梦在线服务平台社区用户管理规范

鄂ICP备18017926号-1