单机环境下达梦数据守护集群的搭建

注凡是没有提到切换root用户命令均在dmdba用户下执行集群规划配置项实例1主库实例2备库IP地址127.0.0.1127.0.0.1实例名GRP1_RT_01GRP1_RT_02实例端口52365237MAL端口53365337MAL_DW端口54365437INST_DW端口55365537OGUID4533145331守护组GRP1GRP1安装目录/opt/dmdbms/opt/dmdbms实例目录/opt/dmdbms/data/GRP1_RT_01//opt/dmdbms/data/GRP1_RT_02/切换模式故障手动切换dmwatcher中DW_MODEMANUALdmmonitor中MON_DW_CONFIRM0故障自动切换dmwatcher中DW_MODEAUTOdmmonitor中MON_DW_CONFIRM1集群搭建配置主库初始化实例并备份数据创建实例目录mkdir-p/opt/dmdbms/data/GRP1_RT_01mkdir-p/opt/dmdbms/data/GRP1_RT_01/archmkdir-p/opt/dmdbms/data/GRP1_RT_01/bak初始化实例/opt/dmdbms/bin/dminitPATH/opt/dmdbms/data/GRP1_RT_01\INSTANCE_NAMEGRP1_RT_01\PORT_NUM5236\PAGE_SIZE32\EXTENT_SIZE32\LOG_SIZE2048\SYSDBA_PWD******\SYSAUDITOR_PWD******启动实例/opt/dmdbms/bin/dmserver /opt/dmdbms/data/GRP1_RT_01/DAMENG/dm.ini连接并执行disql/opt/dmdbms/bin/disql SYSDBA/******127.0.0.1:5236 ALTER DATABASE MOUNT;ALTER DATABASE ARCHIVELOG;ALTER DATABASE ADD ARCHIVELOGDEST/opt/dmdbms/data/GRP1_RT_01/arch, TYPELOCAL, FILE_SIZE2048, SPACE_LIMIT102400;ALTER DATABASE OPEN;BACKUP DATABASE BACKUPSET/opt/dmdbms/data/GRP1_RT_01/bak/BACKUP_FILE;SP_SET_PARA_VALUE(2,PORT_NUM,5236);SP_SET_PARA_VALUE(2,DW_INACTIVE_INTERVAL,60);SP_SET_PARA_VALUE(2,ALTER_MODE_STATUS,0);SP_SET_PARA_VALUE(2,ENABLE_OFFLINE_TS,2);SP_SET_PARA_VALUE(2,MAL_INI,1);SP_SET_PARA_VALUE(2,ARCH_INI,1);SP_SET_PARA_VALUE(2,RLOG_SEND_APPLY_MON,64);EXIT;关闭实例修改dmarch.ini、dmmal.ini、dmwatcher.inivi/opt/dmdbms/data/GRP1_RT_01/DAMENG/dmarch.ini ARCH_WAIT_APPLY0#0高性能 1事务一致[ARCHIVE_LOCAL]ARCH_TYPELOCAL#本地归档类型ARCH_DEST/opt/dmdbms/data/GRP1_RT_01/DAMENG/arch/#本地归档存放路径ARCH_FILE_SIZE2048#单个归档大小单位 MBARCH_SPACE_LIMIT102400#归档上限单位 MB[ARCHIVE_REALTIME1]ARCH_TYPEREALTIME#实时归档类型ARCH_DESTGRP1_RT_02#实时归档目标实例名vi/opt/dmdbms/data/GRP1_RT_01/DAMENG/dmmal.ini MAL_CHECK_INTERVAL30#MAL 链路检测时间间隔MAL_CONN_FAIL_INTERVAL30#判定 MAL 链路断开的时间MAL_TEMP_PATH/opt/dmdbms/data/malpath/#临时文件目录MAL_BUF_SIZE512#单个 MAL 缓存大小单位 MBMAL_SYS_BUF_SIZE2048#MAL 总大小限制单位 MBMAL_COMPRESS_LEVEL0#MAL 消息压缩等级0 表示不压缩[MAL_INST1]MAL_INST_NAMEGRP1_RT_01#实例名和 dm.ini 的 INSTANCE_NAME 一致MAL_HOST127.0.0.1#MAL 系统监听 TCP 连接的 IP 地址MAL_PORT5336#MAL 系统监听 TCP 连接的端口MAL_INST_HOST127.0.0.1#实例的对外服务 IP 地址MAL_INST_PORT5236#实例对外服务端口和 dm.ini 的 PORT_NUM 一致MAL_DW_PORT5436#实例对应的守护进程监听 TCP 连接的端口MAL_INST_DW_PORT5536#实例监听守护进程 TCP 连接的端口[MAL_INST2]MAL_INST_NAMEGRP1_RT_02 MAL_HOST127.0.0.1 MAL_PORT5336MAL_INST_HOST127.0.0.1 MAL_INST_PORT5236MAL_DW_PORT5436MAL_INST_DW_PORT5536vi/opt/dmdbms/data/GRP1_RT_01/DAMENG/dmwatcher.ini[GRP1]DW_TYPEGLOBAL#全局守护类型DW_MODEAUTO#MANUAL故障手切 AUTO故障自切DW_ERROR_TIME30#远程守护进程故障认定时间INST_ERROR_TIME30#本地实例故障认定时间INST_RECOVER_TIME60#主库守护进程启动恢复的间隔时间INST_OGUID45331#守护系统唯一 OGUID 值INST_INI/opt/dmdbms/data/GRP1_RT_01/DAMENG/dm.ini#dm.ini 文件路径INST_AUTO_RESTART1#打开实例的自动启动功能INST_STARTUP_CMD/opt/dmdbms/bin/dmserver#命令行方式启动RLOG_SEND_THRESHOLD0#指定主库发送日志到备库的时间阈值默认关闭RLOG_APPLY_THRESHOLD0#指定备库重演日志的时间阈值默认关闭DW_FAILOVER_FORCE0#监视器未启动,是否强制将主库OPEN拷贝备份文件cp-r/opt/dmdbms/data/GRP1_RT_01/bak/BACKUP_FILE /opt/dmdbms/data/GRP1_RT_02/bak/注册服务切换到root用户执行命令/opt/dmdbms/script/root/dm_service_installer.sh-tdmserver-pGRP1_RT_01-dm_ini/opt/dmdbms/data/GRP1_RT_01/DAMENG/dm.ini-mmount/opt/dmdbms/script/root/dm_service_installer.sh-tdmwatcher-pWatcher-watcher_ini/opt/dmdbms/data/GRP1_RT_01/DAMENG/dmwatcher.ini配置备库初始化实例创建实例目录mkdir-p/opt/dmdbms/data/GRP1_RT_02mkdir-p/opt/dmdbms/data/GRP1_RT_02/archmkdir-p/opt/dmdbms/data/GRP1_RT_02/bak初始化实例/opt/dmdbms/bin/dminitPATH/opt/dmdbms/data/GRP1_RT_02\INSTANCE_NAMEGRP1_RT_02\PORT_NUM5237\PAGE_SIZE32\EXTENT_SIZE32\LOG_SIZE2048\SYSDBA_PWD******\SYSAUDITOR_PWD******恢复数据/opt/dmdbms/bin/dmrmanCTLSTMTRESTORE DATABASE /opt/dmdbms/data/GRP1_RT_02/DAMENG/dm.ini FROM BACKUPSET /opt/dmdbms/data/DAMENG/bak/BACKUP_FILE/opt/dmdbms/bin/dmrmanCTLSTMTRECOVER DATABASE /opt/dmdbms/data/GRP1_RT_02/DAMENG/dm.ini FROM BACKUPSET /opt/dmdbms/data/DAMENG/bak/BACKUP_FILE/opt/dmdbms/bin/dmrmanCTLSTMTRECOVER DATABASE /opt/dmdbms/data/GRP1_RT_02/DAMENG/dm.ini UPDATE DB_MAGIC修改dmarch.ini、dmmal.ini、dmwatcher.ini、dm.inivi/opt/dmdbms/data/DAMENG/dmarch.ini ARCH_WAIT_APPLY0#0高性能 1事务一致[ARCHIVE_LOCAL]ARCH_TYPELOCAL#本地归档类型ARCH_DEST/opt/dmdbms/data/GRP1_RT_02/DAMENG/arch/#本地归档存放路径ARCH_FILE_SIZE2048#单个归档大小单位 MBARCH_SPACE_LIMIT102400#归档上限单位 MB[ARCHIVE_REALTIME1]ARCH_TYPEREALTIME#实时归档类型ARCH_DESTGRP1_RT_01#实时归档目标实例名复制dmmal.inicp/opt/dmdbms/data/GRP1_RT_01/DAMENG/dmmal.ini /opt/dmdbms/data/GRP1_RT_02/DAMENG/复制dmwatcher.ini并修改INST_INIcp/opt/dmdbms/data/GRP1_RT_01/DAMENG/dmwatcher.ini /opt/dmdbms/data/GRP1_RT_02/DAMENG/INSTANCE_NAMEGRP1_RT_02 PORT_NUM5237#数据库实例监听端口DW_INACTIVE_INTERVAL60#接收守护进程消息超时时间ALTER_MODE_STATUS0#不允许手工方式修改实例模式/状态/OGUIDENABLE_OFFLINE_TS2#不允许备库 OFFLINE 表空间MAL_INI1#打开 MAL 系统ARCH_INI1#打开归档配置RLOG_SEND_APPLY_MON64#统计最近 64 次的日志重演信息注册服务切换到root用户执行命令/opt/dmdbms/script/root/dm_service_installer.sh-tdmserver-pGRP1_RT_02-dm_ini/opt/dmdbms/data/GRP1_RT_02/DAMENG/dm.ini-mmount/opt/dmdbms/script/root/dm_service_installer.sh-tdmwatcher-pWatcher-watcher_ini/opt/dmdbms/data/GRP1_RT_02/DAMENG/dmwatcher.ini启动服务启动数据库修改参数/opt/dmdbms/bin/DmServiceGRP1_RT_01 start /opt/dmdbms/bin/disql SYSDBA/*****127.0.0.1:5236 SQLSP_SET_PARA_VALUE(1,ALTER_MODE_STATUS,1);SQLSP_SET_OGUID(45331);SQLALTER DATABASE PRIMARY;SQLSP_SET_PARA_VALUE(1,ALTER_MODE_STATUS,0);/opt/dmdbms/bin/DmServiceGRP1_RT_02 start /opt/dmdbms/bin/disql SYSDBA/*****127.0.0.1:5237 SQLSP_SET_PARA_VALUE(1,ALTER_MODE_STATUS,1);SQLSP_SET_OGUID(45331);SQLALTER DATABASE STANDBY;SQLSP_SET_PARA_VALUE(1,ALTER_MODE_STATUS,0);启动守护进程/opt/dmdbms/bin/DmWatcherServiceWatcher01 start /opt/dmdbms/bin/DmWatcherServiceWatcher02 start启停集群##启动/opt/dmdbms/bin/DmServiceGRP1_RT_01 start /opt/dmdbms/bin/DmServiceGRP1_RT_02 start /opt/dmdbms/bin/DmWatcherServiceWatcher01 start /opt/dmdbms/bin/DmWatcherServiceWatcher02 start##停止/opt/dmdbms/bin/DmWatcherServiceWatcher01 stop /opt/dmdbms/bin/DmWatcherServiceWatcher02 stop /opt/dmdbms/bin/DmServiceGRP1_RT_01 stop /opt/dmdbms/bin/DmServiceGRP1_RT_02 stop配置监视器创建dmmonitor.inivi/opt/dmdbms/bin/dmmonitor.ini MON_DW_CONFIRM1#0非确认故障手切 1确认故障自切MON_LOG_PATH/opt/dmdbms/log#监视器日志文件存放路径MON_LOG_INTERVAL60#每隔 60s 定时记录系统信息到日志文件MON_LOG_FILE_SIZE512#单个日志大小单位 MBMON_LOG_SPACE_LIMIT2048#日志上限单位 MB[GRP1]MON_INST_OGUID45331#组 GRP1 的唯一 OGUID 值MON_DW_IP127.0.0.1:5436#IP 对应 MAL_HOSTPORT 对应 MAL_DW_PORTMON_DW_IP127.0.0.1:5437mkdir-p/opt/dmdbms/log切换root注册服务/opt/dmdbms/script/root/dm_service_installer.sh-tdmmonitor\-pMonitor\-monitor_ini/opt/dmdbms/bin/dmmonitor.ini启动监视器#后台启动/opt/dmdbms/bin/DmMonitorServiceMonitor start##前台启动/opt/dmdbms/bin/dmmonitor /opt/dmdbms/bin/dmmonitor.ini前台启动后可通过tip命令查看集群状态声明本文为个人学习实验记录部署流程参考达梦 DM8 官方数据守护手册文中所有操作仅用于学习测试单机部署主备集群不适用生产环境。达梦社区地址https://eco.dameng.com