文章目录
DSC集群搭建
一．规划
| 机器名 | 实例名 | 业务ip | 心跳ip |
|---|---|---|---|
| DA | dsc1 | 192.168.56.101 | 172.16.1.101 |
| DB | dsc2 | 192.168.56.102 | 172.16.1.102 |
二．创建共享磁盘
进入VM安装目录，打开命令行cmd，创建共享虚拟磁盘，大小20G
.\vmware-vdiskmanager.exe -c -s 20G -a lsilogic -t 2 "D:\DM work\dsc\share\share.vmdk"
在DA，DB机器上添加共享磁盘
三．编辑两台的虚拟机的.vmx文件
打开虚拟机目录
编辑DA.vmx以及DB.vmx文件，在最后添加
disk.locking=“FALSE”
disk.EnableUUID = “TRUE”
四．进行磁盘分区
先打开一台虚拟机
查看磁盘分区
lsblk
fdisk -l
开始分区
fdisk /dev/sdb
· 依次输入 n → p → 1 →回车→ +1G →回车，完成第一块磁盘划分
· 依次输入 n → p → 2 →回车→ +1G →回车，完成第二块磁盘划分
· 依次输入 n → p → 3 →回车→ +8G →回车，完成第三块磁盘划分
· 依次输入 n → p → 4 →回车→回车→回车，完成第四块磁盘划分
w保存
查看分区
lsblk
fdisk -l
在进入DB机器检查分区，分区完成后进行下一步
五．绑定裸设备
DA、DB都进行以下操作
vim /etc/udev/rules.d/80-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"
KERNEL=="raw[1-4]", OWNER="dmdba", GROUP="dinstall", MODE="660"
partprobe /dev/sdb
udevadm control --reload-rules
udevadm trigger --type=devices --action=change
ll /dev/raw/
六．配置初始化配置文件（两台都要）
vim /home/dmdba/dmdbms/config/dmdcr_cfg.ini
DCR_N_GRP = 3
DCR_VTD_PATH = /dev/raw/raw2
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 = 172.16.1.101
DCR_EP_PORT = 9341
[CSS]
DCR_EP_NAME = CSS2
DCR_EP_HOST = 172.16.1.102
DCR_EP_PORT = 9343
[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 = 172.16.1.101
DCR_EP_PORT = 9349
DCR_EP_ASM_LOAD_PATH = /dev/raw
[ASM]
DCR_EP_NAME = ASM2
DCR_EP_SHM_KEY = 93361
DCR_EP_SHM_SIZE = 10
DCR_EP_HOST = 172.16.1.102
DCR_EP_PORT = 9351
DCR_EP_ASM_LOAD_PATH = /dev/raw
[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 = 5700
DCR_CHECK_PORT = 9741
[DSC]
DCR_EP_NAME = DSC2
DCR_EP_SEQNO = 1
DCR_EP_PORT = 5700
DCR_CHECK_PORT = 9742
七．创建ASM磁盘(一台虚拟机下执行即可)
cd /home/dmdba/dmdbms/bin
./dmasmcmd
create dcrdisk '/dev/raw/raw1' 'dcr'
create votedisk '/dev/raw/raw2' 'vote'
create asmdisk '/dev/raw/raw3' 'LOG'
create asmdisk '/dev/raw/raw4' 'DATA'
init dcrdisk '/dev/raw/raw1' from '/home/dmdba/dmdbms/config/dmdcr_cfg.ini' identified by '123456'
init votedisk '/dev/raw/raw2' from '/home/dmdba/dmdbms/config/dmdcr_cfg.ini'
八．配置ASM 的MAL 文件（两台机）
vim /home/dmdba/dmdbms/config/dmasvrmal.ini
[MAL_INST1]
MAL_INST_NAME = ASM1
MAL_HOST = 172.16.1.101
MAL_PORT = 7236
[MAL_INST2]
MAL_INST_NAME = ASM2
MAL_HOST = 172.16.1.102
MAL_PORT = 7237
九．配置dmdcr.ini文件
vim /home/dmdba/dmdbms/config/dmdcr.ini
DA
DMDCR_PATH = /dev/raw/raw1
DMDCR_MAL_PATH =/home/dmdba/dmdbms/config/dmasvrmal.ini
DMDCR_SEQNO = 0
DMDCR_ASM_RESTART_INTERVAL =0
DMDCR_ASM_STARTUP_CMD = /home/dmdba/dmdbms/bin/dmasmsvr dcr_ini=/home/dmdba/dmdbms/config/dmdcr.ini
DMDCR_DB_RESTART_INTERVAL = 0
DMDCR_DB_STARTUP_CMD =/home/dmdba/dmdbms/bin/dmserver path=/home/dmdba/dmdbms/config/dsc1/dm.ini dcr_ini=/home/dmdba/dmdbms/config/dmdcr.ini
DB
DMDCR_PATH = /dev/raw/raw1
DMDCR_MAL_PATH =/home/dmdba/dmdbms/config/dmasvrmal.ini
DMDCR_SEQNO = 1
DMDCR_ASM_RESTART_INTERVAL =0
DMDCR_ASM_STARTUP_CMD = /home/dmdba/dmdbms/bin/dmasmsvr dcr_ini=/home/dmdba/dmdbms/config/dmdcr.ini
DMDCR_DB_RESTART_INTERVAL = 0
DMDCR_DB_STARTUP_CMD = /home/dmdba/dmdbms/bin/dmserver path=/home/dmdba/dmdbms/config/dsc2/dm.ini dcr_ini=/home/dmdba/dmdbms/config/dmdcr.ini
十．启动DMCSS服务（两台机都需要）
cd /home/dmdba/dmdbms/bin
./dmcss dcr_ini=/home/dmdba/dmdbms/config/dmdcr.ini
十一．启动ASM 服务（两台机都需要）
cd /home/dmdba/dmdbms/bin
./dmasmsvr DCR_INI=/home/dmdba/dmdbms/config/dmdcr.ini
十二．创建ASM磁盘组（使用主控虚拟机创建，即DA）
cd /home/dmdba/dmdbms/bin
./dmasmtool dcr_ini=/home/dmdba/dmdbms/config/dmdcr.ini
create diskgroup 'DMLOG' asmdisk '/dev/raw/raw3'
create diskgroup 'DMDATA' asmdisk '/dev/raw/raw4'
十三．初始化实例
DA
配置dminit.ini
vim /home/dmdba/dmdbms/config/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
PAGE_SIZE = 32
log_size = 1024
dcr_path = /dev/raw/raw1
dcr_seqno = 0
auto_overwrite = 1
[DSC1]
config_path = /home/dmdba/dmdbms/config/dsc1
port_num = 5700
mal_host = 172.16.1.101
mal_port = 9255
log_path = +DMLOG/log/DSC1_log01.log
log_path = +DMLOG/log/DSC1_log02.log
[DSC2]
config_path = /home/dmdba/dmdbms/config/dsc2
port_num = 5700
mal_host = 172.16.1.102
mal_port = 9266
log_path = +DMLOG/log/DSC2_log01.log
log_path = +DMLOG/log/DSC2_log02.log
./dminit control=/home/dmdba/dmdbms/config/dminit.ini
生成两个文件夹dsc1与dsc2，将dsc2拷贝到虚拟机DB上
scp -r /home/dmdba/dmdbms/config/dsc2 dmdba@192.168.56.102:/home/dmdba/dmdbms/config/
十四．启动dmserver数据库服务
DA
cd /home/dmdba/dmdbms/bin
./dmserver /home/dmdba/dmdbms/config/dsc1/dm.ini dcr_ini=/home/dmdba/dmdbms/config/dmdcr.ini
DB
cd /home/dmdba/dmdbms/bin
./dmserver /home/dmdba/dmdbms/config/dsc2/dm.ini dcr_ini=/home/dmdba/dmdbms/config/dmdcr.ini
在DA中show查看
十五．设置自动拉起功能（两台都改）
修改dmdcr.ini的DMDCR_ASM_RESTART_INTERVAL与DMDCR_DB_RESTART_INTERVAL为1
vim /home/dmdba/dmdbms/config/dmdcr.ini
DMDCR_ASM_RESTART_INTERVAL = 1
DMDCR_DB_RESTART_INTERVAL = 1
十六．配置监视器（任意一台虚拟机）
vim /home/dmdba/dmdbms/config/dmcssm.ini
CSSM_OGUID = 63635
CSSM_CSS_IP = 192.168.56.101:9341
CSSM_CSS_IP = 192.168.56.102:9343
CSSM_LOG_PATH =/home/dmdba/dmdbms/log
CSSM_LOG_FILE_SIZE = 256
CSSM_LOG_SPACE_LIMIT = 2048
前台启动
cd /home/dmdba/dmdbms/bin
./dmcssm ini_path=/home/dmdba/dmdbms/config/dmcssm.ini
十七．验证
十八．注册为系统服务
注册集群服务，将前台启动模式改为系统服务，方便启动和关闭集群，以及实现开机自启动。
2个节点都需要注册，使用root用户注册服务，script/root目录下
cd /home/dmdba/dmdbms/script/root
#注册css1集群服务
./dm_service_installer.sh -t dmcss -p dsc1 -dcr_ini /home/dmdba/dmdbms/config/dmdcr.ini
注册asm1共享存储服务
./dm_service_installer.sh -t dmasmsvr -p dsc1 -dcr_ini /home/dmdba/dmdbms/config/dmdcr.ini -y DmCSSServicedsc1.service
#注册数据库服务
./dm_service_installer.sh -t dmserver -p dsc1 -dm_ini /home/dmdba/dmdbms/config/dsc1/dm.ini -dcr_ini /home/dmdba/dmdbms/config/dmdcr.ini -y DmCSSServicedsc1.service
#注册css2集群服务
./dm_service_installer.sh -t dmcss -p dsc2 -dcr_ini /home/dmdba/dmdbms/config/dmdcr.ini
注册asm2共享存储服务
./dm_service_installer.sh -t dmasmsvr -p dsc2 -dcr_ini /home/dmdba/dmdbms/config/dmdcr.ini -y DmCSSServicedsc2.service
#注册数据库服务
./dm_service_installer.sh -t dmserver -p dsc2 -dm_ini /home/dmdba/dmdbms/config/dsc2/dm.ini -dcr_ini /home/dmdba/dmdbms/config/dmdcr.ini -y DmCSSServicedsc2.service
服务注册完成后，退出现在前台启动的窗口，使用服务查看命令每个节点查看一遍，确保所有服务已经停止。
DMDSC启动、关闭流程
启动顺序：DMCSS—>DMASMSVR—>DMSERVICE
关闭顺序：DMSERVICE—>DMASMSVR—>DMCSS
分别使用刚注册完成的命令启动CSS,ASM,Service:
到dmdbms的bin目录下：（1节点）
./DmCSSServicedsc1 start
./DmASMSvrServicedsc1 start
./DmServicedsc1 start
（2节点） 到dmdbms的bin目录下：
./DmCSSServicedsc2 start
./DmASMSvrServicedsc2 start
./DmServicedsc2 start
再次验证
ps:验证的ip地址不一样是因为这是重装过的，所以ip变了，ip请根据自己的环境进行修改
更多达梦相关知识：https://eco.dameng.com
1057
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
