使用vmware+centos7+openfiler搭建达梦DSC两节点集群

最新推荐文章于 2024-05-29 11:03:14 发布

chirs999

最新推荐文章于 2024-05-29 11:03:14 发布

阅读量2k

点赞数 2

分类专栏：达梦文章标签： dba

本文链接：https://blog.csdn.net/chirs999/article/details/126171894

版权

达梦专栏收录该内容

7 篇文章 0 订阅

订阅专栏

达梦dsc集群的部署

达梦dsc集群的部署... 1

安装DM数据库软件... 1

创建DMDBA用户和dinstall组... 1

安装openfileresa-2.99. 5

配置iscsi目标卷... 6

配置磁盘... 11

安装iscsi initiator. 11

准备dmdcr_cfg.ini配置文件(单节点操作) 15

使用dmasmcmd工具初始化dcr ocr. 16

准备DMASM的MAL配置文件... 17

准备dmdcr.ini文件... 18

启动dmcss,dmasm服务... 19

创建ASM磁盘组... 20

准备dminit.ini配置文件... 21

使用dminit工具初始化数据库... 22

安装DM数据库软件

创建DMDBA用户和dinstall组

groupadd dinstall && useradd -g dinstall dmdba && echo root|passwd --stdin dmdba

[root@dmdsc2 tmp]# groupadd dinstall && useradd -g dinstall dmdba && echo root|passwd --stdin dmdba

更改用户 dmdba 的密码。

passwd：所有的身份验证令牌已经成功更新。

关闭防火墙

systemctl stop firewalld && systemctl disable firewalld

关闭selinux

setenforce 0 && sed -i 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config

创建软件安装目录,授权

[root@dmdsc2 tmp]# mkdir -p /opt/dmdbms && chown dmdba:dinstall /opt/dmdbms

用户资源限制

cat >> /etc/security/limits.conf << EOF

dmdba hard nofile 131072

dmdba soft nofile 131072

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 data unlimited

dmdba hard data unlimited

dmdba soft core unlimited

dmdba hard core unlimited

dmdba soft memlock unlimited

dmdba hard memlock unlimited

EOF

挂载安装程序

[root@dmdsc2 tmp]# mount -o loop dm8_20211112_x86_rh6_64_ent_8.1.2.94.iso /mnt

命令行安装DM8数据库软件

使用dmdba用户安装

[dmdba@dmdsc2 mnt]$ ./DMInstall.bin -i

请选择安装语言(C/c:中文 E/e:英文) [C/c]:c

解压安装程序.........

欢迎使用达梦数据库安装程序

是否输入Key文件路径? (Y/y:是 N/n:否) [Y/y]:n

是否设置时区? (Y/y:是 N/n:否) [Y/y]:y

设置时区:

[ 1]: GTM-12=日界线西

[ 2]: GTM-11=萨摩亚群岛

[ 3]: GTM-10=夏威夷

[ 4]: GTM-09=阿拉斯加

[ 5]: GTM-08=太平洋时间（美国和加拿大）

[ 6]: GTM-07=亚利桑那

[ 7]: GTM-06=中部时间（美国和加拿大）

[ 8]: GTM-05=东部部时间（美国和加拿大）

[ 9]: GTM-04=大西洋时间（美国和加拿大）

[10]: GTM-03=巴西利亚

[11]: GTM-02=中大西洋

[12]: GTM-01=亚速尔群岛

[13]: GTM=格林威治标准时间

[14]: GTM+01=萨拉热窝

[15]: GTM+02=开罗

[16]: GTM+03=莫斯科

[17]: GTM+04=阿布扎比

[18]: GTM+05=伊斯兰堡

[19]: GTM+06=达卡

[20]: GTM+07=曼谷，河内

[21]: GTM+08=中国标准时间

[22]: GTM+09=汉城

[23]: GTM+10=关岛

[24]: GTM+11=所罗门群岛

[25]: GTM+12=斐济

[26]: GTM+13=努库阿勒法

[27]: GTM+14=基里巴斯

请选择设置时区 [21]:21

安装类型:

1 典型安装

2 服务器

3 客户端

4 自定义

请选择安装类型的数字序号 [1 典型安装]:1

所需空间: 1486M

请选择安装目录 [/home/dmdba/dmdbms]:/opt/dmdbms

可用空间: 13G

是否确认安装路径(/opt/dmdbms)? (Y/y:是 N/n:否) [Y/y]:y

安装前小结

安装位置: /opt/dmdbms

所需空间: 1486M

可用空间: 13G

版本信息:

有效日期:

安装类型: 典型安装

是否确认安装? (Y/y:是 N/n:否):y

2022-08-04 16:09:27

[INFO] 安装达梦数据库...

2022-08-04 16:09:27

[INFO] 安装基础模块...

2022-08-04 16:09:55

[INFO] 安装服务器模块...

2022-08-04 16:09:58

[INFO] 安装客户端模块...

2022-08-04 16:10:26

[INFO] 安装驱动模块...

2022-08-04 16:10:42

[INFO] 安装手册模块...

2022-08-04 16:10:45

[INFO] 安装服务模块...

2022-08-04 16:10:49

[INFO] 移动日志文件。

2022-08-04 16:10:49

[INFO] 安装达梦数据库完成。

请以root系统用户执行命令:

/opt/dmdbms/script/root/root_installer.sh

安装结束

运行脚本创建Dmap服务

[root@dmdsc2 tmp]# /opt/dmdbms/script/root/root_installer.sh

配置openfiler

安装openfileresa-2.99

图形化方式安装比较简单，根据页面中的提示信息，作出对应选择后，点击”Next”继续即可，如果没有特殊要求，基本不需要做其它修改，只是在网络配置时根据实际情况对网络进行设置。使用固定 IP 以免带来不便

启动界面显示了 Openfiler 的一些支持信息和授权信息等，最重要的是指明了管理界面的访问地址

配置iscsi目标卷

通过浏览器，访问 Openfiler 的管理地址，就会见到如下页面：

Openfiler 管理页面的默认登录用户名和密码为”openfilre/password”，还有一个root账号一般仅用来管理用户,登录成功后，就会进入 Openfiler 的管理页面。会看到系统的基本信息

点击”Services”选项卡，将 iSCSI Target 和 iSCSI Initiator 两个服务启动并设置成开机自动启动：

点击【create】创建PV

点击【Add volume group】,创建vg

点击【add volume】创建lv,根据需求分配dcr vote log data

注意文件类型选择”block”，否则不能实现 iSCSI 目标卷。确认没有问题后，点击”Create”按钮完成创建。

磁盘卷创建完成后，就可以创建 iSCSI 目标卷了。

设置网段 192.168.218.0

点击”iSCSI Targets”菜单，就会进行 iSCSI 管理页面，页面有四个选项卡，分别是”Target Configuration”、”LUN Mapping”、”Network ACL”和”CHAP Authentication”，分别配置选项卡里的内容，就可以完成磁盘卷的映射。

配置磁盘

安装iscsi initiator

[root@dmdsc1 ~]# yum install -y iscsi-initiator-utils*

发现target

[root@dmdsc1 ~]# iscsiadm -m discovery -t sendtargets -p 192.168.218.214

192.168.218.214:3260,1 iqn.2006-01.com.openfiler:dsc

登录节点

iscsiadm -m node -T iqn.2006-01.com.openfiler:dsc -p 192.168.218.214:3260 --login

Logging in to [iface: default, target: iqn.2006-01.com.openfiler:dsc, portal: 192.168.218.214,3260] (multiple)

配置自动登录

[root@dmdsc1 ~]# iscsiadm -m node -T iqn.2006-01.com.openfiler:dsc -p 192.168.218.214:3260 --op update -n node.startup -v automatic

查看磁盘信息

[root@dmdsc1 ~]# lsblk

NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT

fd0 2:0 1 4K 0 disk

sda 8:0 0 20G 0 disk

├─sda1 8:1 0 1G 0 part /boot

└─sda2 8:2 0 19G 0 part

├─centos_dmdsc1-root 253:0 0 17G 0 lvm /

└─centos_dmdsc1-swap 253:1 0 2G 0 lvm [SWAP]

sdb 8:16 0 128M 0 disk

sdc 8:32 0 128M 0 disk

sdd 8:48 0 2G 0 disk

sde 8:64 0 7.3G 0 disk

for i in b c d e; 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+=\"asmdisk/asm-disk$i\", OWNER=\"dmdba\", GROUP=\"dinstall\", MODE=\"0660\"" done

[root@dmdsc1 ~]# for i in b c d e;

> 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+=\"asmdisk/asm-disk$i\", OWNER=\"dmdba\", GROUP=\"dinstall\", MODE=\"0660\""

> done

KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="14f504e46494c45526247374839392d7a7767472d6c614676", SYMLINK+="asmdisk/asm-diskb", OWNER="dmdba", GROUP="dinstall", MODE="0660"

KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="14f504e46494c4552796f525a4e362d635745432d6e417530", SYMLINK+="asmdisk/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=="14f504e46494c45524b55696a4c522d344f55702d30434843", SYMLINK+="asmdisk/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=="14f504e46494c45523272584149322d616c5a702d6a4f5032", SYMLINK+="asmdisk/asm-diske", OWNER="dmdba", GROUP="dinstall", MODE="0660"

配置udev

[root@dmdsc1 ~]# more /usr/lib/udev/rules.d/99-dmdsc.rules

KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="14f504e46494c455262473748393

92d7a7767472d6c614676", SYMLINK+="asmdisk/asm-diskb", OWNER="dmdba", GROUP="dinstall", MODE="0660"

KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="14f504e46494c4552796f525a4e3

62d635745432d6e417530", SYMLINK+="asmdisk/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=="14f504e46494c45524b55696a4c5

22d344f55702d30434843", SYMLINK+="asmdisk/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=="14f504e46494c455232725841493

22d616c5a702d6a4f5032", SYMLINK+="asmdisk/asm-diske", OWNER="dmdba", GROUP="dinstall", MODE="0660"

重启udev服务

[root@dmdsc1 ~]# udevadm control --reload

[root@dmdsc1 ~]# systemctl restart systemd-udev-trigger.service

[root@dmdsc1 ~]# ll /dev/sd*

brw-rw---- 1 root disk 8, 0 8月 4 17:54 /dev/sda

brw-rw---- 1 root disk 8, 1 8月 4 17:54 /dev/sda1

brw-rw---- 1 root disk 8, 2 8月 4 17:54 /dev/sda2

brw-rw---- 1 dmdba dinstall 8, 16 8月 4 17:54 /dev/sdb

brw-rw---- 1 dmdba dinstall 8, 32 8月 4 17:54 /dev/sdc

brw-rw---- 1 dmdba dinstall 8, 48 8月 4 17:54 /dev/sdd

brw-rw---- 1 dmdba dinstall 8, 64 8月 4 17:54 /dev/sde

[root@dmdsc1 ~]# ll /dev/asmdisk/

总用量 0

lrwxrwxrwx 1 root root 6 8月 4 17:54 asm-diskb -> ../sdb

lrwxrwxrwx 1 root root 6 8月 4 17:54 asm-diskc -> ../sdc

lrwxrwxrwx 1 root root 6 8月 4 17:54 asm-diskd -> ../sdd

lrwxrwxrwx 1 root root 6 8月 4 17:54 asm-diske -> ../sde

搭建dmdsc

准备dmdcr_cfg.ini配置文件(单节点操作)

[dmdba@dmdsc1 bin]$ more /home/dmdba/dmdcr_cfg.ini

DCR_N_GRP = 3

DCR_VTD_PATH = /dev/asmdisk/asm-diskc

DCR_OGUID = 63635

[GRP]

DCR_GRP_TYPE = CSS

DCR_GRP_NAME = GRP_CSS

DCR_GRP_N_EP = 2

DCR_GRP_DSKCHK_CNT = 60

[GRP_CSS]

DCR_EP_NAME = CSS0

DCR_EP_HOST = 192.168.1.1

DCR_EP_PORT = 9341

[GRP_CSS]

DCR_EP_NAME = CSS1

DCR_EP_HOST = 192.168.1.2

DCR_EP_PORT = 9343

[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

DCR_EP_SHM_KEY = 93360

DCR_EP_SHM_SIZE = 20

DCR_EP_HOST = 192.168.1.1

DCR_EP_PORT = 9349

DCR_EP_ASM_LOAD_PATH = /dev/asmdisk

[GRP_ASM]

DCR_EP_NAME = ASM1

DCR_EP_SHM_KEY = 93361

DCR_EP_SHM_SIZE = 20

DCR_EP_HOST = 192.168.1.2

DCR_EP_PORT = 9351

DCR_EP_ASM_LOAD_PATH = /dev/asmdisk

[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

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 = 5237

DCR_CHECK_PORT = 9742

使用dmasmcmd工具初始化dcr ocr

create dcrdisk '/dev/asmdisk/asm-diskb' 'dcr'

create votedisk '/dev/asmdisk/asm-diskc' 'vote'
create asmdisk '/dev/asmdisk/asm-diskd' 'LOG0'
create asmdisk '/dev/asmdisk/asm-diske' 'DATA0'
init dcrdisk '/dev/asmdisk/asm-diskb' from '/home/dmdba/dmdcr_cfg.ini'identified by 'abcd'

init votedisk '/dev/asmdisk/asm-diskc' from '/home/dmdba/dmdcr_cfg.ini'

[dmdba@dmdsc1 bin]$ ./dmasmcmd

DMASMCMD V8

ASM>create dcrdisk '/dev/asmdisk/asm-diskb' 'dcr'

[Trace]The ASM initialize dcrdisk /dev/asmdisk/asm-diskb to name DMASMdcr

Used time: 43.545(ms).

ASM>create votedisk '/dev/asmdisk/asm-diskc' 'vote'

[Trace]The ASM initialize votedisk /dev/asmdisk/asm-diskc to name DMASMvote

Used time: 44.143(ms).

ASM>create asmdisk '/dev/asmdisk/asm-diskd' 'LOG0'

[Trace]The ASM initialize asmdisk /dev/asmdisk/asm-diskd to name DMASMLOG0

Used time: 41.500(ms).

ASM>create asmdisk '/dev/asmdisk/asm-diske' 'DATA0'

[Trace]The ASM initialize asmdisk /dev/asmdisk/asm-diske to name DMASMDATA0

Used time: 42.492(ms).

ASM>init dcrdisk '/dev/asmdisk/asm-diskb' from '/home/dmdba/dmdcr_cfg.ini'identified by 'abcd'

[Trace]DG 126 alloc one extent for inodes, addr(disk_id, disk_auno, extent_no):(0,0,1).

[Trace]DG 126 allocate 4 extents for file 0xfe000002.

[Trace]DG 126 alloc 4 extents for 0xfe000002, addr(disk_id, disk_auno, extent_no):(0, 0, 2)->(0, 0, 5), need_init = 1.

Used time: 298.781(ms).

ASM>init votedisk '/dev/asmdisk/asm-diskc' from '/home/dmdba/dmdcr_cfg.ini'

[Trace]DG 125 alloc one extent for inodes, addr(disk_id, disk_auno, extent_no):(0,0,1).

[Trace]DG 125 allocate 4 extents for file 0xfd000002.

[Trace]DG 125 alloc 4 extents for 0xfd000002, addr(disk_id, disk_auno, extent_no):(0, 0, 2)->(0, 0, 5), need_init = 1.

Used time: 468.844(ms).

准备DMASM的MAL配置文件

配置文件名为dmasvrmal.ini,两节点完全一致

[dmdba@dmdsc1 bin]$ more /home/dmdba/dmasvrmal.ini

[MAL_INST1]

MAL_INST_NAME = ASM0

MAL_HOST = 192.168.1.1

MAL_PORT = 7236

[MAL_INST2]

MAL_INST_NAME = ASM1

MAL_HOST = 192.168.1.2

MAL_PORT = 7237

准备dmdcr.ini文件

文件保存到/home/dmdba目录,两节点dmdcr_path相同,dmasvrmal.ini文件相同,dmdcr_seqno分别设置为0和1

节点192.168.218.100

[dmdba@dmdsc1 bin]$ more /home/dmdba/dmdcr.ini

DMDCR_PATH = /dev/asmdisk/asm-diskb

DMDCR_MAL_PATH =/home/dmdba/dmasvrmal.ini #dmasmsvr 使用的 MAL 配置文件路径

DMDCR_SEQNO = 0

#ASM 重启参数，命令行方式启动

DMDCR_ASM_RESTART_INTERVAL = 0

DMDCR_ASM_STARTUP_CMD = /opt/dmdbms/bin/dmasmsvr dcr_ini=/home/dmdba/dmdcr.ini

#DB 重启参数，命令行方式启动

DMDCR_DB_RESTART_INTERVAL = 0

DMDCR_DB_STARTUP_CMD = /opt/dmdbms/bin/dmserver path=/home/dmdba/dsc0_config/dm.ini dcr_ini=/home/dmdba/dmdcr.ini

节点192.168.218.101

[dmdba@dmdsc2 ~]$ more /home/dmdba/dmdcr.ini

DMDCR_PATH = /dev/asmdisk/asm-diskb

DMDCR_MAL_PATH =/home/dmdba/dmasvrmal.ini #dmasmsvr 使用的 MAL 配置文件路径

DMDCR_SEQNO = 1

#ASM 重启参数，命令行方式启动

DMDCR_ASM_RESTART_INTERVAL = 0

DMDCR_ASM_STARTUP_CMD = /opt/dmdbms/bin/dmasmsvr dcr_ini=/home/dmdba/dmdcr.ini

#DB 重启参数，命令行方式启动

DMDCR_DB_RESTART_INTERVAL = 0

DMDCR_DB_STARTUP_CMD = /opt/dmdbms/bin/dmserver path=/home/dmdba/dsc0_config/dm.ini dcr_ini=/home/dmdba/dmdcr.ini

启动dmcss,dmasm服务

两个节点都要启动，先启动节点192.168.218.100

[dmdba@dmdsc1 bin]$ ./dmcss DCR_INI=/home/dmdba/dmdcr.ini

[dmdba@dmdsc1 bin]$ ./dmasmsvr DCR_INI=/home/dmdba/dmdcr.ini

启动节点192.168.218.101 dmcss dmasm

[dmdba@dmdsc2 bin]$ ./dmcss DCR_INI=/home/dmdba/dmdcr.ini

[dmdba@dmdsc2 bin]$ ./dmasmsvr DCR_INI=/home/dmdba/dmdcr.ini

两个节点的dmcss,dmasm都启动后最终主节点显示如下:

创建ASM磁盘组

在一个节点上使用dmasmtool 工具把另外的两块盘用来创建log磁盘组和data磁盘组

先查看一下磁盘情况

[dmdba@dmdsc1 bin]$ ./dmasmcmd

DMASMCMD V8

ASM>listdisks '/dev/asmdisk'

[/dev/asmdisk/asm-diskd]: unused ASM disk, name:[DMASMLOG0], size:[2047M]

[/dev/asmdisk/asm-diske]: unused ASM disk, name:[DMASMDATA0], size:[7455M]

[/dev/asmdisk/asm-diskc]: used ASM disk, name:[DMASMvote], size:[128M], group_id:[125], disk_id:[0]

[/dev/asmdisk/asm-diskb]: used ASM disk, name:[DMASMdcr], size:[128M], group_id:[126], disk_id:[0]

Used time: 30.681(ms).

ASM>exit

创建log,data磁盘组

[dmdba@dmdsc1 bin]$ ./dmasmtool DCR_INI=/home/dmdba/dmdcr.ini

DMASMTOOL V8

ASM>create diskgroup 'DMLOG' asmdisk '/dev/asmdisk/asm-diskd'

Used time: 229.924(ms).

ASM>create diskgroup 'DMDATA' asmdisk '/dev/asmdisk/asm-diske'

Used time: 140.984(ms).

准备dminit.ini配置文件

dminit.ini文件用来保存初始化数据库的参数，只需要在一个节点上，保存在/home/dmdba目录配置,内容如下:

[dmdba@dmdsc1 bin]$ more /home/dmdba/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 = 256

dcr_path = /dev/asmdisk/asm-diskb #dcr 磁盘路径，目前不支持 asm，只能是裸设备

dcr_seqno = 0

auto_overwrite = 1

[DSC0] #inst_name 跟 dmdcr_cfg.ini 中 DB 类型 group 中 DCR_EP_NAME 对应

config_path = /home/dmdba/dsc0_config

port_num = 5236

mal_host = 192.168.1.1

mal_port = 9340

log_path = +DMLOG/log/dsc0_log01.log

log_path = +DMLOG/log/dsc0_log02.log

[DSC1] #inst_name 跟 dmdcr_cfg.ini 中 DB 类型 group 中 DCR_EP_NAME 对应

config_path = /home/dmdba/dsc1_config

port_num = 5237

mal_host = 192.168.1.2

mal_port = 9341

log_path = +DMLOG/log/dsc1_log01.log

log_path = +DMLOG/log/dsc1_log02.log

使用dminit工具初始化数据库

在节点192.168.218.100上初始化

[dmdba@dmdsc1 bin]$ ./dminit control=/home/dmdba/dminit.ini

initdb V8

db version: 0x7000c

file dm.key not found, use default license!

License will expire on 2022-11-11

Normal of FAST

Normal of DEFAULT

Normal of RECYCLE

Normal of KEEP

Normal of ROLL

log file path: +DMLOG/log/dsc0_log01.log

log file path: +DMLOG/log/dsc0_log02.log

log file path: +DMLOG/log/dsc1_log01.log

log file path: +DMLOG/log/dsc1_log02.log

write to dir [+DMDATA/data/dsc].

create dm database success. 2022-08-04 19:20:30

初始化db环境后会在/home/dmdba/dsc0_config和/home/dmdba/dsc1_config下生成dm.ini和 dmmal.ini两个配置文件

看看文件差异 diff /home/dmdba/dsc0_config/dm.ini /home/dmdba/dsc1_config/dm.ini

发现config_path,实例名,端口不一样

拷贝配置文件

将节点1上生成的/home/dmdba/dsc1_config目录拷贝到另一个节点相同路径

[dmdba@dmdsc1 bin]$ scp -r /home/dmdba/dsc1_config/ 192.168.218.101:/home/dmdba/

The authenticity of host '192.168.218.101 (192.168.218.101)' can't be established.

ECDSA key fingerprint is SHA256:IW7qa7hzG/C0wZX7tHsD/NicAlBe6yiGu7XAcACeUiI.

ECDSA key fingerprint is MD5:3e:c8:88:f4:77:8a:5d:53:73:8f:f1:2c:6c:f5:77:e8.

Are you sure you want to continue connecting (yes/no)? yes

Warning: Permanently added '192.168.218.101' (ECDSA) to the list of known hosts.

dmdba@192.168.218.101's password:

dmmal.ini 100% 202 35.2KB/s 00:00

dm.ini 100% 53KB 1.6MB/s 00:00

sqllog.ini 100% 481 443.2KB/s 00:00

启动数据库

节点192.168.218.100

[dmdba@dmdsc1 bin]$ ./dmserver /home/dmdba/dsc0_config/dm.ini dcr_ini=/home/dmdba/dmdcr.ini

启动信息：

[dmdba@dmdsc1 bin]$ ./dmserver /home/dmdba/dsc0_config/dm.ini dcr_ini=/home/dmdba/dmdcr.ini

file dm.key not found, use default license!

version info: develop

DM Database Server x64 V8 1-2-94-21.11.11-150650-10038-ENT startup...

Normal of FAST

Normal of DEFAULT

Normal of RECYCLE

Normal of KEEP

Normal of ROLL

Database mode = 0, oguid = 0

License will expire on 2022-11-11

hlck_sys_init, init g_drm_dest:[0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15]

lbs_sys_init, the length of g_master_map is 1451, fill it use ok_ep_arr:[0, 1], n_ok_ep:2!

check CSS cmd: START NOTIFY, cmd_seq: 2

Control Node change from 255 to 254

check CSS cmd: DCR_LOAD, cmd_seq: 3

check CSS cmd: EP START, cmd_seq: 6

Control Node change from 254 to 0

file lsn: 0

check CSS cmd: EP START2, cmd_seq: 11

ndct db load finished

ckpt2_exec_immediately begin.

file_lsn < cur_lsn & no dirty page & in mount status, ignore checkpoint

checkpoint end, 0 pages flushed, used_space[512], free_space[536862208].

checkpoint: buffer pages flushing...

checkpoint end, 2 pages flushed, used_space[512], free_space[536862208].

checkpoint end, 0 pages flushed, used_space[0], free_space[536862720].

ndct second level fill fast pool finished

ndct third level fill fast pool finished

ndct fill fast pool finished

iid page's trxid[1002]

NEXT TRX ID = 1003

pseg_collect_mgr_items, total collect 0 active_trxs, 0 cmt_trxs, 0 pre_cmt_trxs, 0 active_pages, 0 cmt_pages, 0 pre_cmt_pages, 0 mgr pages, 0 mgr recs!

iid page's trxid[2004]

NEXT TRX ID = 3008.

total 0 active crash trx, pseg_crash_trx_rollback sys_only(0) begin ...

pseg_crash_trx_rollback end, total 0 active crash trx, include 0 empty_trxs, 0 empty_pages which only need to delete mgr recs.

pseg_crash_trx_rollback end

pseg recv finished

nsvr_startup end.

aud sys init success.

aud rt sys init success.

trx: 3008 purged 1 pages

trx: 3046 purged 1 pages

trx: 3048 purged 1 pages

trx: 3050 purged 1 pages

trx: 3052 purged 1 pages

trx: 3054 purged 1 pages

trx: 3074 purged 1 pages

trx: 3314 purged 1 pages

trx: 3340 purged 1 pages

trx: 3342 purged 1 pages

trx: 3344 purged 1 pages

trx: 3346 purged 1 pages

trx: 3348 purged 1 pages

trx: 3352 purged 1 pages

trx: 3354 purged 1 pages

trx: 3358 purged 1 pages

trx: 3362 purged 1 pages

trx: 3374 purged 1 pages

trx: 3386 purged 1 pages

trx: 3406 purged 1 pages

trx: 3432 purged 1 pages

trx: 3434 purged 1 pages

trx: 3436 purged 1 pages

trx: 3438 purged 1 pages

trx: 3462 purged 1 pages

trx: 3466 purged 1 pages

trx: 3468 purged 1 pages

trx: 3470 purged 1 pages

trx: 3560 purged 24 pages

trx: 3614 purged 1 pages

trx: 3616 purged 1 pages

trx: 3618 purged 1 pages

trx: 3620 purged 1 pages

trx: 3632 purged 1 pages

trx: 3636 purged 1 pages

trx: 3640 purged 1 pages

trx: 3650 purged 1 pages

trx: 3660 purged 1 pages

trx: 3670 purged 1 pages

trx: 3674 purged 1 pages

trx: 3680 purged 1 pages

trx: 3684 purged 1 pages

trx: 3696 purged 1 pages

trx: 3698 purged 1 pages

trx: 3996 purged 1 pages

trx: 4020 purged 1 pages

trx: 4030 purged 1 pages

trx: 4040 purged 1 pages

trx: 4078 purged 29 pages

trx: 4128 purged 1 pages

checkpoint for flush ts[65535] buffer...

checkpoint for flush ts[65535] buffer end

systables desc init success.

ndct_db_load_info success.

nsvr_process_before_open begin.

nsvr_process_before_open success.

SYSTEM IS READY.

check CSS cmd: EP OPEN, cmd_seq: 16

iid page's trxid[6022]

NEXT TRX ID = 7026.

节点192.168.218.101

[dmdba@dmdsc2 bin]$ ./dmserver /home/dmdba/dsc1_config/dm.ini dcr_ini=/home/dmdba/dmdcr.ini

file dm.key not found, use default license!

version info: develop

DM Database Server x64 V8 1-2-94-21.11.11-150650-10038-ENT startup...

Normal of FAST

Normal of DEFAULT

Normal of RECYCLE

Normal of KEEP

Normal of ROLL

Database mode = 0, oguid = 0

License will expire on 2022-11-11

hpc_ini_info_pre_check end, code:0

hlck_sys_init, init g_drm_dest:[0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15]

lbs_sys_init, the length of g_master_map is 1451, fill it use ok_ep_arr:[0, 1], n_ok_ep:2!

check CSS cmd: DCR_LOAD, cmd_seq: 4

check CSS cmd: EP START, cmd_seq: 8

Control Node change from 255 to 0

mal_tsk_process_g_crash_lsn_bro, ep_seqno(0), crash_lsn(0)

mal_tsk_process_g_crash_lsn_bro, ep_seqno(1), crash_lsn(0)

check CSS cmd: EP START2, cmd_seq: 13

Control node start status: OPEN

EP[1] adjust cur_lsn from [32395] to [32526]

file lsn: 0

ndct db load finished

ndct second level fill fast pool finished

ndct third level fill fast pool finished

ndct fill fast pool finished

ckpt2_exec_immediately begin.

file_lsn < cur_lsn & no dirty page & in mount status, ignore checkpoint

checkpoint end, 0 pages flushed, used_space[512], free_space[536862208].

checkpoint end, 0 pages flushed, used_space[0], free_space[536862720].

pseg recv finished

nsvr_startup end.

aud sys init success.

aud rt sys init success.

systables desc init success.

ndct_db_load_info success.

nsvr_process_before_open begin.

nsvr_process_before_open success.

SYSTEM IS READY.

check CSS cmd: EP OPEN, cmd_seq: 17

iid page's trxid[6019]

NEXT TRX ID = 7023.

check CSS cmd: EP REAL OPEN, cmd_seq: 20

注册dmcss服务

./dm_service_installer.sh -t dmcss -dcr_ini /home/dmdba/dmdcr.ini -p dsc1

Created symlink from /etc/systemd/system/multi-user.target.wants/DmCSSServicedsc1.service to /usr/lib/systemd/system/DmCSSServicedsc1.service.

创建服务(DmCSSServicedsc1)完成

注册dmasm服务

注册asm服务有依赖关系，需要先注册dmcss服务

[root@dmdsc1 root]# ./dm_service_installer.sh -t dmasmsvr -dcr_ini /home/dmdba/dmdcr.ini -p dsc1 -y DmCSSServicedsc1

注册dmserver服务

dmserver服务依赖asm服务，需先注册asm

[root@dmdsc1 root]# ./dm_service_installer.sh -t dmserver -dm_ini /home/dmdba/dsc0_config/dm.ini -dcr_ini /home/dmdba/dmdcr.ini -p dsc -y DmASMSvrServicedsc1

Created symlink from /etc/systemd/system/multi-user.target.wants/DmServicedsc.service to /usr/lib/systemd/system/DmServicedsc.service.

创建服务(DmServicedsc)完成

DMDSC启动、关闭流程

DMDSC是基于共享存储的数据库集群系统，包含多个数据库实例，因此，与单节点的达梦数据库不同，DMDSC集群需要在节点间进行同步、协调，才能正常地启动、关闭。启动DMDSC集群之前，必须先启动集群同步服务DMCSS，如果使用了DMASM文件系统，则DMASMSVR服务也必须先启动。

DMASMSVR控制台执行exit命令，会通知所有其他节点一起退出；dmserver需要手动退出所有节点，没有同步功能；Linux环境下DMASMSVR/dmserver都监控了操作系统SIGTERM信号，Linux环境执行不带参数的kill命令，DMASMSVR/dmserver都能正常退出。

如果DMCSS配置了DMASMSVR/dmserver自动拉起命令，可以先仅启动DMCSS，然后启动DMCSSM，在DMCSSM控制台执行命令"ep startup asm"启动DMASMSVR集群，执行"ep startup dsc"启动dmserver集群（其中asm/dsc为dmasmsvr/dmserver集群的组名）。类似地执行"ep stop asm/dsc"可以关闭dmasmsvr/dmserver集群环境。

Linux环境下，dmcss/dmasmsvr/dmserver可以配置成操作系统服务，每次开机自动启动，或者通过Linux命令"service XXX start/stop/restart"(XXX为配置的服务名)完成服务的启动、关闭。服务脚本在达梦安装包里提供，可能还需要根据实际情况修改部分参数才能使用

达梦数据库 - 新一代大型通用关系型数据库 | 达梦在线服务平台