vmware linux 6.8 搭建dm dsc集群

于 2022-05-18 11:19:48 发布
阅读量270 收藏
点赞数
CC 4.0 BY-SA版权
文章标签： linux 运维 服务器 数据库 database
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_43288613/article/details/124838346

今日在虚拟机练习搭建 达梦 dsc集群
DM 共享存储数据库集群的英文全称 DM Data Shared Cluster，简称 DMDSC。

1、虚拟机生成共享磁盘：
在 E盘根目录下创建 dmsharedisk目录
找到虚拟机安装位置，按住shift 右键 “在此处打开命令窗口”
cmd 执行如下：

vmware-vdiskmanager.exe -c -s 1GB -a lsilogic -t 2 "E:\dmsharedisk\dm-1.vmdk"
vmware-vdiskmanager.exe -c -s 1GB -a lsilogic -t 2 "E:\dmsharedisk\dm1-1.vmdk"
vmware-vdiskmanager.exe -c -s 3GB -a lsilogic -t 2 "E:\dmsharedisk\dm-3G.vmdk"
vmware-vdiskmanager.exe -c -s 9GB -a lsilogic -t 2 "E:\dmsharedisk\dm-9.vmdk"

两台机器为 dm-1 dm-2 配置文件为 dm1.vmx dm2.vmx
2、两台机器配置填加如下：
dm-1

disk.EnableUUID = "TRUE"
diskLib.dataCacheMaxSize = "0"
diskLib.dataCacheMaxReadAheadSize = "0"
diskLib.dataCacheMinReadAheadSize = "0"
diskLib.dataCachePageSize = "4096"
diskLib.maxUnsyncedWrites = "0"
disk.locking= "FALSE"
scsi0:1.SharedBus= "Virtual"
scsi0:2.SharedBus= "Virtual"
scsi0:3.SharedBus= "Virtual"
scsi0:4.SharedBus= "Virtual"

dm-2

disk.EnableUUID = "TRUE"
diskLib.dataCacheMaxSize = "0"
diskLib.dataCacheMaxReadAheadSize = "0"
diskLib.dataCacheMinReadAheadSize = "0"
diskLib.dataCachePageSize = "4096"
diskLib.maxUnsyncedWrites = "0"
disk.locking= "FALSE"
scsi0:1.SharedBus= "Virtual"
scsi0:2.SharedBus= "Virtual"
scsi0:3.SharedBus= "Virtual"
scsi0:4.SharedBus= "Virtual"

3、查询磁盘uuid

/lib/udev/scsi_id -g -u -d /dev/sdb
/lib/udev/scsi_id -g -u -d /dev/sdc
/lib/udev/scsi_id -g -u -d /dev/sdd
/lib/udev/scsi_id -g -u -d /dev/sde

[root@dm2 ~]# /lib/udev/scsi_id -g -u -d /dev/sdb
36000c29821c25bfa7114b547ec153d8f
[root@dm2 ~]# /lib/udev/scsi_id -g -u -d /dev/sdc
36000c291b1e3428dc2b6febd79a6f47e
[root@dm2 ~]# /lib/udev/scsi_id -g -u -d /dev/sdd
36000c29cce533b6bc64425bf2496044a
[root@dm2 ~]# /lib/udev/scsi_id -g -u -d /dev/sde
36000c297ec237c556653bfbbeeea9cbb

4、a 使用裸设备
vi /etc/udev/rules.d/60-raw.rules

ACTION=="add", KERNEL=="sdb1", RUN+="/bin/raw /dev/raw/raw1 %N"
ACTION=="add", KERNEL=="sdb2", RUN+="/bin/raw /dev/raw/raw2 %N"
ACTION=="add", KERNEL=="sdb3", RUN+="/bin/raw /dev/raw/raw3 %N“
ACTION=="add", KERNEL=="sdb4", RUN+="/bin/raw /dev/raw/raw4 %N"
ACTION=="add", KERNEL=="raw[1-4]", OWNER="root", GROUP="root", MODE="660“

4、b 使用磁盘绑定方式
vi /etc/udev/rules.d/88-dm-asmdevices.rules

KERNEL=="sd*",ENV{DEVTYPE}=="disk",SUBSYSTEM=="block",PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="36000c29fa691372361851227c421c99b",SYMLINK+="asmdisk/dcrdisk01",OWNER="dmdba",GROUP="dinstall",MODE="0660",OPTIONS="nowatch"
KERNEL=="sd*",ENV{DEVTYPE}=="disk",SUBSYSTEM=="block",PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="36000c29643d67098af1637aeba146807",SYMLINK+="asmdisk/votedisk01",OWNER="dmdba",GROUP="dinstall",MODE="0660",OPTIONS="nowatch"
KERNEL=="sd*",ENV{DEVTYPE}=="disk",SUBSYSTEM=="block",PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="36000c299313611f851980886b9792b6c",SYMLINK+="asmdisk/logdisk01",OWNER="dmdba",GROUP="dinstall",MODE="0660",OPTIONS="nowatch"
KERNEL=="sd*",ENV{DEVTYPE}=="disk",SUBSYSTEM=="block",PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="36000c292aeb144be71f8b7347fbdd6d7",SYMLINK+="asmdisk/datadisk01",OWNER="dmdba",GROUP="dinstall",MODE="0660",OPTIONS="nowatch"

****vmware 上使用

KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="36000c29821c25bfa7114b547ec153d8f", NAME="asmdisk/dcrdisk01", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="36000c291b1e3428dc2b6febd79a6f47e", NAME="asmdisk/votedisk01", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="36000c29cce533b6bc64425bf2496044a", NAME="asmdisk/logdisk01", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="36000c297ec237c556653bfbbeeea9cbb", NAME="asmdisk/datadisk01", OWNER="dmdba", GROUP="dinstall", MODE="0660"

5、使上述配置生效

/sbin/udevadm control --reload-rules
udevadm trigger --action=add
/sbin/udevadm trigger --type=devices --action=change

6、编辑配置文件 dcr_cfg
–两节点 0.101 0.102
vi /dm8/dmdbms/config/dmdcr_cfg.ini

DCR_N_GRP             = 3
DCR_VTD_PATH          = /dev/asmdisk/votedisk01
DCR_OGUID             = 63635  

[GRP]
DCR_GRP_TYPE          = CSS  
DCR_GRP_NAME          = CSS
DCR_GRP_N_EP          = 2
DCR_GRP_DSKCHK_CNT    = 60

[CSS]
DCR_EP_NAME           = CSS1
DCR_EP_HOST           = 192.168.0.101
DCR_EP_PORT           = 9341
[CSS]
DCR_EP_NAME           = CSS2
DCR_EP_HOST           = 192.168.0.102
DCR_EP_PORT           = 9341
  
[GRP]
DCR_GRP_TYPE          = ASM
DCR_GRP_NAME          = ASM
DCR_GRP_N_EP          = 2
DCR_GRP_DSKCHK_CNT    = 60

[ASM]
DCR_EP_NAME           = ASM1
DCR_EP_SHM_KEY        = 93360
DCR_EP_SHM_SIZE       = 10
DCR_EP_HOST           = 192.168.0.101
DCR_EP_PORT           = 9351
DCR_EP_ASM_LOAD_PATH  = /dev/asmdisk
[ASM]
DCR_EP_NAME           = ASM2
DCR_EP_SHM_KEY        = 93361
DCR_EP_SHM_SIZE       = 10
DCR_EP_HOST           = 192.168.0.102
DCR_EP_PORT           = 9351
DCR_EP_ASM_LOAD_PATH  = /dev/asmdisk
  
[GRP]
DCR_GRP_TYPE          = DB
DCR_GRP_NAME          = DSC
DCR_GRP_N_EP          = 2
DCR_GRP_DSKCHK_CNT    = 60

[DSC]
DCR_EP_NAME           = DSC1
DCR_EP_SEQNO          = 0
DCR_EP_PORT           = 5236
DCR_CHECK_PORT        = 9741  
[DSC]
DCR_EP_NAME           = DSC2
DCR_EP_SEQNO          = 1
DCR_EP_PORT           = 5236
DCR_CHECK_PORT        = 9741

7、创建ASM磁盘组
第一节点 0.101

cd /dm8/dmdbms/bin
./dmasmcmd 
create dcrdisk '/dev/asmdisk/dcrdisk01' 'dcr'
create votedisk '/dev/asmdisk/votedisk01' 'vote'
create asmdisk '/dev/asmdisk/logdisk01' 'LOG0'
create asmdisk '/dev/asmdisk/datadisk01' 'DATA0'
init dcrdisk '/dev/asmdisk/dcrdisk01' from '/dm8/dmdbms/config/dmdcr_cfg.ini' identified by 'ROOT'
init votedisk '/dev/asmdisk/votedisk01' from '/dm8/dmdbms/config/dmdcr_cfg.ini'

第二节点 0.102

listdisks /dev/asmdisk

–祼设备方式

create dcrdisk '/dev/raw/raw1' 'dcr’
create votedisk '/dev/raw/raw2' 'vote'
create asmdisk '/dev/raw/raw3' 'LOG0'
create asmdisk '/dev/raw/raw4' 'DATA0'
init dcrdisk '/dev/raw/raw1' from '/home/data/dmdcr_cfg.ini'identified by 'abcd'
init votedisk '/dev/raw/raw2' from '/home/data/dmdcr_cfg.ini'

8、配置mal
–两节点一样
vi /dm8/dmdbms/config/dmasvrmal.ini

[MAL_INST1]
MAL_INST_NAME              = ASM1
MAL_HOST                   = 192.168.0.101
MAL_PORT                   = 7236
[MAL_INST2]
MAL_INST_NAME              = ASM2
MAL_HOST                   = 192.168.0.102
MAL_PORT                   = 7236

9、配置dcr.ini
–第一节点 0.101
vi /dm8/dmdbms/config/dmdcr.ini

DMDCR_PATH=/dev/asmdisk/dcrdisk01
DMDCR_MAL_PATH=/dm8/dmdbms/config/dmasvrmal.ini   #dmasmsvr使用的MAL配置文件路径
DMDCR_SEQNO=0

#ASM重启参数，命令行方式启动
DMDCR_ASM_RESTART_INTERVAL=30
DMDCR_ASM_STARTUP_CMD=/dm8/dmdbms/bin/dmasmsvr dcr_ini=/dm8/dmdbms/config/dmdcr.ini

#DB重启参数，命令行方式启动
DMDCR_DB_RESTART_INTERVAL=60
DMDCR_DB_STARTUP_CMD=/dm8/dmdbms/bin/dmserver path=/dm8/dmdbms/config/DSC1_config/dm.ini dcr_ini=/dm8/dmdbms/config/dmdcr.ini

–第二节点 0.102

DMDCR_PATH=/dev/asmdisk/dcrdisk01
DMDCR_MAL_PATH=/dm8/dmdbms/config/dmasvrmal.ini   #dmasmsvr使用的MAL配置文件路径
DMDCR_SEQNO=1
#ASM重启参数，命令行方式启动
DMDCR_ASM_RESTART_INTERVAL=30
DMDCR_ASM_STARTUP_CMD=/dm8/dmdbms/bin/dmasmsvr dcr_ini=/dm8/dmdbms/config/dmdcr.ini
#DB重启参数，命令行方式启动
DMDCR_DB_RESTART_INTERVAL=60
DMDCR_DB_STARTUP_CMD=/dm8/dmdbms/bin/dmserver path=/dm8/dmdbms/config/DSC2_config/dm.ini dcr_ini=/dm8/dmdbms/config/dmdcr.ini

10、启动css
–第一节点 0.101

cd /dm8/dmdbms/bin
./dmcss DCR_INI=/dm8/dmdbms/config/dmdcr.ini

–此步骤可不执行（上面包含）

cd /dm8/dmdbms/bin
./dmasmsvr DCR_INI=/dm8/dmdbms/config/dmdcr.ini

11、填加linux css 服务

cd /dm8/dmdbms/script/root
./dm_service_installer.sh -t dmcss -p css1 -dcr_ini /dm8/dmdbms/config/dmdcr.ini

注：css 服务同时起动 asm db，由于db 还未初始化 所以起动失败，可忽略，待下面补始化完成后，自动拉起。

–第二节点 0.102

cd /dm8/dmdbms/bin
./dmcss DCR_INI=/dm8/dmdbms/config/dmdcr.ini

cd /dm8/dmdbms/bin
./dmasmsvr DCR_INI=/dm8/dmdbms/config/dmdcr.ini

cd /dm8/dmdbms/script/root
./dm_service_installer.sh -t dmcss -p css2 -dcr_ini /dm8/dmdbms/config/dmdcr.ini

12、ASM创建磁盘
–第一节点 0.101

cd /dm8/dmdbms/bin
./dmasmtool DCR_INI=/dm8/dmdbms/config/dmdcr.ini

#创建日志磁盘组
create diskgroup 'DMLOG' asmdisk '/dev/asmdisk/logdisk01'

#创建数据磁盘组
create diskgroup 'DMDATA' asmdisk '/dev/asmdisk/datadisk01'

13、配置数据库初始化配置 ini
–第一节点 0.101

vi /dm8/dmdata/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/dcrdisk01       #dcr磁盘路径，目前不支持asm，只能是裸设备
dcr_seqno=0
auto_overwrite=1
[DSC1]            #inst_name跟dmdcr_cfg.ini中DB类型group中DCR_EP_NAME对应
config_path=/dm8/dmdbms/config/DSC1_config
port_num=5236
mal_host=192.168.0.101
mal_port=9236
log_path=+DMLOG/log/DSC1_log01.log
log_path=+DMLOG/log/DSC1_log02.log
[DSC2]            #inst_name跟dmdcr_cfg.ini中DB类型group中DCR_EP_NAME对应
config_path=/dm8/dmdbms/config/DSC2_config
port_num=5236
mal_host=192.168.0.102
mal_port=9236
log_path=+DMLOG/log/DSC2_log01.log
log_path=+DMLOG/log/DSC2_log02.log

14、初始化数据库
–第一节点 0.101

cd /dm8/dmdbms/bin 
./dminit control=/dm8/dmdata/dminit.ini

15、拷贝数据库配置文件到另一节点
–第一节点 0.101

cd /dm8/dmdbms/config
scp -r DSC2_config/ 192.168.0.102:/dm8/dmdbms/config/

16、配置监视器文件
–监视节点 0.101

vi /dm8/dmdbms/config/dmcssm.ini 

#CSSM_OGUID和dmdcr_cfg.ini中的DCR_OGUID保持一致
CSSM_OGUID = 63635
#配置所有CSS的连接信息，
#和dmdcr_cfg.ini中CSS配置项的DCR_EP_HOST和DCR_EP_PORT保持一致
CSSM_CSS_IP          = 192.168.0.101:9341
CSSM_CSS_IP          = 192.168.0.102:9341
CSSM_LOG_PATH        = /dm8/dmdbms/log  #监视器日志文件存放路径
CSSM_LOG_FILE_SIZE   = 1024  #每个日志文件最大1024MB
CSSM_LOG_SPACE_LIMIT = 0  #不限定日志文件总占用空间

17、启动监视服务

cd /dm8/dmdbms/bin
./dmcssm INI_PATH=/dm8/dmdbms/config/dmcssm.ini

相关命令：
help
show css
show dsc
show asm

18、注册服务

su - root
cd /dm8/dmdbms/script/root
./dm_service_installer.sh -t dmcssm -p CSSM -cssm_ini /dm8/dmdbms/config/dmcssm.ini

--------------------测试

节点一

disql SYSDBA/SYSDBA

create table DM_TEST_0604 as select * from sysobjects;
select count(*) from DM_TEST_0604;
create user DMTS identified by "DmTS#0614";
grant resource,public to DMTS;
select * from dba_role_privs where GRANTEE='DMTS';


节点二
disql SYSDBA/SYSDBA
select count(*) from DM_TEST_0604;
select * from dba_role_privs where GRANTEE='DMTS';


create table DM_TEST_0605 as select * from sysobjects;
select count(*) from DM_TEST_0605;

-------------问题1

报错：
[dmdba@dm1 bin]$ ./dmasmtool DCR_INI=/dm8/dmdbms/config/dmdcr.ini
DMASMTOOL V8
[code : -11041] ASM连接异常

原因：第三块盘 小于2G
sdb 8:16 0 1G 0 disk
sdc 8:32 0 2G 0 disk
sdd 8:48 0 1G 0 disk
sde 8:64 0 10G 0 disk

-------------问题2
报错：linux 卡顿，第二节点不同步分区

解决：
***磁盘永久、端口0.1开始、虚拟机文件去空行

到此文章结束，有不足地方，欢迎批正！
更多达梦技术资讯，请访问达梦技术社区：
达梦数据库 - 新一代大型通用关系数据库 | 达梦云适配中心
https://eco.dameng.com/
孙立锋
关注
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值