达梦数据库DSC集群节点扩容
配置
|
节点 |
Ip地址 |
角色 |
硬件配置 |
|
A |
192.168.159.101 |
DSC0 |
1核 CPU /3.5GB 内存 / 40GB 磁盘 |
|
B |
192.168.159.102 |
DSC1 |
1核 CPU /3.5GB 内存 / 40GB 磁盘 |
|
C |
192.168.159.102 |
DSC1 |
1核 CPU /3.5GB 内存 / 40GB 磁盘 |
|
ASM软链接路径 |
指向的实际设备 |
用途说明 |
大小 |
|
/dev/dm/asm-dmdcr |
/dev/sdb |
DCR 盘(集群配置盘) |
5G |
|
/dev/dm/asm-dmvote |
/dev/sdc |
Vote 盘(仲裁盘) |
5G |
|
/dev/dm/asm-dmdata |
/dev/sde |
数据盘(存放数据文件) |
10G |
|
/dev/dm/asm-dmlog |
/dev/sdd |
日志盘(存放联机日志) |
8G |
|
/dev/dm/asm-dmarch |
/dev/sdf |
归档盘(存放归档日志) |
10G |
|
节点 |
实例端口 |
CSS监听端口 |
ASM监听端口 |
PORT_NUM |
ASM MAL监听端口 |
DM MAL监听端口 |
|
A |
5236 |
11286 |
11276 |
5236 |
11266 |
11246 |
|
B |
5236 |
11286 |
11276 |
5236 |
11266 |
11246 |
|
C |
5236 |
11286 |
11276 |
5236 |
11266 |
11246 |
两台虚拟机的OGUID为均210715。操作系统为CentOS Linux release 7.9 (Core);达梦镜像版本为dm8_20251016_x86_CentOS7_64.iso;安装目录为/home/dmdba/dmdbms;实例目录为/home/dmdba/dmdbms/data。
磁盘绑定
创建C机器,并添加已有的磁盘

C机器的vmx文件添加
disk.locking="FALSE"
disk.EnableUUID = "TRUE"
scsi0:1.SharedBus="Virtual"
C机器编写88文件
编写uuid.sh
vim uuid.sh
curr=$(cd "$(dirname "$0")";pwd)
rm -f $curr/88-dm-asmdevices.rules
for i in b 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+=\"dm/asm-disk$i\",OWNER=\"dmdba\", GROUP=\"dinstall\",MODE=\"0660\"" >> $curr/88-dm-asmdevices.rules
done
[root@localhost ~]# vim uuid.sh
[root@localhost ~]# chmod +x uuid.sh
[root@localhost ~]# ./uuid.sh
[root@localhost ~]# vim 88-dm-asmdevices.rules
KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="36000c29ce2d55fc345bf3ed8fd7d294e", SYMLINK+="dm/asm-dmdcr",OWNER="dmdba", GROUP="dinstall",MODE="0660"
KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="36000c292d058722acb3e0bc0529ceefe", SYMLINK+="dm/asm-dmvote",OWNER="dmdba", GROUP="dinstall",MODE="0660"
KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="36000c290ba88194ba6623504348c47e6", SYMLINK+="dm/asm-dmlog",OWNER="dmdba", GROUP="dinstall",MODE="0660"
KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="36000c29355a32c979d98e99b0f382462", SYMLINK+="dm/asm-dmdata",OWNER="dmdba", GROUP="dinstall",MODE="0660"
KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="36000c29435cf8137c6c2540425e65662", SYMLINK+="dm/asm-dmarch",OWNER="dmdba", GROUP="dinstall",MODE="0660"
复制文件
cp 88-dm-asmdevices.rules /etc/udev/rules.d/88-dm-asmdevices.rules
验证
[root@localhost ~]# ls -l /dev/dm/
总用量 0
lrwxrwxrwx 1 dmdba dinstall 6 1月 5 23:29 asm-dmarch -> ../sdf
lrwxrwxrwx 1 dmdba dinstall 6 1月 5 23:29 asm-dmdata -> ../sde
lrwxrwxrwx 1 dmdba dinstall 6 1月 5 23:29 asm-dmdcr -> ../sdb
lrwxrwxrwx 1 dmdba dinstall 6 1月 5 23:29 asm-dmlog -> ../sdd
lrwxrwxrwx 1 dmdba dinstall 6 1月 5 23:29 asm-dmvote -> ../sdc
[root@localhost ~]# ls -l /dev/sdb /dev/sdc /dev/sdd /dev/sde /dev/sdf
brw-rw---- 1 dmdba dinstall 8, 16 1月 5 23:29 /dev/sdb
brw-rw---- 1 dmdba dinstall 8, 32 1月 5 23:29 /dev/sdc
brw-rw---- 1 dmdba dinstall 8, 48 1月 5 23:29 /dev/sdd
brw-rw---- 1 dmdba dinstall 8, 64 1月 5 23:29 /dev/sde
brw-rw---- 1 dmdba dinstall 8, 80 1月 5 23:29 /dev/sdf
blockdev --getsize64 /dev/dm/asm-dmdcr
blockdev --getsize64 /dev/dm/asm-dmvote
blockdev --getsize64 /dev/dm/asm-dmlog
blockdev --getsize64 /dev/dm/asm-dmdata
blockdev --getsize64 /dev/dm/asm-dmarch
节点扩容
A上添加日志文件
disql
SQL>ALTER DATABASE ADD NODE LOGFILE '+DMLOG/DSC2_LOG01.log' SIZE 1024, '+DMLOG/DSC2_LOG02.log' SIZE 1024;
A中查看日志文件
ls +DMLOG
C创建目录
mkdir -p /home/dmdba/dmdbms/config/
拷贝A中的DSC0配置文件到C的DSC2中
scp -r /home/dmdba/dmdbms/config/DSC0 192.168.159.103:/home/dmdba/dmdbms/config/DSC2
C机器配置文件
vim /home/dmdba/dmdbms/config/dmdcr.ini

vim /home/dmdba/dmdbms/config/DSC2/dm.ini
修改CONFIG_PATH和INSTANCE_NAME

vim /home/dmdba/dmdbms/config/DSC2/dmarch.ini

增加AB节点中dmarch.ini中C机器信息
vim /home/dmdba/dmdbms/config/DSC0/dmarch.ini

vim /home/dmdba/dmdbms/config/DSC1/dmarch.ini

ABC修改dmmal.ini
vim /home/dmdba/dmdbms/config/DSC0/dmmal.ini
vim /home/dmdba/dmdbms/config/DSC1/dmmal.ini
vim /home/dmdba/dmdbms/config/DSC2/dmmal.ini

ABC修改dmasvrmal.ini
vim /home/dmdba/dmdbms/config/DSC0/dmasvrmal.ini
vim /home/dmdba/dmdbms/config/DSC1/dmasvrmal.ini
vim /home/dmdba/dmdbms/config/DSC2/dmasvrmal.ini

导出DCR配置信息
/home/dmdba/dmdbms/bin/dmasmcmd
export dcrdisk '/dev/dm/asm-dmdcr' to '/home/dmdba/dmdbms/dmdcr_cfg_bak.ini'
修改dmdcr_cfg_bak.ini,GROUP都修改成3节点,CSS,ASM,DSC都加入第三节点的信息
vim /home/dmdba/dmdbms/dmdcr_cfg_bak.ini




信息写回磁盘
/home/dmdba/dmdbms/bin/dmasmcmd
extend dcrdisk '/dev/dm/asm-dmdcr' from '/home/dmdba/dmdbms/dmdcr_cfg_bak.ini'
进入控制台扩展节点
/home/dmdba/dmdbms/bin/dmcssm INI_PATH=/home/dmdba/dmdbms/bin/dmcssm.ini
extend node
此时会显示失败,因为C尚未注册服务

C中注册服务
/home/dmdba/dmdbms/script/root/dm_service_installer.sh -t dmcss -dcr_ini /home/dmdba/dmdbms/config/dmdcr.ini -p CSS
/home/dmdba/dmdbms/script/root/dm_service_installer.sh -t dmasmsvr -dcr_ini /home/dmdba/dmdbms/config/dmdcr.ini -y DmCSSServiceCSS.service -p ASM
/home/dmdba/dmdbms/script/root/dm_service_installer.sh -t dmserver -dm_ini /home/dmdba/dmdbms/config/DSC2/dm.ini -dcr_ini /home/dmdba/dmdbms/config/dmdcr.ini -y DmASMSvrServiceASM.service -p DMS
C中启动服务
/home/dmdba/dmdbms/bin/DmCSSServiceCSS start
/home/dmdba/dmdbms/bin/DmASMSvrServiceASM start
/home/dmdba/dmdbms/bin/DmServiceDMS start
修改dmcssm监视器配置ABC中一致
vi /home/dmdba/dmdbms/bin/dmcssm.ini

再次进入监视器
/home/dmdba/dmdbms/bin/dmcssm INI_PATH=/home/dmdba/dmdbms/bin/dmcssm.ini



更多推荐




所有评论(0)