签到成功

知道了

CNDBA社区CNDBA社区

达梦8 DMDSC集群数据库搭建

2020-06-29 13:54 3168 1 原创 达梦数据库
作者： franklin
本文链接：https://www.cndba.cn/franklin/article/4194

一、 安装环境

https://www.cndba.cn/franklin/article/4194

实验环境通过在笔记本上的vmvare workstation 15来搭建，共享存储可以通过本地磁盘虚拟：https://www.cndba.cn/franklin/article/4194

HOSTNAME
 Dsc0
 Dsc1
OS
 Kylin-4.0.2-server-sp1-Community_x86_64
Kylin-4.0.2-server-sp1-Community_x86_64
Memory
 2G
 2G
Private IP
 Ens38:10.10.10.1
 Ens38:10.10.10.2
Public IP Ens33:192.168.60.128 Ens33:192.168.60.128
VIP  192.168.60.111  192.168.60.112
 OS storage boot   500m

swap      2-4G

https://www.cndba.cn/franklin/article/4194

/             20G		 boot   500m

swap      2-4G

/             20G
 ASM Storage Dcr        500M

Votedisk       500m

DMDATA     8G

DMLOG        5G

 Dcr        500M

Votedisk       500mhttps://www.cndba.cn/franklin/article/4194

DMDATA     8G

DMLOG        5G
 Dm software dm8_rh6_64_ent_8.zip dm8_rh6_64_ent_8.zip


https://www.cndba.cn/franklin/article/4194


https://www.cndba.cn/franklin/article/4194
https://www.cndba.cn/franklin/article/4194


 二、 安装过程

1.虚拟机进行共享磁盘划分
vmware-vdiskmanager.exe -c -s 200Mb -a lsilogic -t 2 D:/vmshared/sharedisk1.vmdk
vmware-vdiskmanager.exe -c -s 200Mb -a lsilogic -t 2 D:/vmshared/sharedisk2.vmdk
vmware-vdiskmanager.exe -c -s 8Gb -a lsilogic -t 2 D:/vmshared/sharedisk3.vmdk
vmware-vdiskmanager.exe -c -s 5Gb -a lsilogic -t 2 D:/vmshared/sharedisk4.vmdkhttps://www.cndba.cn/franklin/article/4194

2.创建虚拟机
   按照安装环境需求分别创建两台虚拟机，并且安装kylin操作系统
   略

3.添加共享磁盘
分别修改两台虚拟机配置文件，在虚拟机.vmx文件后面添加以下内容：
disk.locking = "FALSE"
diskLib.dataCacheMaxSize= "0"
scsi1.sharedBus ="virtual"
diskLib.dataCacheMaxReadAheadSize = "0"
diskLib.DataCacheMinReadAheadSize = "0"
diskLib.dataCachePageSize = "4096"
diskLib.maxUnsyncedWrites = "0"
scsi1.pciSlotNumber = "37"
scsi1.virtualDev = "lsilogic"
scsi1.present = "TRUE"
scsi1:2.fileName = "D:/vmshared/sharedisk3.vmdk"
scsi1:2.present = "TRUE"
scsi1:0.fileName = "D:/vmshared/sharedisk1.vmdk"
scsi1:0.present = "TRUE"
scsi1:1.fileName = "D:/vmshared/sharedisk2.vmdk"
scsi1:1.present = "TRUE"
scsi1:3.fileName = "D:/vmshared/sharedisk4.vmdk"
scsi1:3.present = "TRUE"
scsi1:3.redo = ""
scsi1:2.redo = ""
scsi1:1.redo = ""
scsi1:0.redo = ""

4.修改主机名
   vim /etc/hostname    #两台分别修改为Dsc0，Dsc1

5.创建用户
groupadd dinstall
useradd -U 1001-g dinstall -m -d /home/dmdba -s /bin/bash dmdba
passwd dmdba

6.关闭其他服务
systemctl stop NetworkManager.service
systemctl disable NetworkManager.service
systemctl stop firewalld.service
systemctl disable firewalld.service

7.创建安装目录
mkdir -p /dmbase/dmdbms
mkdir -p /dmbase/dmdbms /data
chown -R dmdba.dinstall /dmbase/dmdbms

8.设置环境变量
   修改dmdba用户bash_profile
export DM_HOME="/dmbase/dmdbms"
export LD_LIBRARY_PATH="$LD_LIBRARY_PATH:/dmbase/dmdbms/bin"
export DM_INSTALL_TMPDIR=/tmp
export PATH=$DM_HOME/bin:$PATH

9.创建裸设备
  新建磁盘分区 fdisk /dev/sdb… fdisk /dev/sdd（如果是存储通过光纤映射的存储盘，需要用udev绑定磁盘）
  将裸设备命令加入开机启动
vim /etc/rc.local
/sbin/raw /dev/raw/raw1 /dev/sdb1
/sbin/raw /dev/raw/raw2 /dev/sdc1
/sbin/raw /dev/raw/raw3 /dev/sdd1
/sbin/raw /dev/raw/raw4 /dev/sde1
chown dmdba:dinstall /dev/raw/raw1
chmod 660 /dev/raw/raw1
chown dmdba:dinstall /dev/raw/raw2
chmod 660 /dev/raw/raw2
chown dmdba:dinstall /dev/raw/raw3
chmod 660 /dev/raw/raw3
chown dmdba:dinstall /dev/raw/raw4
chmod 660 /dev/raw/raw4

10.添加IP地址
Dsc1
ens33 ：192.168.60.128 
ens38 ：10.10.10.1
Dsc2
ens33 ：192.168.60.132 
ens38 ：10.10.10.2

11.修改系统参数
vim /etc/security/limits.conf
dmdba  soft nofile 65536
dmdba  hard nofile 65536
dmdba  soft fsize unlimited
dmdba  hard fsize unlimited
dmdba  soft data  1048576
dmdba  hard data  1048576
12.安装数据库软件略：
DMInstall.bin -i  这里用文本模式安装，只安装数据库软件不建库

13.配置dmdcr_cfg.ini文件   #所有配置文件都应用dmdba用户创建和编辑
  vim /dmbase/dmdbms/data
DCR_N_GRP = 3
DCR_VTD_PATH = /dev/raw/raw2
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 = 10.10.10.1
DCR_EP_PORT = 9341

[GRP_CSS]
DCR_EP_NAME = CSS1
DCR_EP_HOST = 10.10.10.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 = 10
DCR_EP_HOST = 10.10.10.1
DCR_EP_PORT = 9349
DCR_EP_ASM_LOAD_PATH = /dev/raw

[GRP_ASM]
DCR_EP_NAME = ASM1
DCR_EP_SHM_KEY = 93361
DCR_EP_SHM_SIZE = 10
DCR_EP_HOST = 10.10.10.2
DCR_EP_PORT = 9351
DCR_EP_ASM_LOAD_PATH = /dev/raw

[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_HOST=192.168.60.128
DCR_EP_PORT = 5236
DCR_VIP=192.168.60.111
DCR_CHECK_PORT = 9741

[GRP_DSC]
DCR_EP_NAME = DSC1
DCR_EP_SEQNO = 1
DCR_EP_HOST=192.168.60.132
DCR_EP_PORT = 5236
DCR_VIP=192.168.60.112
DCR_CHECK_PORT = 9742

14.初始化ASM磁盘
使用DMASMCMD 工具初始化ASM磁盘，
/dmbase/dmdbsm/bin/dmasmcmd
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 '/dmbase/dmdbms/data/dmdcr_cfg.ini' identified by 'dmdba'
init votedisk '/dev/raw/raw2' from '/dmbase/dmdbms/data/dmdcr_cfg.ini'

15.配置DMASM的MAL文件
DMASM的配置文件命名为dmasvrmal.ini
vim /dmbase/dmdbms/data/dmasvrmal.ini
[MAL_INST1]
MAL_INST_NAME = ASM0
MAL_HOST = 10.10.10.1
MAL_PORT = 7236
[MAL_INST2]
MAL_INST_NAME = ASM1
MAL_HOST = 10.10.10.2
MAL_PORT = 7237

16.配置dmdcr.ini文件
dmdcr.ini 是 dmcss、dmasmsvr、dmasmtool 工具的输入参数
vim /dmbase/dmdbms/data/dmdcr.ini
DMDCR_PATH = /dev/raw/raw1
DMDCR_MAL_PATH = /dmbase/dmdbms/data/dmasvrmal.ini
DMDCR_SEQNO = 0
/#ASM重启参数，命令行方式启动
DMDCR_ASM_RESTART_INTERVAL = 0
DMDCR_ASM_STARTUP_CMD = /dmbase/dmdbms/bin/dmasmsvr dcr_ini=/dmbase/dmdbms/data/dmdcr.ini

/#DB重启参数，命令行方式启动
DMDCR_DB_RESTART_INTERVAL = 0
DMDCR_DB_STARTUP_CMD = /dmbase/dmdbms/bin/dmasmsvr path=/dmbase/dmdbms/data/dsc0_config/dm.ini dcr_ini=/dmbase/dmdbms/data/dmdcr.ini

启动css进程，两台分别启动，1节点(主节点)先启动，2节点后启动
Dsc1启动
./dmcss DCR_INI=/dmbase/dmdbms/data/dmdcr.ini
Dsc2启动
./dmcss DCR_INI=/dmbase/dmdbms/data/dmdcr.ini
启动 asm进程，两台分别启动，1节点(主节点)先启动，2节点后启动
Dsc1启动
./dmasmsvr DCR_INI=/dmbase/dmdbms/data/dmdcr.ini
Dsc2启动
./dmasmsvr DCR_INI=/dmbase/dmdbms/data/dmdcr.ini

17.创建DMASM磁盘组
./dmasmtool DCR_INI=/dmbase/dmdbms/data/dmdcr.ini
create diskgroup 'DMLOG' asmdisk '/dev/raw/raw3'
create diskgroup 'DMDATA' asmdisk '/dev/raw/raw4'

18.配置数据库初始化dminit.ini文件
vim /dmbase/dmdbms/data/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/raw/raw1

https://www.cndba.cn/franklin/article/4194

/#dcr磁盘路径，目前不支持asm，只能是裸设备
dcr_seqno = 0
auto_overwrite = 1https://www.cndba.cn/franklin/article/4194

[DSC0]
/#inst_name跟dmdcr_cfg.ini中DB类型group中DCR_EP_NAME对应
config_path = /dmbase/dmdbms/data/dsc0_config
port_num = 5236
mal_host = 10.10.10.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 = /dmbase/dmdbms/data/dsc1_config
port_num = 5237
mal_host = 10.10.10.2
mal_port = 9341
log_path = +DMLOG/log/dsc1_log01.log
log_path = +DMLOG/log/dsc1_log02.log
19.初始化数据库
cd /dmbase/dmdbms/bin
./dminit control=/dmbase/dmdbms/data/dminit.ini
20.手动启动数据库服务
cd /dmbase/dmdbms/bin
./dmserver /dmbase/dmdbms/data/dsc0_config/dm.ini dcr_ini=/dmbase/dmdbms/data/dmdcr.ini
./dmserver /dmbase/dmdbms/data/dsc1_config /dm.ini dcr_ini=/dmbase/dmdbms/data/dmdcr.ini

三、测试
1.测试连接数据库
vim /etc/dm_svc.conf
dscrac=(192.168.60.111:5236,192.168.60.1112:5236)
/dmbase/dmdbms/bin/disql sysdba/SYSDBA@descrac
/dmbase/dmdbms/bin/disql sysdba/SYSDBA@192.168.60.111:5236
/dmbase/dmdbms/bin/disql sysdba/SYSDBA@192.168.60.112:5236
2.测试故障
停止某一节点主机，检查vip是否被其他节点接管
Ifconfig 查看vip
ens33     inet 地址:192.168.60.128  广播:192.168.60.255  掩码:255.255.255.0
ens33:0   inet 地址:192.168.60.111  广播:192.168.60.255  掩码:255.255.255.0
ens33:1   inet 地址:192.168.60.112  广播:192.168.60.255  掩码:255.255.255.0
ens38     inet 地址:10.10.10.1  广播:10.10.10.255  掩码:255.255.255.0

测试连接情况：
/dmbase/dmdbms/bin/disql sysdba/SYSDBA@descrac
/dmbase/dmdbms/bin/disql sysdba/SYSDBA@192.168.60.111:5236
/dmbase/dmdbms/bin/disql sysdba/SYSDBA@192.168.60.112:5236


达梦相关技术信息在达梦云适配中心

https://eco.dameng.com

版权声明：本文为博主原创文章，未经博主允许不得转载。

用户评论
* 以下用户言论只代表其个人观点，不代表CNDBA社区的观点或立场
franklin

franklin

关注
  • 15
    原创
  • 0
    翻译
  • 1
    转载
  • 3
    评论
  • 访问：33339次
  • 积分：56
  • 等级：注册会员
  • 排名：第39名
精华文章


    达梦数据库运维实战

    Oracle 18c 必须掌握的新特性：管理与实战

    Oracle数据库问题解决方案和故障排除手册
    热门文章
      友情链接： CNDBA社区 | openGauss | openEuler | openAnolis | 广告联系: database@ustc.edu
      Copyright © 2016 All Rights Reserved. Powered by CNDBA · 皖ICP备2022006297号-1·

      AI QQ群