提示:文章写完后,目录可以自动生成,如何生成可参考右边的帮助文档
文章目录
一、前提
1、集群状态正常
二、集群配置
将集群配置信息导出,方便添加新节点信息
--导出集群信息
[dmdba@dm8rac1 ~]$ dmasmcmd
DMASMCMD V8
ASM>export dcrdisk '/dev/raw/raw1' to '/dm8/data/dmdcr_cfg_bak.ini'
ASMCMD export DCRDISK success.
Used time: 59.153(ms).
三、日志文件
1、添加日志
--为新节点添加日志文件
SQL> alter database add node logfile '+DGLOG/log/rddsc2_log01.log' size 128,'+DGLOG/log/rddsc2_log02.log' size 128;
2、确认日志
--确认日志文件
--登录
dmasmtool DCR_INI=/dm/dmdbms/dm8/data/dmdcr.ini
ASM>ls +DGLOG/log
file : rddsc0_log01.log
file : rddsc0_log02.log
file : rddsc1_log01.log
file : rddsc1_log02.log
file : rddsc2_log01.log
file : rddsc2_log02.log
total count 6.
Used time: 34.066(ms).
四、集群文件
将0号节点集群目录拷贝到新节点并命名为新节点
scp -r rddsc0_config IP:/dm/dmdbms/dm8/data
五、参数配置
集群扩展节点需配置若干配置文件,其中包含dm.ini文件,dmarch.ini文件,dmdcr.ini文件,dmasvrmal.ini文件,dmmal.ini文件,dmdcr_cfg.ini文件
1、参数文件
修改数据库实例名称和数据库配置路径
instance_anme = DSC2
config_path = /dm/dmdbms/dm8/data/rddsc2_config
2、归档参数文件
集群已配置归档此时需要调整归档内容.
原节点添加如下配置,假设原集群为2个节点
[ARCH_REMOTE2]
ARCH_TYPE = REMOTE
ARCH_DEST = DSC2
ARCH_INCOMING_PATH =+DMDATA/DSC2/arch
ARCH_FILE_SIZE = 128
ARCH_SPACE_LIMIT = 1024
新节点添加如下配置
ARCH_LOCAL_SHARE = 1
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST =+DMDATA/DSC2/arch
ARCH_FILE_SIZE = 128
ARCH_SPACE_LIMIT = 1024
[ARCH_REMOTE1]
ARCH_TYPE = REMOTE
ARCH_DEST = DSC0
ARCH_INCOMING_PATH =+DMDATA/DSC0/arch
ARCH_FILE_SIZE = 128
ARCH_SPACE_LIMIT = 1024
[ARCH_REMOTE2]
ARCH_TYPE = REMOTE
ARCH_DEST = DSC1
ARCH_INCOMING_PATH =+DMDATA/DSC1/arch
ARCH_FILE_SIZE = 128
ARCH_SPACE_LIMIT = 1024
3、dmdcr参数文件
DMDCR_PATH = /dev/raw/raw1
DMDCR_MAL_PATH =/dm/dmdbms/dm8/data/dmasvrmal.ini
DMDCR_SEQNO = 2
DMDCR_ASM_RESTART_INTERVAL = 10
DMDCR_ASM_STARTUP_CMD = /dm/dmdbms/dm8/bin/dmasmsvr DCR_INI=/dm/dmdbms/dm8/data/dmdcr.ini
DMDCR_DB_RESTART_INTERVAL = 20
DMDCR_DB_STARTUP_CMD = /dm/dmdbms/dm8/bin/dmserver path=/dm/dmdbms/dm8/data/rddsc2_config/dm.ini DCR_INI=/dm/dmdbms/dm8/data/dmdcr.ini
4、dmasvrmal参数文件
[MAL_INST1]
MAL_INST_NAME = ASM0
MAL_HOST = 10.10.10.60
MAL_PORT = 7236
[MAL_INST2]
MAL_INST_NAME = ASM1
MAL_HOST =10.10.10.61
MAL_PORT = 7236
[MAL_INST3]
MAL_INST_NAME = ASM2
MAL_HOST =10.10.10.62
MAL_PORT = 7236
5、dmmal参数文件
[mal_inst0]
mal_inst_name = DSC0
mal_host = 10.10.10.60
mal_port = 9340
[mal_inst1]
mal_inst_name = DSC1
mal_host = 10.10.10.61
mal_port = 9340
[mal_inst2]
mal_inst_name = DSC2
mal_host = 10.10.10.62
mal_port = 9340
6、dmdcr_cfg参数文件
# the file is auto-created by system, self edit is invalid!
#DCR HDR
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 =3
DCR_GRP_EP_ARR = {0,1,2}
DCR_GRP_N_ERR_EP = 0
DCR_GRP_ERR_EP_ARR = {}
DCR_GRP_DSKCHK_CNT = 60
[GRP]
DCR_GRP_TYPE = ASM
DCR_GRP_NAME = GRP_ASM
DCR_GRP_N_EP = 3
DCR_GRP_EP_ARR = {0,1,2}
DCR_GRP_N_ERR_EP = 0
DCR_GRP_ERR_EP_ARR = {}
DCR_GRP_DSKCHK_CNT = 60
[GRP]
DCR_GRP_TYPE = DB
DCR_GRP_NAME = GRP_DSC
DCR_GRP_N_EP =3
DCR_GRP_EP_ARR = {0,1,2}
DCR_GRP_N_ERR_EP = 0
DCR_GRP_ERR_EP_ARR = {}
DCR_GRP_DSKCHK_CNT = 60
[GRP_CSS]
DCR_EP_NAME = CSS0
DCR_EP_HOST = 10.10.10.60
DCR_EP_PORT = 9341
[GRP_CSS]
DCR_EP_NAME = CSS1
DCR_EP_HOST = 10.10.10.61
DCR_EP_PORT = 9341
[GRP_CSS]
DCR_EP_NAME = CSS2
DCR_EP_HOST = 10.10.10.62
DCR_EP_PORT = 9341
[GRP_ASM]
DCR_EP_NAME = ASM0
DCR_EP_SHM_KEY = 93360
DCR_EP_SHM_SIZE = 20
DCR_EP_HOST = 10.10.10.60
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 = 10.10.10.61
DCR_EP_PORT = 9349
DCR_EP_ASM_LOAD_PATH = /dev/raw
[GRP_ASM]
DCR_EP_NAME = ASM2
DCR_EP_SHM_KEY = 93362
DCR_EP_SHM_SIZE = 20
DCR_EP_HOST = 10.10.10.62
DCR_EP_PORT = 9349
DCR_EP_ASM_LOAD_PATH = /dev/raw
[GRP_DSC]
DCR_EP_NAME = DSC0
DCR_EP_SEQNO = 0
DCR_EP_PORT = 5237
DCR_CHECK_PORT = 9741
[GRP_DSC]
DCR_EP_NAME = DSC1
DCR_EP_SEQNO = 1
DCR_EP_PORT = 5237
DCR_CHECK_PORT = 9741
[GRP_DSC]
DCR_EP_NAME = DSC2
DCR_EP_SEQNO = 2
DCR_EP_PORT = 5237
DCR_CHECK_PORT = 9741
六、更新集群配置
配置新集群信息完成后将信息回写到DCR磁盘
1、更新DRC信息
dmasmcmd
ASM>extend dcrdisk '/dev/raw/raw1' from '/dm/dmdbms/dm8/data/dmdcr_cfg_bak.ini'
ASMCMD extend node for dcr disk success.
ASMCMD extend node for vote disk success.
Used time: 188.817(ms).
ASM>
七、 扩展节点
1、执行扩展
dmcssm ini_path=/dm/dmdbms/dm8/data/dmcssm.ini
extend node
八、注册服务
1、注册服务
/dm/dmdbms/dm8/script/root/dm_service_installer.sh -t dmcss -dcr_ini /dm/dmdbms/dm8/data/dmdcr.ini -p rddsc2
/dm/dmdbms/dm8/script/root/dm_service_installer.sh -t dmasmsvr -dcr_ini /dm/dmdbms/dm8/data/dmdcr.ini -p rddsc2 -y DmCSSServicerddsc2
/dm/dmdbms/dm8/script/root/dm_service_installer.sh -t dmserver -dm_ini /dm/dmdbms/dm8/data/rddsc2_config/dm.ini -dcr_ini /dm/dmdbms/dm8/data/dmdcr.ini -p rddsc2 -y
九、启动
启动集群同步服务自动拉起ASM和DMSERVER
systemctl start DmCSSServicerddsc2.service
[root@dsc3 ~]# systemctl start DmCSSServicerddsc2.service
[root@dsc3 ~]# systemctl status DmCSSServicerddsc2.service
● DmCSSServicerddsc2.service - DM Cluster Synchronization Services Service(DmCSSServicerddsc2).
Loaded: loaded (/usr/lib/systemd/system/DmCSSServicerddsc2.service; enabled; vendor preset: disabled)
Active: active (running) since Sun 2022-06-12 11:42:38 CST; 1h 35min ago
Process: 2255 ExecStart=/dm/dmdbms/dm8/bin/DmCSSServicerddsc2 start (code=exited, status=0/SUCCESS)
Main PID: 2278 (dmcss)
Tasks: 103
CGroup: /system.slice/DmCSSServicerddsc2.service
├─2278 /dm/dmdbms/dm8/bin/dmcss dcr_ini=/dm/dmdbms/dm8/data/dmdcr.ini -noconsole
├─2303 /dm/dmdbms/dm8/bin/dmasmsvr DCR_INI=/dm/dmdbms/dm8/data/dmdcr.ini
└─2335 /dm/dmdbms/dm8/bin/dmserver path=/dm/dmdbms/dm8/data/rddsc2_config/dm.ini DCR_INI=/dm/dmdbms/dm8/data/dmdcr.ini
Jun 12 11:42:23 dsc3 systemd[1]: Starting DM Cluster Synchronization Services Service(DmCSSServicerddsc2)....
Jun 12 11:42:38 dsc3 DmCSSServicerddsc2[2255]: [40B blob data]
Jun 12 11:42:38 dsc3 systemd[1]: Started DM Cluster Synchronization Services Service(DmCSSServicerddsc2)..
注意:集群节点扩展前一定确认集群状态为正常,扩展失败可重新将正确的集群配置文件导回DCR磁盘
总结
以上是达梦8DSC集群节点扩展内容,更多内容请参考 https://eco.dameng.com/