达梦数据库-通过DEM搭建数据守护集群

1、部署达梦DEM系统

通过东方通部署DEM

https://blog.csdn.net/qq_33809566/article/details/108994150

通过Tomcat部署DEM

https://blog.csdn.net/qq_33809566/article/details/109178862

2、配置数据库配置dmagent

配置dmagent

https://blog.csdn.net/qq_33809566/article/details/109194815

3、搭建数据守护

点击部署集群

在这里插入图片描述

输入集群名称

在这里插入图片描述

选择数据守护-主备

在这里插入图片描述

选择数据库节点

在这里插入图片描述

修改节点相关参数

在这里插入图片描述
在这里插入图片描述

配置系统启动服务名称

在这里插入图片描述
在这里插入图片描述

自定义服务名称

在这里插入图片描述

设置主备库关系

在这里插入图片描述

配置实例

在这里插入图片描述

配置dm.ini相关参数

在这里插入图片描述

设置MAL系统相关参数

在这里插入图片描述

配置归档

在这里插入图片描述

设置数据守护相关参数

在这里插入图片描述

配置监视器到备机

在这里插入图片描述

将达梦数据库bin目录打包成zip格式进行上传

在这里插入图片描述

 Connecting to 192.168.1.60:22...
Connection established.
To escape to local shell, press 'Ctrl+Alt+]'.

Last login: Tue Oct 27 10:54:25 2020
[dmdba@localhost ~]$ 
[dmdba@localhost ~]$ cd /opt/dmdbms
[dmdba@localhost dmdbms]$ pwd
/opt/dmdbms
[dmdba@localhost dmdbms]$ ll
总用量 40
drwxr-xr-x.  8 dmdba dmdba 8192 10月 27 10:55 bin
drwxr-xr-x.  2 dmdba dmdba   30 9月  17 14:12 bin2
drwxrwxr-x.  2 dmdba dmdba    6 10月 27 10:55 data
drwxr-xr-x.  3 dmdba dmdba   19 9月  17 14:12 desktop
drwxr-xr-x.  2 dmdba dmdba 4096 9月  17 14:12 doc
drwxr-xr-x. 10 dmdba dmdba  103 9月  17 14:12 drivers
drwxr-xr-x.  2 dmdba dmdba 4096 9月  17 14:12 include
drwxr-xr-x.  2 dmdba dmdba   94 9月  17 14:12 jar
drwxr-xr-x.  6 dmdba dmdba   54 9月  17 14:12 jdk
-rwxr-xr-x.  1 dmdba dmdba 1066 9月  17 14:12 license_en.txt
-rwxr-xr-x.  1 dmdba dmdba 1128 9月  17 14:12 license_zh.txt
drwxr-xr-x.  2 dmdba dmdba 4096 10月 27 10:55 log
drwxr-xr-x.  6 dmdba dmdba   92 9月  17 14:12 samples
drwxr-xr-x.  3 dmdba dmdba   37 9月  17 14:12 script
drwxr-xr-x.  9 dmdba dmdba 4096 10月 20 09:20 tool
drwxr-xr-x.  3 dmdba dmdba   97 9月  17 14:12 uninstall
-rwxr-xr-x.  1 dmdba dmdba 2433 9月  17 14:12 uninstall.sh
drwxr-xr-x.  2 dmdba dmdba   92 9月  17 14:12 web
[dmdba@localhost dmdbms]$ zip -r bin.zip bin
bin/  bin2/ 
[dmdba@localhost dmdbms]$ zip -r bin.zip bin/
  adding: bin/ (stored 0%)
  adding: bin/SYSWORD.UTF8.LIB (deflated 62%)
  adding: bin/client_ssl/ (stored 0%)
  adding: bin/client_ssl/DEVELOP/ (stored 0%)
  adding: bin/client_ssl/DEVELOP/.keystore (deflated 31%)
  adding: bin/client_ssl/DEVELOP/ca-cert.pem (deflated 29%)
  adding: bin/client_ssl/DEVELOP/client-cert.pem (deflated 44%)
  adding: bin/client_ssl/DEVELOP/client-key.pem (deflated 22%)
  adding: bin/client_ssl/DEVELOP/client-pkcs.p12 (deflated 0%)
  adding: bin/client_ssl/DEVELOP/client.csr (deflated 24%)
  adding: bin/client_ssl/DMHR/ (stored 0%)
  adding: bin/client_ssl/DMHR/.keystore (deflated 31%)
  adding: bin/client_ssl/DMHR/ca-cert.pem (deflated 29%)
  adding: bin/client_ssl/DMHR/client-cert.pem (deflated 44%)
  adding: bin/client_ssl/DMHR/client-key.pem (deflated 22%)
  adding: bin/client_ssl/SYSAUDITOR/ (stored 0%)
  adding: bin/client_ssl/SYSAUDITOR/.keystore (deflated 31%)
  adding: bin/client_ssl/SYSAUDITOR/ca-cert.pem (deflated 29%)
  adding: bin/client_ssl/SYSAUDITOR/client-cert.pem (deflated 44%)
  adding: bin/client_ssl/SYSAUDITOR/client-key.pem (deflated 22%)
  adding: bin/client_ssl/SYSDBA/ (stored 0%)
  adding: bin/client_ssl/SYSDBA/.keystore (deflated 32%)
  adding: bin/client_ssl/SYSDBA/ca-cert.pem (deflated 29%)
  adding: bin/client_ssl/SYSDBA/client-cert.pem (deflated 44%)
  adding: bin/client_ssl/SYSDBA/client-key.pem (deflated 22%)
  adding: bin/client_ssl/SYSDBO/ (stored 0%)
  adding: bin/client_ssl/SYSDBO/.keystore (deflated 31%)
  adding: bin/client_ssl/SYSDBO/ca-cert.pem (deflated 29%)
  adding: bin/client_ssl/SYSDBO/client-cert.pem (deflated 44%)
  adding: bin/client_ssl/SYSDBO/client-key.pem (deflated 22%)
  adding: bin/client_ssl/SYSSSO/ (stored 0%)
  adding: bin/client_ssl/SYSSSO/.keystore (deflated 31%)
  adding: bin/client_ssl/SYSSSO/ca-cert.pem (deflated 29%)
  adding: bin/client_ssl/SYSSSO/client-cert.pem (deflated 44%)
  adding: bin/client_ssl/SYSSSO/client-key.pem (deflated 22%)
  adding: bin/libacdct.so (deflated 65%)
  adding: bin/libcrypto.so (deflated 57%)
  adding: bin/libcyt_java.so (deflated 49%)
  adding: bin/libdisql_dll.so (deflated 57%)
  adding: bin/libdmamon.so (deflated 66%)
  adding: bin/libdmapx.so (deflated 65%)
  adding: bin/libdmasm.so (deflated 58%)
  adding: bin/libdmasmapi.so (deflated 60%)
  adding: bin/libdmasmparse.so (deflated 63%)
  adding: bin/libdmasvr.so (deflated 60%)
  adding: bin/libdmaud.so (deflated 58%)
  adding: bin/libdmbak2.so (deflated 59%)
  adding: bin/libdmbcast.so (deflated 63%)
  adding: bin/libdmbcast2.so (deflated 63%)
  adding: bin/libdmbifun.so (deflated 59%)
  adding: bin/libdmblb.so (deflated 56%)
  adding: bin/libdmbldr.so (deflated 58%)
  adding: bin/libdmbrtsk.so (deflated 59%)
  adding: bin/libdmbtr.so (deflated 59%)
  adding: bin/libdmcalc.so (deflated 56%)
  adding: bin/libdmcfg.so (deflated 64%)
  adding: bin/libdmckpt.so (deflated 59%)
  adding: bin/libdmclientlex.so (deflated 92%)
  adding: bin/libdmcomm.so (deflated 59%)
  adding: bin/libdmcpr.so (deflated 72%)
  adding: bin/libdmcpt.so (deflated 74%)
  adding: bin/libdmcrypt.so (deflated 58%)
  adding: bin/libdmcss.so (deflated 69%)
  adding: bin/libdmcssmon.so (deflated 77%)
  adding: bin/libdmcti.so (deflated 55%)
  adding: bin/libdmcvt.so (deflated 58%)
  adding: bin/libdmcyt.so (deflated 58%)
  adding: bin/libdmdbg.so (deflated 53%)
  adding: bin/libdmdci.so (deflated 61%)
  adding: bin/libdmdcp.so (deflated 55%)
  adding: bin/libdmdcr.so (deflated 62%)
  adding: bin/libdmdct.so (deflated 61%)
  adding: bin/libdmde.so (deflated 66%)
  adding: bin/libdmdfi.so (deflated 60%)
  adding: bin/libdmdfs.so (deflated 63%)
  adding: bin/libdmdpc.so (deflated 61%)
  adding: bin/libdmdpc_nts.so (deflated 61%)
  adding: bin/libdmdpi.so (deflated 61%)
  adding: bin/libdmdrs.so (deflated 59%)
  adding: bin/libdmdta.so (deflated 58%)
  adding: bin/libdmelog.so (deflated 65%)
  adding: bin/libdmexe.so (deflated 73%)
  adding: bin/libdmfil.so (deflated 58%)
  adding: bin/libdmfldr.so (deflated 61%)
  adding: bin/libdmfldr_comm.so (deflated 68%)
  adding: bin/libdmfldr_dll_java.so (deflated 66%)
  adding: bin/libdmhfs.so (deflated 55%)
  adding: bin/libdmimon.so (deflated 60%)
  adding: bin/libdmimon_dll_java.so (deflated 63%)
  adding: bin/libdmjmon.so (deflated 66%)
  adding: bin/libdmjob.so (deflated 61%)
  adding: bin/libdmjschdl.so (deflated 61%)
  adding: bin/libdmjson.so (deflated 70%)
  adding: bin/libdmknl.so (deflated 56%)
  adding: bin/libdmlic.so (deflated 53%)
  adding: bin/libdmllog.so (deflated 59%)
  adding: bin/libdmlnk.so (deflated 56%)
  adding: bin/libdmlogmnr.so (deflated 62%)
  adding: bin/libdmlogmnr_client.so (deflated 62%)
  adding: bin/libdmmal.so (deflated 58%)
  adding: bin/libdmmc.so (deflated 50%)
  adding: bin/libdmmem.so (deflated 57%)
  adding: bin/libdmmout.so (deflated 72%)
  adding: bin/libdmmsg.so (deflated 55%)
  adding: bin/libdmmsg_parse.so (deflated 61%)
  adding: bin/libdmnci.so (deflated 73%)
  adding: bin/libdmnlssort.so (deflated 95%)
  adding: bin/libdmnsort.so (deflated 55%)
  adding: bin/libdmocci.so (deflated 68%)
  adding: bin/libdmoci.so (deflated 61%)
  adding: bin/libdmoopi.so (deflated 71%)
  adding: bin/libdmopt.so (deflated 61%)
  adding: bin/libdmos.so (deflated 62%)
  adding: bin/libdmp_disql_dll_java.so (deflated 63%)
  adding: bin/libdmp_dll.so (deflated 70%)
  adding: bin/libdmpara.so (deflated 71%)
  adding: bin/libdmpif.so (deflated 65%)
  adding: bin/libdmrac.so (deflated 56%)
  adding: bin/libdmrarch.so (deflated 59%)
  adding: bin/libdmreadline.so (deflated 76%)
  adding: bin/libdmredo.so (deflated 60%)
  adding: bin/libdmregex.so (deflated 59%)
  adding: bin/libdmrep.so (deflated 58%)
  adding: bin/libdmrlog.so (deflated 60%)
  adding: bin/libdmrman.so (deflated 64%)
  adding: bin/libdmrps.so (deflated 58%)
  adding: bin/libdmrs.so (deflated 66%)
  adding: bin/libdmrtree.so (deflated 55%)
  adding: bin/libdmsbt.so (deflated 60%)
  adding: bin/libdmsbtex.so (deflated 63%)
  adding: bin/libdmsbtree.so (deflated 68%)
  adding: bin/libdmscp.so (deflated 56%)
  adding: bin/libdmsess.so (deflated 58%)
  adding: bin/libdmshm.so (deflated 70%)
  adding: bin/libdmshpldr.so (deflated 85%)
  adding: bin/libdmstg.so (deflated 60%)
  adding: bin/libdmstrt.so (deflated 56%)
  adding: bin/libdmsys.so (deflated 67%)
  adding: bin/libdmtbl.so (deflated 64%)
  adding: bin/libdmtimer.so (deflated 59%)
  adding: bin/libdmtrc.so (deflated 62%)
  adding: bin/libdmtrv.so (deflated 61%)
  adding: bin/libdmtrx.so (deflated 57%)
  adding: bin/libdmuthr.so (deflated 57%)
  adding: bin/libdmutl.so (deflated 45%)
  adding: bin/libdmvtdsk.so (deflated 63%)
  adding: bin/libdmwseg.so (deflated 51%)
  adding: bin/libdmxa.so (deflated 76%)
  adding: bin/libdmxmal.so (deflated 58%)
  adding: bin/libdodbc.so (deflated 62%)
  adding: bin/libdwatcher.so (deflated 72%)
  adding: bin/libdwmon.so (deflated 79%)
  adding: bin/libgeos.so (deflated 67%)
  adding: bin/libgeos_c.so (deflated 68%)
  adding: bin/libregex.so (deflated 50%)
  adding: bin/libsnappy.so (deflated 56%)
  adding: bin/libssl.so (deflated 62%)
  adding: bin/libxerces-c-3.1.so (deflated 67%)
  adding: bin/libxerces-c.so (deflated 67%)
  adding: bin/libxqilla.so (deflated 72%)
  adding: bin/libz.so (deflated 49%)
  adding: bin/server_ssl/ (stored 0%)
  adding: bin/server_ssl/ca-cert.pem (deflated 29%)
  adding: bin/server_ssl/server-cert.pem (deflated 44%)
  adding: bin/server_ssl/server-key.pem (deflated 22%)
  adding: bin/lib/ (stored 0%)
  adding: bin/DmAPService (deflated 78%)
  adding: bin/DmAuditMonitorService (deflated 78%)
  adding: bin/DmInstanceMonitorService (deflated 78%)
  adding: bin/DmJobMonitorService (deflated 78%)
  adding: bin/ac (deflated 69%)
  adding: bin/acdg (deflated 78%)
  adding: bin/asmtest (deflated 57%)
  adding: bin/cexe (deflated 67%)
  adding: bin/dclone (deflated 63%)
  adding: bin/dexp (deflated 71%)
  adding: bin/dimp (deflated 71%)
  adding: bin/disql (deflated 71%)
  adding: bin/dmamon_ctl (deflated 70%)
  adding: bin/dmap (deflated 67%)
  adding: bin/dmap_br (deflated 74%)
  adding: bin/dmasmcmd (deflated 65%)
  adding: bin/dmasmsvr (deflated 59%)
  adding: bin/dmasmtool (deflated 60%)
  adding: bin/dmaudtool (deflated 68%)
  adding: bin/dmcss (deflated 70%)
  adding: bin/dmcssm (deflated 73%)
  adding: bin/dmctlcvt (deflated 64%)
  adding: bin/dmdata_cmp (deflated 72%)
  adding: bin/dmdbchk (deflated 65%)
  adding: bin/dmdbg (deflated 57%)
  adding: bin/dmdcrs (deflated 61%)
  adding: bin/dmdcs (deflated 61%)
  adding: bin/dmdcstool (deflated 70%)
  adding: bin/dmdras (deflated 63%)
  adding: bin/dmdrs (deflated 57%)
  adding: bin/dmdss (deflated 62%)
  adding: bin/dmdssinit (deflated 65%)
  adding: bin/dmfldr (deflated 60%)
  adding: bin/dmkey (deflated 69%)
  adding: bin/dmlcvt (deflated 69%)
  adding: bin/dmmdf (deflated 60%)
  adding: bin/dmmonitor (deflated 86%)
  adding: bin/dmrachk (deflated 73%)
  adding: bin/dmrdc (deflated 77%)
  adding: bin/dmrman (deflated 69%)
  adding: bin/dmrslcvt (deflated 66%)
  adding: bin/dmshp2st (deflated 55%)
  adding: bin/dmst2shp (deflated 59%)
  adding: bin/dmwatcher (deflated 72%)
  adding: bin/dpc_new (deflated 63%)
  adding: bin/dreplay (deflated 59%)
  adding: bin/jexe (deflated 60%)
  adding: bin/jobdts (deflated 63%)
  adding: bin/rac_reinit (deflated 61%)
  adding: bin/service_desc_list (stored 0%)
  adding: bin/service_template/ (stored 0%)
  adding: bin/service_template/DmASMSvrService (deflated 78%)
  adding: bin/service_template/DmCSSMonitorService (deflated 78%)
  adding: bin/service_template/DmCSSService (deflated 78%)
  adding: bin/service_template/DmDCSService (deflated 78%)
  adding: bin/service_template/DmDRASService (deflated 78%)
  adding: bin/service_template/DmDRSService (deflated 78%)
  adding: bin/service_template/DmDSSService (deflated 78%)
  adding: bin/service_template/DmMonitorService (deflated 78%)
  adding: bin/service_template/DmService (deflated 78%)
  adding: bin/service_template/DmWatcherService (deflated 78%)
  adding: bin/bin/ (stored 0%)
  adding: bin/bin/include/ (stored 0%)
  adding: bin/bin/proc/ (stored 0%)
  adding: bin/pids/ (stored 0%)
  adding: bin/pids/DmAPService.pid (stored 0%)
  adding: bin/dmamon (deflated 66%)
  adding: bin/dmimon (deflated 63%)
  adding: bin/dminit (deflated 62%)
  adding: bin/dmjmon (deflated 66%)
  adding: bin/dmserver (deflated 74%)
  adding: bin/svc_ctl_linux (deflated 65%)
[dmdba@localhost dmdbms]$ ll
总用量 82912
drwxr-xr-x.  8 dmdba dmdba     8192 10月 27 10:55 bin
drwxr-xr-x.  2 dmdba dmdba       30 9月  17 14:12 bin2
-rw-rw-r--.  1 dmdba dmdba 84860344 10月 27 11:29 bin.zip
drwxrwxr-x.  2 dmdba dmdba        6 10月 27 10:55 data
drwxr-xr-x.  3 dmdba dmdba       19 9月  17 14:12 desktop
drwxr-xr-x.  2 dmdba dmdba     4096 9月  17 14:12 doc
drwxr-xr-x. 10 dmdba dmdba      103 9月  17 14:12 drivers
drwxr-xr-x.  2 dmdba dmdba     4096 9月  17 14:12 include
drwxr-xr-x.  2 dmdba dmdba       94 9月  17 14:12 jar
drwxr-xr-x.  6 dmdba dmdba       54 9月  17 14:12 jdk
-rwxr-xr-x.  1 dmdba dmdba     1066 9月  17 14:12 license_en.txt
-rwxr-xr-x.  1 dmdba dmdba     1128 9月  17 14:12 license_zh.txt
drwxr-xr-x.  2 dmdba dmdba     4096 10月 27 10:55 log
drwxr-xr-x.  6 dmdba dmdba       92 9月  17 14:12 samples
drwxr-xr-x.  3 dmdba dmdba       37 9月  17 14:12 script
drwxr-xr-x.  9 dmdba dmdba     4096 10月 20 09:20 tool
drwxr-xr-x.  3 dmdba dmdba       97 9月  17 14:12 uninstall
-rwxr-xr-x.  1 dmdba dmdba     2433 9月  17 14:12 uninstall.sh
drwxr-xr-x.  2 dmdba dmdba       92 9月  17 14:12 web
[dmdba@localhost dmdbms]$ 

在这里插入图片描述

配置总览

在这里插入图片描述

执行部署

在这里插入图片描述

添加到监控

在这里插入图片描述

监控集群

在这里插入图片描述

  • 2
    点赞
  • 4
    收藏
    觉得还不错? 一键收藏
  • 1
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值