书接上回。
https://blog.csdn.net/lushanglou/article/details/119329620
裸设备绑定之后,我们需要在两台机器上分别安装数据库,创建配置文件目录。
此处我们创建的配置文件目录为/home/data
在/home/data里面放入我们写好的两个配置文件:
dmdcr_cfg.ini
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 = 192.168.216.130
DCR_EP_PORT = 9341[GRP_CSS]
DCR_EP_NAME = CSS1
DCR_EP_HOST = 192.168.216.131
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 = 20
DCR_EP_HOST = 192.168.216.130
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 = 20
DCR_EP_HOST = 192.168.216.131
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_PORT = 5236
DCR_CHECK_PORT = 9741[GRP_DSC]
DCR_EP_NAME = DSC1
DCR_EP_SEQNO = 1
DCR_EP_PORT = 5237
DCR_CHECK_PORT = 9742
以及asmcmd.txt
#asm script file
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'
然后执行dmasmcmd script_file=/home/data/asmcmd.txt
此时如果执行报错,可以检查配置文件是否书写正确,以及磁盘权限、执行命令的权限。注意脚本以#asm script file开头。
在本次实验中,/etc/udev/rules.d/70-persistent-ipoib.rules文件
ACTION=="add", KERNEL=="raw[1-4]", OWNER="dmdba", GROUP="dinstall", MODE="660"
注意磁盘所有者。修改后可执行以下命令生效:
[root@localhost bin]# partprobe /dev/sdb
[root@localhost bin]# /sbin/udevadm control --reload
执行dmasmcmd成功后:
[root@localhost bin]# dmasmcmd script_file=/home/data/asmcmd.txt
DMASMCMD V8
ASM>create dcrdisk '/dev/raw/raw1' 'dcr'[Trace]The ASM initialize dcrdisk /dev/raw/raw1 to name DMASMdcr
Used time: 38.114(ms).
ASM>create votedisk '/dev/raw/raw2' 'vote'[Trace]The ASM initialize votedisk /dev/raw/raw2 to name DMASMvote
Used time: 00:00:09.659.
ASM>create asmdisk '/dev/raw/raw3' 'LOG0'[Trace]The ASM initialize asmdisk /dev/raw/raw3 to name DMASMLOG0
Used time: 4.012(ms).
ASM>create asmdisk '/dev/raw/raw4' 'DATA0'[Trace]The ASM initialize asmdisk /dev/raw/raw4 to name DMASMDATA0
Used time: 3.913(ms).
ASM>init dcrdisk '/dev/raw/raw1' from '/home/data/dmdcr_cfg.ini' identified by 'abcd'[Trace]DG 126 allocate 4 extents for file 0xfe000002.
Used time: 118.618(ms).
ASM>init votedisk '/dev/raw/raw2' from '/home/data/dmdcr_cfg.ini'
[Trace]DG 125 allocate 4 extents for file 0xfd000002.
Used time: 00:00:09.684.
[root@localhost bin]#
此时初始化就成功了。
在第一个节点/home/data上传dmdcr.ini
DMDCR_PATH = /dev/raw/raw1
DMDCR_MAL_PATH = /home/data/dmasvrmal.ini #dmasmsvr使用的MAL配置文件路径
DMDCR_SEQNO = 0 # DSC1节点为1
DMDCR_ASM_RESTART_INTERVAL = 0 #ASM重启参数,命令行方式启动
DMDCR_ASM_STARTUP_CMD = /dm8/bin/dmasmsvr dcr_ini=/home/data/dmdcr.iniDMDCR_DB_RESTART_INTERVAL = 0 #DB重启参数,命令行方式启动
DMDCR_DB_STARTUP_CMD = /dm8/bin/dmserver path=/home/data/dsc0_config/dm.ini dcr_ini=/home/data/dmdcr.ini
在第二个节点同样上传dmdcr.ini
DMDCR_PATH = /dev/raw/raw1
DMDCR_MAL_PATH =/home/data/dmasvrmal.ini #dmasmsvr使用的MAL配置文件路径
DMDCR_SEQNO = 1 # DSC1节点为1
DMDCR_ASM_RESTART_INTERVAL = 0 #ASM重启参数,命令行方式启动
DMDCR_ASM_STARTUP_CMD = /dm8/bin/dmasmsvr
dcr_ini=/home/data/dmdcr.ini
DMDCR_DB_RESTART_INTERVAL = 0 #DB重启参数,命令行方式启动
DMDCR_DB_STARTUP_CMD = /dm8/bin/dmserver
path=/home/data/dsc1_config/dm.ini
dcr_ini=/home/data/dmdcr.ini
注意不要错误换行
之后两个节点依次启动DMCSS与DMASM服务:
./dmcss DCR_INI=/home/data/dmdcr.ini
./dmasmsvr DCR_INI=/home/data/dmdcr.ini
以下是其中一个节点:
[root@localhost bin]# ./dmcss DCR_INI=/home/data/dmdcr.ini
DMCSS V8
DMCSS IS READY
[CSS]: 设置EP CSS1[1]为控制节点[ASM]: 设置EP ASM0[0]为控制节点
[ASM]: 设置命令[START NOTIFY], 目标站点 ASM0[0], 命令序号[2]
[ASM]: 设置命令[EP START], 目标站点 ASM0[0], 命令序号[3]
[ASM]: 设置命令[NONE], 目标站点 ASM0[0], 命令序号[0]
[ASM]: 设置命令[EP START], 目标站点 ASM1[1], 命令序号[5]
[ASM]: 设置命令[NONE], 目标站点 ASM1[1], 命令序号[0]
[ASM]: 设置命令[EP OPEN], 目标站点 ASM0[0], 命令序号[8]
[ASM]: 设置命令[EP OPEN], 目标站点 ASM1[1], 命令序号[9]
[ASM]: 设置命令[NONE], 目标站点 ASM0[0], 命令序号[0]
[ASM]: 设置命令[NONE], 目标站点 ASM1[1], 命令序号[0]
[ASM]: 设置命令[EP REAL OPEN], 目标站点 ASM0[0], 命令序号[11]
[ASM]: 设置命令[EP REAL OPEN], 目标站点 ASM1[1], 命令序号[12]
[ASM]: 设置命令[NONE], 目标站点 ASM0[0], 命令序号[0]
[ASM]: 设置命令[NONE], 目标站点 ASM1[1], 命令序号[0]
[root@localhost bin]# ./dmasmsvr DCR_INI=/home/data/dmdcr.ini
ASM SELF EPNO:1
DMASMSVR V8
dmasmsvr task worker thread startup
the ASM server is Ready.
check css cmd: EP START, cmd_seq: 5ASM Control Node EPNO:0
check css cmd: EP OPEN, cmd_seq: 9
check css cmd: EP REAL OPEN, cmd_seq: 12
在其中一个节点上创建asm磁盘组
[root@localhost bin]# ./dmasmtool DCR_INI=/home/data/dmdcr.ini
DMASMTOOL V8
ASM>create diskgroup 'DMLOG' asmdisk '/dev/raw/raw3'
Used time: 19.462(ms).
ASM>create diskgroup 'DMDATA' asmdisk '/dev/raw/raw4'
Used time: 19.843(ms).
ASM>
准备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] #inst_name 跟 dmdcr_cfg.ini 中 DB 类型 group 中 DCR_EP_NAME 对应
config_path = /home/data/dsc0_config
port_num = 5236
mal_host = 192.168.216.130
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 = /home/data/dsc1_config
port_num = 5237
mal_host = 192.168.216.131
mal_port = 9341
log_path = +DMLOG/log/dsc1_log01.log
log_path = +DMLOG/log/dsc1_log02.log
然后将dminit.ini上传到其中一个节点的/home/data
之后在该节点执行数据库初始化:
[dmdba@localhost bin]$ ./dminit control=/home/data/dminit.ini
initdb V8
db version: 0x7000c
file dm.key not found, use default license!
License will expire on 2022-05-13
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLLlog file path: +DMLOG/log/dsc0_log01.log
log file path: +DMLOG/log/dsc0_log02.log
log file path: +DMLOG/log/dsc1_log01.log
log file path: +DMLOG/log/dsc1_log02.logwrite to dir [+DMDATA/data/dsc].
create dm database success. 2021-08-03 17:38:13
然后拷贝生成的dsc1_config目录到另外节点。
最后分别启动两个节点的dmserver。
[root@localhost bin]# ./dmserver /home/data/dsc1_config/dm.ini dcr_ini=/home/data/dmdcr.ini
file dm.key not found, use default license!
version info: develop
DM Database Server x64 V8 1-2-2-21.05.13-139380-10006-ENT startup...
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
Database mode = 0, oguid = 0
License will expire on 2022-05-13
check CSS cmd: DCR_LOAD, cmd_seq: 4
check CSS cmd: EP START, cmd_seq: 8
Control Node change from 255 to 0
[root@localhost bin]# ./dmserver /home/data/dsc0_config/dm.ini dcr_ini=/home/data/dmdcr.ini
file dm.key not found, use default license!
version info: develop
DM Database Server x64 V8 1-2-2-21.05.13-139380-10006-ENT startup...
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
Database mode = 0, oguid = 0
License will expire on 2022-05-13
至此DSC双节点已搭建完成。
以下是验证效果:
在本地win10上启动DM管理工具,分别连接192.168.216.130:5236和192.168.216.131:5237
在192.168.216.130:5236上执行:
create table test1 (ID int);
insert into test1 values (10086);
insert into test1 values (10000);
insert into test1 values (10001);
commit;
在192.168.216.131:5237上执行:
insert into test1 values (80);
insert into test1 values (90);
insert into test1 values (100);
select ID from test1;
在192.168.216.131:5237上执行结果为:
可见DSC成功实现了双写。
更多参考内容请访问达梦云适配中心