DSC搭建
第一章 前期准备
1.1 主机信息
192.168.10.11/2:192.168.10.11/192.168.10.12
10.0.0.1/2:10.0.0.1/10.0.0.2
1.2共享磁盘规划
- 要求提供一个20G的共享存储,并划分为2个100M的LUN,1个2G的LUN并将剩余空间划分到1个LUN中
- 在其中一个节点上进行划分共享磁盘
- 输入 fdisk /dev/sdb
- 依次输入 n → p → 1 →回车→ +100M →回车,完成第一块磁盘划分
- 依次输入 n → p → 2 →回车→ +100M →回车,完成第二块磁盘划分
- 依次输入 n → p → 3 →回车→ +2048M →回车,完成第三块磁盘划分
- 依次输入 n → p → 4 →回车→回车→回车,完成第四块磁盘划分
- 按p进行查看
7. 按w保存退出
- 查看磁盘划分 fdisk –l /dev/sdb
- 进行裸设备绑定
vi /etc/udev/rules.d/60-raw.rules
ACTION=="add", KERNEL=="sdb1", RUN+="/usr/bin/raw /dev/raw/raw1 %N"
ACTION=="add", KERNEL=="sdb2", RUN+="/usr/bin/raw /dev/raw/raw2 %N"
ACTION=="add", KERNEL=="sdb3", RUN+="/usr/bin/raw /dev/raw/raw3 %N"
ACTION=="add", KERNEL=="sdb4", RUN+="/usr/bin/raw /dev/raw/raw4 %N"
ACTION=="add", KERNEL=="raw[1-4]", OWNER="dmdba", GROUP="dinstall", MODE="660"
- 使配置文件生效
# start_udev
- 检查是否生效,查看每块盘的大小
blockdev --getsize64 /dev/sdb1
blockdev --getsize64 /dev/sdb2
blockdev --getsize64 /dev/sdb3
blockdev --getsize64 /dev/sdb4
第二章 数据库安装
2.1创建用户和组
#创建安装用户组 dinstall
groupadd dinstall
#在dinstall组内创建安装用户dmdba
useradd -g dinstall -m -d /home/dmdba -s /bin/bash dmdba
#修改密码
passwd dmdba
dmdba
2.2安装达梦数据库(仅安装数据库,且不初始化实例)
./DMInstall.bin -i
第三章 DSC搭建
3.1dmdcr_cfg.ini
#配置dmdcr_cfg.ini(控制节点上配置即可)
DCR_N_GRP = 3
DCR_VTD_PATH = /dev/raw/raw2
DCR_OGUID = 210331
[GRP]
DCR_GRP_TYPE = CSS
DCR_GRP_NAME = GRP_CSS
DCR_GRP_N_EP = 2 #组内节点个数N
DCR_GRP_DSKCHK_CNT = 65 #磁盘心跳机制,容错时间,单位秒,缺省60S,取值范围5~600。
[GRP_CSS]
DCR_EP_NAME = CSS0
DCR_EP_HOST = 10.0.0.1
DCR_EP_PORT = 31286
[GRP_CSS]
DCR_EP_NAME = CSS1
DCR_EP_HOST = 10.0.0.2
DCR_EP_PORT = 31286
[GRP]
DCR_GRP_TYPE = ASM
DCR_GRP_NAME = GRP_ASM
DCR_GRP_N_EP = 2
DCR_GRP_DSKCHK_CNT = 61
[GRP_ASM]
DCR_EP_NAME = ASM0
DCR_EP_SHM_KEY = 42424 #共享内存标识
DCR_EP_SHM_SIZE = 200 #共享内存大小,单位M ,
DCR_EP_HOST = 10.0.0.1
DCR_EP_PORT = 31276
DCR_EP_ASM_LOAD_PATH = /dev # ASM磁盘扫描路径
[GRP_ASM]
DCR_EP_NAME = ASM1
DCR_EP_SHM_KEY = 42425
DCR_EP_SHM_SIZE = 200
DCR_EP_HOST = 10.0.0.2
DCR_EP_PORT = 31276
DCR_EP_ASM_LOAD_PATH = /dev
[GRP]
DCR_GRP_TYPE = DB
DCR_GRP_NAME = GRP_DSC
DCR_GRP_N_EP = 2
DCR_GRP_DSKCHK_CNT = 57
[GRP_DSC]
DCR_EP_NAME =DSC0 #实例名
DCR_EP_SEQNO = 0
DCR_EP_PORT = 5236 #实例端口
DCR_CHECK_PORT = 31256
[GRP_DSC]
DCR_EP_NAME =DSC1
DCR_EP_SEQNO = 1
DCR_EP_PORT = 5236
DCR_CHECK_PORT = 31256
3.2初始化磁盘组
./dmasmcmd (控制节点上执行即可)
ASM>create dcrdisk '/dev/raw/raw1' 'dcr'
ASM>create votedisk '/dev/raw/raw2' 'vote'
ASM>init dcrdisk '/dev/raw/raw1' from '/home/dmdba/dmdbms/dsc/dmdcr_cfg.ini' identified by '123456'
ASM>init votedisk '/dev/raw/raw2' from '/home/dmdba/dmdbms/dsc/dmdcr_cfg.ini'
ASM>create asmdisk '/dev/raw/raw4' 'DATA0'
ASM>create asmdisk '/dev/raw/raw3' 'LOG0'
3.3dmasvrmal.ini
#几节点均需要配置且完全一致
[MAL_INST0]
MAL_INST_NAME = ASM0
MAL_HOST = 10.0.0.1
MAL_PORT = 31266
[MAL_INST1]
MAL_INST_NAME = ASM1
MAL_HOST = 10.0.0.2
MAL_PORT = 31266
3.4dmdcr.ini
#几节点均需要配置,DMDCR_SEQNO一定不同
DMDCR_PATH = /dev/raw/raw1
DMDCR_MAL_PATH = /home/dmdba/dmdbms/dsc/dmasvrmal.ini
DMDCR_SEQNO = 0 #记录当前节点序号,用来获取 ASM 登录信息
DMDCR_ASM_RESTART_INTERVAL = 0 #如果配置为0,则不会执行自动拉起操作,默认为60s
DMDCR_ASM_STARTUP_CMD=/home/dmdba/dmdbms/bin/DmASMSvrServiceRAC0 start
DMDCR_DB_RESTART_INTERVAL = 60 #如果配置为0,则不会执行自动拉起操作,默认为60s
DMDCR_DB_STARTUP_CMD= /home/dmdba/dmdbms/bin/DmServiceRAC0 start
DMDCR_AUTO_OPEN_CHECK = 111
#指定时间内如果节点实例未启动,DMCSS 会自动将节点 踢出集群环境 ,单位为秒,取值范围应大于等于 30s 。 不配置此参数时表示不启用此功能。
3.5启动CSS ASM服务
#建议前台启动,前台日志中会刷更详细的关于ASM磁盘扫描的结果信息
./dmcss DCR_INI=/home/dmdba/dmdbms/dsc/dmdcr.ini
./dmasmsvr DCR_INI=/home/dmdba/dmdbms/dsc/dmdcr.ini
3.6创建ASM磁盘组
#注意:创建命令要以TXT文件进行备份
./dmasmtool DCR_INI=/home/dmdba/dmdbms/dsc/dmdcr.ini
ASM>create diskgroup 'DMDATA' asmdisk '/dev/raw/raw4'
ASM>create diskgroup 'DMLOG' asmdisk '/dev/raw/raw3'
3.7配置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 #dcr 磁盘路径,目前不支持 asm,只能是裸设备
dcr_seqno = 0
auto_overwrite = 1
[DSC0]
config_path =/home/dmdba/dmdbms/dsc/DSC01
port_num = 5236
mal_host = 192.168.10.11
mal_port = 9340
log_path = +DMLOG/log/dsc0_log01.log
log_path = +DMLOG/log/dsc0_log02.log
[DSC1]
config_path =/home/dmdba/dmdbms/dsc/DSC02
port_num = 5237
mal_host = 192.168.10.12
mal_port = 9341
log_path = +DMLOG/log/dsc1_log01.log
log_path = +DMLOG/log/dsc1_log02.log
3.8初始化数据库
在控制节点上启动dminit工具初始化数据库,然后会在dsc_config目录下生成DSC01,DSC02,再将生成的配置文件目录拷贝到对应节点的目录下
./dminit control=/home/dmdba/dmdbms/dsc/dminit.ini
scp -r /home/dmdba/dmdbms/dsc/DSC02 dmdba@192168.10.1: /home/dmdba/dmdbms/dsc
3.9配置归档
dm.ini中 ARCH_INI设置为1
1.本地文件系统配置归档(无备机的DSC,建议归档和备份文件放到本地存储上)
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /soft/DSC0
ARCH_FILE_SIZE = 512
ARCH_SPACE_LIMIT = 102400
[ARCHIVE_REMOTE1]
ARCH_TYPE = REMOTE
ARCH_DEST = DSC0
ARCH_INCOMING_PATH =/soft/DSC1
ARCH_FILE_SIZE = 512
ARCH_SPACE_LIMIT = 102400
3.10dmmal.ini
#所有节点均相同
MAL_CHECK_INTERVAL=87 #检测线程检测间隔 ,默认3 0 S
MAL_CONN_FAIL_INTERVAL=33 #检测线程认定链路断开的时间,默认1 0 S
MAL_SYS_BUF_SIZE=6000
MAL_BUF_SIZE=3000
MAL_VPOOL_SIZE=5000
MAL_COMPRESS_LEVEL=0
[MAL_INST0]
MAL_INST_NAME = DSC0
MAL_HOST = 10.0.0.1
MAL_PORT = 31246
MAL_INST_HOST = 192.168.10.11
MAL_INST_PORT = 5236
MAL_DW_PORT = 52141
MAL_INST_DW_PORT = 5276
[MAL_INST1]
MAL_INST_NAME = DSC1
MAL_HOST = 10.0.0.2
MAL_PORT = 31246
MAL_INST_HOST = 192.168.10.12
MAL_INST_PORT = 5236
MAL_DW_PORT = 52141
MAL_INST_DW_PORT = 5276
3.11启动
#分别启动实例
./dmserver /home/dmdba/dmdbms/dsc/DSC01/dm.ini dcr_ini=/home/dmdba/dmdbms/dsc/dmdcr.ini
#注册服务
./dm_service_installer.sh -t dmcss -p CSS0 -dcr_ini /home/dmdba/dmdbms/dsc/ dmdcr.ini
./dm_service_installer.sh -t dmasmsvr -p ASM0 -dcr_ini /home/dmdba/dmdbms/dsc/dmdcr.ini -y DmCSSServiceCSS0
./dm_service_installer.sh -t dmserver -p DSC0 -dm_ini /home/dmdba/dmdbms/dsc/DSC0/dm.ini -dcr_ini /home/dmdba/dmdbms/dsc/dmdcr.ini -y DmASMSvrServiceASM0
#启动服务,先启动CSS,ASM,DB
./DmCSSServiceCSS0 start
./DmASMSvrServiceASM0 start
./DmServiceDSC0 start
3.12配置监视器
vim /home/dmdba/dmdbms/dsc/dmcssm.ini
CSSM_OGUID = 210331
CSSM_CSS_IP = 10.0.0.1:31286
CSSM_CSS_IP = 10.0.0.2:31286
CSSM_LOG_PATH = /home/dmdba/dmdbms/log
CSSM_LOG_FILE_SIZE = 256
CSSM_LOG_SPACE_LIMIT = 1024