集群部署RWC集群Linux两节点手切"/>
DM8集群部署RWC集群Linux两节点手切
最近在学习DM数据库集群,今天将RWC集群部署过程记录一下。
环境准备:两台虚拟机,DM8安装包(可以在官网下载)
禁用防火墙(两台机器都禁用)
[test@localhost ~]$ systemctl stop firewalld
[test@localhost ~]$ systemctl disable firewalld
Removed symlink /etc/systemd/system/multi-user.target.wants/firewalld.service.
Removed symlink /etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.
配置两台虚拟机A和B的网卡,使其能相互ping通
在A、B上分别安装数据库
创建安装用户及用户组
[root@localhost ~]# groupadd dinstall
[root@localhost ~]# useradd -g dinstall -m -d /home/dmdba -s /bin/bash dmdba
[root@localhost ~]# passwd dmdba
更改用户 dmdba 的密码 。
新的 密码:
无效的密码: 密码少于 8 个字符
重新输入新的 密码:
passwd:所有的身份验证令牌已经成功更新。
修改文件最大数
[root@localhost ~]# vi /etc/security/limits.conf(最后加入下面四句话)
dmdba hard nofile 65536
dmdba soft nofile 65536
dmdba hard stack 32768
dmdba soft stack 16384
切换到dmdba用户,查看是否生效
[root@localhost ~]# su - dmdba
[dmdba@localhost ~]$ ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 3755
max locked memory (kbytes, -l) 64
max memory size (kbytes, -m) unlimited
open files (-n) 65536
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority (-r) 0
stack size (kbytes, -s) 16384
cpu time (seconds, -t) unlimited
max user processes (-u) 3755
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
可使用 dmdba 用户执行如下命令,使设置临时生效
[dmdba@localhost ~]$ ulimit -n 65536
挂载DM数据库的ios安装包
[root@localhost ~]# mount -o loop /dev/cdrom /mnt/
新建安装目录,修改权限
[root@localhost ~]# mkdir /opt/dmdbms
[root@localhost ~]# chown dmdba:dinstall -R /opt/dmdbms/
[root@localhost ~]# chmod -R 755 /opt/dmdbms/
Dmdba用户使用命令行安装DM8
[root@localhost ~]# su - dmdba
上一次登录:四 8月 12 16:39:33 CST 2021pts/0 上
[dmdba@localhost ~]$ cd /mnt/
[dmdba@localhost mnt]$ ls
DM8 Install.pdf DMInstall.bin
[dmdba@localhost mnt]$ ./DMInstall.bin -i
请选择安装语言(C/c:中文 E/e:英文) [C/c]:c安装前小结
安装位置: /opt/dmdbms
所需空间: 1075M
可用空间: 31G
版本信息:
有效日期:
安装类型: 典型安装
使用root用户执行命令
root@localhost ~]# /opt/dmdbms/script/root/root_installer.sh
移动 /opt/dmdbms/bin/dm_svc.conf 到/etc目录
修改服务器权限
创建DmAPService服务
Created symlink from /etc/systemd/system/multi-user.target.wants/DmAPService.service to /usr/lib/systemd/system/DmAPService.service.
创建服务(DmAPService)完成
启动DmAPService服务
配置环境变量
export PATH=$PATH:$DM_HOME/bin:$DM_HOME/tool
[root@localhost ~]# cd /home/dmdba/
[root@localhost dmdba]# vim .bash_profile
切换到dmdba用户,使用以下命令使其生效
[root@localhost dmdba]# su - dmdba
上一次登录:四 8月 12 16:42:02 CST 2021pts/0 上
[dmdba@localhost ~]$ source .bash_profile
配置A机器
初始化实例、备份数据
[dmdba@localhost ~]$ /opt/dmdbms/bin/dminit PATH=/opt/dmdbms/data/ INSTANCE_NAME=RWC1_01 PAGE_SIZE=32 LOG_SIZE=2048
initdb V8
db version: 0x7000b
file dm.key not found, use default license!
License will expire on 2021-09-04log file path: /opt/dmdbms/data/DAMENG/DAMENG01.loglog file path: /opt/dmdbms/data/DAMENG/DAMENG02.logwrite to dir [/opt/dmdbms/data/DAMENG].
create dm database success. 2021-08-12 17:00:30
启动服务
dmdba@localhost ~]$ /opt/dmdbms/bin/dmserver /opt/dmdbms/data/DAMENG/dm.ini
file dm.key not found, use default license!
version info: develop
Use normal os_malloc instead of HugeTLB
Use normal os_malloc instead of HugeTLB
DM Database Server x64 V8 1-1-126-20.09.04-126608-ENT startup...
Database mode = 0, oguid = 0
License will expire on 2021-09-04
file lsn: 0
ndct db load finished
ndct fill fast pool finished
iid page's trxid[1002]
NEXT TRX ID = 1003
pseg_collect_mgr_items, total collect 0 active_trxs, 0 cmt_trxs, 0 pre_cmt_trxs, 0 active_pages, 0 cmt_pages, 0 pre_cmt_pages, 0 mgr pages, 0 mgr recs!
total 0 active crash trx, pseg_crash_trx_rollback sys_only(0) begin ...
pseg_crash_trx_rollback end, total 0 active crash trx, include 0 empty_trxs, 0 empty_pages which only need to delete mgr recs.
pseg_crash_trx_rollback end
pseg recv finished
nsvr_startup end.
aud sys init success.
aud rt sys init success.
trx: 2004 purged 1 pages
trx: 2023 purged 1 pages
trx: 2024 purged 1 pages
trx: 2025 purged 1 pages
trx: 2026 purged 1 pages
trx: 2036 purged 1 pages
trx: 2156 purged 1 pages
trx: 2169 purged 1 pages
trx: 2170 purged 1 pages
trx: 2171 purged 1 pages
trx: 2172 purged 1 pages
trx: 2173 purged 1 pages
trx: 2175 purged 1 pages
trx: 2176 purged 1 pages
trx: 2178 purged 1 pages
trx: 2180 purged 1 pages
trx: 2186 purged 1 pages
trx: 2192 purged 1 pages
trx: 2202 purged 1 pages
trx: 2210 purged 10 pages
trx: 2217 purged 1 pages
trx: 2218 purged 1 pages
trx: 2219 purged 1 pages
trx: 2220 purged 1 pages
trx: 2232 purged 1 pages
trx: 2234 purged 1 pages
trx: 2235 purged 1 pages
trx: 2236 purged 1 pages
trx: 2241 purged 6 pages
trx: 2268 purged 1 pages
trx: 2269 purged 1 pages
trx: 2270 purged 1 pages
trx: 2271 purged 1 pages
trx: 2277 purged 1 pages
trx: 2279 purged 1 pages
trx: 2281 purged 1 pages
trx: 2286 purged 1 pages
trx: 2291 purged 1 pages
trx: 2296 purged 1 pages
trx: 2298 purged 1 pages
trx: 2301 purged 1 pages
trx: 2303 purged 1 pages
trx: 2315 purged 1 pages
trx: 2317 purged 1 pages
trx: 2319 purged 1 pages
trx: 2324 purged 1 pages
trx: 2327 purged 1 pages
trx: 2330 purged 1 pages
trx: 2333 purged 1 pages
trx: 2335 purged 1 pages
trx: 2336 purged 1 pages
trx: 2485 purged 1 pages
trx: 2490 purged 1 pages
trx: 2497 purged 2 pages
trx: 2526 purged 1 pages
systables desc init success.
ndct_db_load_info success.
nsvr_process_before_open begin.
nsvr_process_before_open success.
total 0 active crash trx, pseg_crash_trx_rollback sys_only(0) begin ...
pseg_crash_trx_rollback end, total 0 active crash trx, include 0 empty_trxs, 0 empty_pages which only need to delete mgr recs.
pseg_crash_trx_rollback end
SYSTEM IS READY.
开启归档、备份数据、修改dm.ini
[dmdba@localhost ~]$ /opt/dmdbms/bin/disql SYSDBA/SYSDBA@192.168.28.61:5236服务器[192.168.28.61:5236]:处于普通打开状态
登录使用时间 : 27.211(ms)
disql V8
SQL> ALTER DATABASE MOUNT;
操作已执行
已用时间: 00:00:01.773. 执行号:0.
SQL> ALTER DATABASE ARCHIVELOG;
操作已执行
已用时间: 7.886(毫秒). 执行号:0.
SQL> ALTER DATABASE ADD ARCHIVELOG 'DEST=/opt/dmdbms/data/DAMENG/arch, TYPE=LOCAL, FILE_SIZE=1024, SPACE_LIMIT=51200';
操作已执行
已用时间: 7.545(毫秒). 执行号:0.
SQL> ALTER DATABASE OPEN;
操作已执行
已用时间: 00:00:01.785. 执行号:0.
SQL> BACKUP DATABASE BACKUPSET '/opt/dmdbms/data/DAMENG/bak/BACKUP_FILE';
操作已执行
已用时间: 00:00:01.678. 执行号:104.
SQL> SP_SET_PARA_VALUE (2,'PORT_NUM',5236);
DMSQL 过程已成功完成
已用时间: 18.787(毫秒). 执行号:105.
SQL> SP_SET_PARA_VALUE (2,'DW_INACTIVE_INTERVAL',60);
DMSQL 过程已成功完成
已用时间: 3.253(毫秒). 执行号:106.
SQL> SP_SET_PARA_VALUE (2,'ALTER_MODE_STATUS',0);
DMSQL 过程已成功完成
已用时间: 3.011(毫秒). 执行号:107.
SQL> SP_SET_PARA_VALUE (2,'ENABLE_OFFLINE_TS',2);
DMSQL 过程已成功完成
已用时间: 3.074(毫秒). 执行号:108.
SQL> SP_SET_PARA_VALUE (2,'MAL_INI',1);
DMSQL 过程已成功完成
已用时间: 2.975(毫秒). 执行号:109.
SQL> SP_SET_PARA_VALUE (2,'RLOG_SEND_APPLY_MON',64);
DMSQL 过程已成功完成
已用时间: 2.941(毫秒). 执行号:110.
关闭前台服务
替换dmarch.ini
[dmdba@localhost ~]$ vi /opt/dmdbms/data/DAMENG/dmarch.ini
[dmdba@localhost ~]$ cat /opt/dmdbms/data/DAMENG/dmarch.ini
#DaMeng Database Archive Configuration file
#this is comments
[ARCHIVE_LOCAL]ARCH_TYPE = LOCAL #本地归档类型ARCH_DEST = /opt/dmdbms/data/DAMENG/arch/ #本地归档存放路径ARCH_FILE_SIZE = 1024 #单个归档大小,单位MBARCH_SPACE_LIMIT = 51200 #归档上限,单位MB
[ARCHIVE_TIMELY1]ARCH_TYPE = TIMELY #即时归档类型ARCH_DEST = RWC1_01B #即时归档目标实例名
创建dmmal.ini
[dmdba@localhost ~]$ vi /opt/dmdbms/data/DAMENG/dmmal.ini
[dmdba@localhost ~]$ cat /opt/dmdbms/data/DAMENG/dmmal.ini
MAL_CHECK_INTERVAL = 10 #MAL链路检测时间间隔
MAL_CONN_FAIL_INTERVAL = 10 #判定MAL链路断开的时间
MAL_TEMP_PATH = /opt/dmdbms/data/malpath/ #临时文件目录
MAL_BUF_SIZE = 512 #单个MAL缓存大小,单位MB
MAL_SYS_BUF_SIZE = 2048 #MAL总大小限制,单位MB
MAL_COMPRESS_LEVEL = 0 #MAL消息压缩等级,0表示不压缩[MAL_INST1]MAL_INST_NAME = RWC1_01 #实例名,和 dm.ini的INSTANCE_NAME一致MAL_HOST = 192.168.28.61 #MAL系统监听TCP连接的IP地址MAL_PORT = 5336 #MAL系统监听TCP连接的端口MAL_INST_HOST = 192.168.28.61 #实例的对外服务IP地址MAL_INST_PORT = 5236 #实例对外服务端口,和dm.ini的PORT_NUM一致MAL_DW_PORT = 5436 #实例对应的守护进程监听TCP连接的端口MAL_INST_DW_PORT = 5536 #实例监听守护进程TCP连接的端口
[MAL_INST2]MAL_INST_NAME = RWC1_01BMAL_HOST = 192.168.28.62MAL_PORT = 5336MAL_INST_HOST = 192.168.28.62MAL_INST_PORT = 5236MAL_DW_PORT = 5436MAL_INST_DW_PORT = 5536
创建dmwatcher.ini
[dmdba@localhost ~]$ vi /opt/dmdbms/data/DAMENG/dmwatcher.ini
[dmdba@localhost ~]$ cat /opt/dmdbms/data/DAMENG/dmwatcher.ini
[GRWC1]DW_TYPE = GLOBAL #全局守护类型DW_MODE = MANUAL #故障手动切换模式DW_ERROR_TIME = 20 #远程守护进程故障认定时间INST_ERROR_TIME = 20 #本地实例故障认定时间INST_RECOVER_TIME = 60 #主库守护进程启动恢复的间隔时间INST_OGUID = 45331 #守护系统唯一OGUID值INST_INI = /opt/dmdbms/data/DAMENG/dm.ini #dm.ini文件路径INST_AUTO_RESTART = 1 #打开实例的自动启动功能INST_STARTUP_CMD = /opt/dmdbms/bin/dmserver #命令行方式启动RLOG_SEND_THRESHOLD = 0 #指定主库发送日志到备库的时间阈值,默认关闭RLOG_APPLY_THRESHOLD = 0 #指定备库重演日志的时间阈值,默认关闭
拷贝实例到B机器
[dmdba@localhost ~]$ scp -r /opt/dmdbms/data/DAMENG dmdba@192.168.28.62:/opt/dmdbms/data/
The authenticity of host '192.168.28.62 (192.168.28.62)' can't be established.
ECDSA key fingerprint is SHA256:JuvfudnNwSPm6+C+s+aqzMVZjkS6HW/fV3HtQobMSAM.
ECDSA key fingerprint is MD5:5d:45:c4:27:3e:ce:4d:e1:d4:ce:73:58:d3:db:95:b1.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added '192.168.28.62' (ECDSA) to the list of known hosts.
dmdba@192.168.28.62's password:
BACKUP_FILE.bak 100% 16MB 68.4MB/s 00:00
BACKUP_FILE_1.bak 100% 182KB 21.2MB/s 00:00
BACKUP_FILE.meta 100% 81KB 32.4MB/s 00:00
dminit20210812170027.log 100% 890 988.2KB/s 00:00
dm.ini 100% 49KB 26.1MB/s 00:00
sqllog.ini 100% 479 480.8KB/s 00:00
dm.ctl 100% 5120 5.8MB/s 00:00
DAMENG01.log 100% 2048MB 104.7MB/s 00:19
DAMENG02.log 100% 2048MB 105.8MB/s 00:19
dm_20210812170030_215479.ctl 100% 5120 1.1MB/s 00:00
dm_20210812170141_282206.ctl 100% 5120 1.9MB/s 00:00
dm_20210812171049_151741.ctl 100% 5120 1.6MB/s 00:00
SYSTEM.DBF 100% 80MB 94.4MB/s 00:00
dm_service.prikey 100% 633 156.8KB/s 00:00
MAIN.DBF 100% 128MB 101.7MB/s 00:01
ROLL.DBF 100% 128MB 96.0MB/s 00:01
TEMP.DBF 100% 42MB 104.4MB/s 00:00
rep_conflict.log 100% 12 3.7KB/s 00:00
ARCHIVE_LOCAL1_0x3F69079C[0]_2021-08-12_17-03 100% 260KB 15.3MB/s 00:00
ARCHIVE_LOCAL1_0x3F69079C[0]_2021-08-12_17-10 100% 183KB 45.2MB/s 00:00
dmarch.ini 100% 491 730.0KB/s 00:00
dmmal.ini 100% 1264 1.8MB/s 00:00
dmwatcher.ini 100% 820 1.2MB/s 00:00
注册服务
[root@localhost ~]# /opt/dmdbms/script/root/dm_service_installer.sh -t dmserver -p RWC1_01 -dm_ini /opt/dmdbms/data/DAMENG/dm.ini -m mount
Created symlink from /etc/systemd/system/multi-user.target.wants/DmServiceRWC1_01.service to /usr/lib/systemd/system/DmServiceRWC1_01.service.
创建服务(DmServiceRWC1_01)完成
[root@localhost ~]# /opt/dmdbms/script/root/dm_service_installer.sh -t dmwatcher -p Watcher -watcher_ini /opt/dmdbms/data/DAMENG/dmwatcher.ini
Created symlink from /etc/systemd/system/multi-user.target.wants/DmWatcherServiceWatcher.service to /usr/lib/systemd/system/DmWatcherServiceWatcher.service.
创建服务(DmWatcherServiceWatcher)完成
配置B机器
修改dm.ini
[dmdba@localhost data]$ vi /opt/dmdbms/data/DAMENG/dm.ini
替换dmarch.ini
[dmdba@localhost data]$ vi /opt/dmdbms/data/DAMENG/dmarch.ini
[dmdba@localhost data]$ cat /opt/dmdbms/data/DAMENG/dmarch.ini
#DaMeng Database Archive Configuration file
#this is comments
[ARCHIVE_LOCAL]ARCH_TYPE = LOCAL #本地归档类型ARCH_DEST = /opt/dmdbms/data/DAMENG/arch/ #本地归档存放路径ARCH_FILE_SIZE = 1024 #单个归档大小,单位MBARCH_SPACE_LIMIT = 51200 #归档上限,单位MB
[ARCHIVE_TIMELY1]ARCH_TYPE = TIMELY #即时归档类型ARCH_DEST = RWC1_01 #即时归档目标实例名
与A机器RWC1_01的dmmal.ini、dawatcher.ini相同
注册服务
[root@localhost ~]# /opt/dmdbms/script/root/dm_service_installer.sh -t dmserver -p RWC1_01B -dm_ini /opt/dmdbms/data/DAMENG/dm.ini -m mount
Created symlink from /etc/systemd/system/multi-user.target.wants/DmServiceRWC1_01B.service to /usr/lib/systemd/system/DmServiceRWC1_01B.service.
创建服务(DmServiceRWC1_01B)完成
[root@localhost ~]# /opt/dmdbms/script/root/dm_service_installer.sh -t dmwatcher -p Watcher -watcher_ini /opt/dmdbms/data/DAMENG/dmwatcher.ini
Created symlink from /etc/systemd/system/multi-user.target.wants/DmWatcherServiceWatcher.service to /usr/lib/systemd/system/DmWatcherServiceWatcher.service.
创建服务(DmWatcherServiceWatcher)完成
恢复数据
[dmdba@localhost ~]$ /opt/dmdbms/bin/dmrman CTLSTMT="RESTORE DATABASE '/opt/dmdbms/data/DAMENG/dm.ini' FROM BACKUPSET '/opt/dmdbms/data/DAMENG/bak/BACKUP_FILE'"
dmrman V8
RESTORE DATABASE '/opt/dmdbms/data/DAMENG/dm.ini' FROM BACKUPSET '/opt/dmdbms/data/DAMENG/bak/BACKUP_FILE'
file dm.key not found, use default license!
RESTORE DATABASE CHECK......
RESTORE DATABASE,data collect......
RESTORE DATABASE,database refresh ......
RESTORE BACKUPSET [/opt/dmdbms/data/DAMENG/bak/BACKUP_FILE] START......
total 4 packages processed...
total 5 packages processed...
RESTORE DATABASE,UPDATE ctl file......
RESTORE DATABASE,REBUILD key file......
RESTORE DATABASE,CHECK db info......
RESTORE DATABASE,UPDATE db info......
total 5 packages processed...
total 5 packages processed!
CMD END.CODE:[0]
restore successfully.
time used: 495.034(ms)
[dmdba@localhost ~]$ /opt/dmdbms/bin/dmrman CTLSTMT="RECOVER DATABASE '/opt/dmdbms/data/DAMENG/dm.ini' FROM BACKUPSET '/opt/dmdbms/data/DAMENG/bak/BACKUP_FILE'"
dmrman V8
RECOVER DATABASE '/opt/dmdbms/data/DAMENG/dm.ini' FROM BACKUPSET '/opt/dmdbms/data/DAMENG/bak/BACKUP_FILE'
file dm.key not found, use default license!
Database mode = 0, oguid = 0
EP[0]'s cur_lsn[38459]
RESTORE RLOG CHECK......
RESTORE RLOG, gen tmp file......
RESTORE RLOG FROM BACKUPSET [/opt/dmdbms/data/DAMENG/bak/BACKUP_FILE] START......
total 3 packages processed...
total 3 packages processed...
total 3 packages processed!
CMD END.CODE:[0]
EP:0 total 1 pkgs applied, percent: 11%
EP:0 total 2 pkgs applied, percent: 22%
EP:0 total 3 pkgs applied, percent: 33%
EP:0 total 4 pkgs applied, percent: 44%
EP:0 total 5 pkgs applied, percent: 55%
EP:0 total 6 pkgs applied, percent: 66%
EP:0 total 7 pkgs applied, percent: 77%
EP:0 total 8 pkgs applied, percent: 88%
EP:0 total 9 pkgs applied, percent: 100%
Recover from archive log finished, time used:0.184s.
recover successfully!
time used: 452.290(ms)
[dmdba@localhost ~]$ /opt/dmdbms/bin/dmrman CTLSTMT="RECOVER DATABASE '/opt/dmdbms/data/DAMENG/dm.ini' UPDATE DB_MAGIC"
dmrman V8
RECOVER DATABASE '/opt/dmdbms/data/DAMENG/dm.ini' UPDATE DB_MAGIC
file dm.key not found, use default license!
Database mode = 0, oguid = 0
EP[0]'s cur_lsn[39731]
EP[0]'s apply_lsn[39731] >= end_lsn[39731]
recover successfully!
time used: 979.000(ms)
配置监视器
在各个节点数据库的bin目录中存放非确认监视器配置文件。
[dmdba@localhost bin]$ vi /opt/dmdbms/bin/dmmonitor.ini
[dmdba@localhost bin]$ cat /opt/dmdbms/bin/dmmonitor.ini
MON_DW_CONFIRM = 0 #0为非确认,1为确认
MON_LOG_PATH = /opt/dmdbms/log #监视器日志文件存放路径
MON_LOG_INTERVAL = 60 #每隔 60s 定时记录系统信息到日志文件
MON_LOG_FILE_SIZE = 512 #单个日志大小,单位MB
MON_LOG_SPACE_LIMIT = 2048 #日志上限,单位MB[GRWC1]MON_INST_OGUID = 45331 #组GRWC1的唯一OGUID 值MON_DW_IP = 192.168.28.61:5436 #IP对应MAL_HOST,PORT对应MAL_DW_PORTMON_DW_IP = 192.168.28.62:5436
注册服务
[root@localhost ~]# /opt/dmdbms/script/root/dm_service_installer.sh -t dmmonitor -p Monitor -monitor_ini /opt/dmdbms/bin/dmmonitor.ini
Created symlink from /etc/systemd/system/multi-user.target.wants/DmMonitorServiceMonitor.service to /usr/lib/systemd/system/DmMonitorServiceMonitor.service.
创建服务(DmMonitorServiceMonitor)完成
启动数据并修改参数
A机器
[dmdba@localhost ~]$ /opt/dmdbms/bin/DmServiceRWC1_01 start
Starting DmServiceRWC1_01: [ OK ]
[dmdba@localhost ~]$ /opt/dmdbms/bin/disql SYSDBA/SYSDBA@192.168.28.61:5236服务器[192.168.28.61:5236]:处于普通配置状态
登录使用时间 : 28.294(ms)
disql V8
SQL> SP_SET_OGUID(45331);
DMSQL 过程已成功完成
已用时间: 78.018(毫秒). 执行号:0.
SQL> ALTER DATABASE PRIMARY;
操作已执行
已用时间: 5.016(毫秒). 执行号:0.
B机器
[dmdba@localhost ~]$ /opt/dmdbms/bin/disql SYSDBA/SYSDBA@192.168.28.62:5236服务器[192.168.28.62:5236]:处于普通配置状态
登录使用时间 : 52.254(ms)
disql V8
SQL> SP_SET_OGUID(45331);
DMSQL 过程已成功完成
已用时间: 77.343(毫秒). 执行号:0.
SQL> ALTER DATABASE STANDBY;
操作已执行
已用时间: 70.005(毫秒). 执行号:0.
A/B机器启动守护进程
[dmdba@localhost ~]$ /opt/dmdbms/bin/DmWatcherServiceWatcher start
Starting DmWatcherServiceWatcher: [ OK ]
启动监视器
mdba@localhost bin]$ ./dmmonitor /opt/dmdbms/bin/dmmonitor.ini
[monitor] 2021-08-12 18:14:12: DMMONITOR[4.0] V8
[monitor] 2021-08-12 18:14:12: DMMONITOR[4.0] IS READY.[monitor] 2021-08-12 18:14:12: 收到守护进程(RWC1_01)消息WTIME WSTATUS INST_OK INAME ISTATUS IMODE RSTAT N_OPEN FLSN CLSN 2021-08-12 18:14:12 OPEN OK RWC1_01 OPEN PRIMARY VALID 6 44204 44204 [monitor] 2021-08-12 18:14:12: 收到守护进程(RWC1_01B)消息WTIME WSTATUS INST_OK INAME ISTATUS IMODE RSTAT N_OPEN FLSN CLSN 2021-08-12 18:14:12 OPEN OK RWC1_01B OPEN STANDBY VALID 6 44204 44204 tip
[monitor] 2021-08-12 18:14:15: [!!! 提示:本监视器不是确认监视器,在故障自动切换模式下如果发生主库故障,本监视器无法执行自动接管 !!!][monitor] 2021-08-12 18:14:15: 实例RWC1_01[PRIMARY, OPEN, ISTAT_SAME:TRUE]不可加入其他实例,守护进程状态:OPEN,Open记录状态:VALID
[monitor] 2021-08-12 18:14:15: 实例RWC1_01[PRIMARY, OPEN, ISTAT_SAME:TRUE]当前没有命令正在执行
[monitor] 2021-08-12 18:14:15: 实例RWC1_01[PRIMARY, OPEN, ISTAT_SAME:TRUE]运行正常, 守护进程是OPEN状态,守护类型是GLOBAL[monitor] 2021-08-12 18:14:15: 实例RWC1_01B[STANDBY, OPEN, ISTAT_SAME:TRUE]可加入实例RWC1_01[PRIMARY, OPEN, ISTAT_SAME:TRUE]
[monitor] 2021-08-12 18:14:15: 实例RWC1_01B[STANDBY, OPEN, ISTAT_SAME:TRUE]当前没有命令正在执行
[monitor] 2021-08-12 18:14:15: 实例RWC1_01B[STANDBY, OPEN, ISTAT_SAME:TRUE]运行正常, 守护进程是OPEN状态,守护类型是GLOBAL[monitor] 2021-08-12 18:14:15: 组(GRWC1)当前活动实例运行正常[monitor] 2021-08-12 18:14:15: 所有组中的活动实例运行正常!
可以看到所有实例运行正常,RWC集群部署完成。
更多资讯请上达梦技术社区了解:
更多推荐
DM8集群部署RWC集群Linux两节点手切
发布评论