注册
达梦数据库:DM共享存储集群维护管理
专栏/技术分享/ 文章详情 /

达梦数据库:DM共享存储集群维护管理

肖鹏程 2023/10/07 1341 0 0
摘要

1.配置连接服务名

192.168.40.135/136

vi /etc/dm_svc.conf

xpcdsc=(192.168.40.135:5236,192.168.40.136:5236) 
SWITCH_INTERVAL=(3) 
SWITCH_TIME=(10000)
TIME_ZONE=(480) 
LANGUAGE=(cn)

image.png

2.负载均衡测试

通过服务名多次登录数据库进行查看

disql sysdba/dameng123@xpcdsc

image.png

3.DMDSC启动与关闭流程

生产建议把这些服务设置为开机手工启动
启动顺序:

DMCSS—>DMASMSVR—>DMSERVICE

以下是详细的启动流程:

192.168.40.135:
root:
systemctl disable DmCSSServicexpcdsc1 
systemctl disable DmASMSvrServicexpcdsc1 
systemctl disable DmServicexpcdsc1

systemctl start DmCSSServicexpcdsc1 
systemctl start DmASMSvrServicexpcdsc1 
systemctl start DmServicexpcdsc1
or:
su - dmdba 
DmCSSServicexpcdsc1 start 
DmASMSvrServicexpcdsc1 start 
DmServicexpcdsc1 start

192.168.40.136:
root:
systemctl disable DmCSSServicexpcdsc2 
systemctl disable DmASMSvrServicexpcdsc2 
systemctl disable DmServicexpcdsc2

systemctl start DmCSSServicexpcdsc2 
systemctl start DmASMSvrServicexpcdsc2 
systemctl start DmServicexpcdsc2
or:
su - dmdba
DmCSSServicexpcdsc2 start 
DmASMSvrServicexpcdsc2 start 
DmServicexpcdsc2 start

关闭顺序:
DMSERVICE—>DMASMSVR—>DMCSS
以下是详细的关闭流程:

192.168.40.135:
root:
systemctl stop DmServicexpcdsc1 
systemctl stop DmASMSvrServicexpcdsc1 
systemctl stop DmCSSServicexpcdsc1 
or:
su - dmdba 
DmServicexpcdsc1 stop
DmASMSvrServicexpcdsc1 stop 
DmCSSServicexpcdsc1 stop

192.168.40.136:
root:
systemctl stop DmServicexpcdsc2 
systemctl stop DmASMSvrServicexpcdsc2 
systemctl stop DmCSSServicexpcdsc2 
or:
su - dmdba 
DmServicexpcdsc2 stop
DmASMSvrServicexpcdsc2 stop 
DmCSSServicexpcdsc2 stop

然后重启主机,检查是否可以自动启动

4.DMDSC集群归档配置

集群归档配置需要配置本地与远程,以下为配置示例:
xpcdsc1:

vi /dm/dmdbms/dm8/data/xpcdsc1_config/dmarch.ini 
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /dm/dmarch/xpcdsc1 
ARCH_FILE_SIZE = 128
ARCH_SPACE_LIMIT = 0

[ARCH_REMOTE1] ARCH_TYPE = REMOTE
ARCH_DEST = xpcdsc2 
ARCH_INCOMING_PATH = /dm/dmarch/xpcdsc2 
ARCH_FILE_SIZE = 128
ARCH_SPACE_LIMIT = 0

vi /dm/dmdbms/dm8/data/xpcdsc1_config/dm.ini
ARCH_INI=1

xpcdsc2:

vi /dm/dmdbms/dm8/data/xpcdsc2_config/dmarch.ini

[ARCHIVE_LOCAL1] 
ARCH_TYPE = LOCAL
ARCH_DEST = /dm/dmarch/xpcdsc2 
ARCH_FILE_SIZE = 128
ARCH_SPACE_LIMIT = 0

[ARCH_REMOTE1] 
ARCH_TYPE = REMOTE
ARCH_DEST = xpcdsc1 
ARCH_INCOMING_PATH = /dm/dmarch/xpcdsc1 
ARCH_FILE_SIZE = 128
ARCH_SPACE_LIMIT = 0

vi /dm/dmdbms/dm8/data/xpcdsc2_config/dm.ini 
ARCH_INI=1

5.往磁盘组添加磁盘

在DMDSC集群中 如果碰到磁盘组空间不够的情况,这时候需要往磁盘组添加磁盘,以下是具体的操作示例:
image.png
image.png
image.png

alter diskgroup 'dgdata01' add asmdisk '/dev/dm/asm-datadisk2'
lsdg

image.png

https://eco.dameng.com

评论
后发表回复

作者

文章

阅读量

获赞

扫一扫
联系客服