达梦数据库主从集群版本滚动升级（停机窗口少）

1.查看主从集群数据库版本信息
SQL> select id_code();

行号 ID_CODE()

---

1 1-2-70-21.09.08-147080-10028-ENT

SQL> select * from v$version;

行号 BANNER

---

1 DM Database Server 64 V8
2 DB Version: 0x7000c

2.升级准备工作

1.挂载新版本数据库到从库上面
[root@db02 ~]# df -h
文件系统 容量 已用 可用 已用% 挂载点
/dev/mapper/rhel-root 50G 13G 38G 26% /
devtmpfs 895M 0 895M 0% /dev
tmpfs 911M 0 911M 0% /dev/shm
tmpfs 911M 11M 901M 2% /run
tmpfs 911M 0 911M 0% /sys/fs/cgroup
/dev/sda1 1014M 170M 845M 17% /boot
/dev/mapper/rhel-home 27G 37M 27G 1% /home
tmpfs 183M 40K 183M 1% /run/user/0
/dev/sr0 914M 914M 0 100% /run/media/root/dameng
[root@db02 ~]# mount /dev/sr0 /mnt
mount: /dev/sr0 写保护，将以只读方式挂载

2.停掉从库的守护进程和数据库服务
[dmdba@db02 bin]$ ps -f|grep dms
dmdba 7616 7555 0 16:33 pts/1 00:00:00 grep --color=auto dms
[dmdba@db02 bin]$ ps -f|grep dmw
dmdba 7618 7555 0 16:33 pts/1 00:00:00 grep --color=auto dmw

3.将执行文件复制到tmp下,修改属组和主，权限等
[root@db02 mnt]# cp DMInstall.bin /tmp/
[root@db02 mnt]# cd /tmp/
[root@db02 tmp]# chown -R dmdba.dinstall DMInstall.bin
[root@db02 tmp]# chmod 775 DMInstall.bin

4.使用新的二进制文件安装数据库目录
[dmdba@db02 tmp]$ ./DMInstall.bin -i
请选择设置时区 [21]:21

安装类型:
1 典型安装
2 服务器
3 客户端
4 自定义
请选择安装类型的数字序号 [1 典型安装]:1
所需空间: 1611M

请选择安装目录 [/home/dmdba/dmdbms]:
可用空间: 26G
是否确认安装路径(/home/dmdba/dmdbms)? (Y/y:是 N/n:否) [Y/y]:y

[root@db02 tmp]# . /home/dmdba/dmdbms/script/root/root_installer.sh
修改服务器权限
创建DmAPService服务
创建服务(DmAPService)完成
启动DmAPService服务

5.备份原目录bin
[dmdba@db02 ~]$ cd /dm8/soft/
[dmdba@db02 soft]$ mv bin bin.bak

5.将新目录bin复制到旧安装目录下
[dmdba@db02 dmdbms]$ cp -r bin /dm8/soft/

6.启动守护进程
[dmdba@db02 bin]$ ./dmwatcher /dm8/data/DM/dmwatcher.ini
DMWATCHER[4.0] V8
DMWATCHER[4.0] IS READY
status
2022-07-28 19:21:00

GROUP_NAME = GRP1
DW_STATUS = STARTUP
DW_SUB_STATUS = SUB_STATE_START

Waitpid error!
file dm.key not found, use default license!
version info: develop
DM Database Server 64 V8 03134283890-20220720-165295-10045 startup…
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
Database mode = 2, oguid = 453331
License will expire on 2023-07-20
file lsn: 104503
ndct db load finished
ndct second level fill fast pool finished
ndct third level fill fast pool finished
ndct second level fill fast pool finished
ndct third level fill fast pool finished
ndct fill fast pool finished
nsvr_startup end.
aud sys init success.
aud rt sys init success.
systables desc init success.
ndct_db_load_info success.
SYSTEM IS READY.

7.查看监控服务
[dmdba@db02 bin]$ ./dmmonitor /dm8/data/DM/dmmonitor.ini
[monitor] 2022-07-28 19:23:58: DMMONITOR[4.0] V8
[monitor] 2022-07-28 19:23:58: DMMONITOR[4.0] IS READY.

[monitor] 2022-07-28 19:23:58: 收到守护进程(DM02)消息
WTIME WSTATUS INST_OK INAME ISTATUS IMODE RSTAT N_OPEN FLSN CLSN
2022-07-28 19:23:58 OPEN OK DM02 OPEN STANDBY NULL 30 104503 104503

[monitor] 2022-07-28 19:23:59: 收到守护进程(DM01)消息
WTIME WSTATUS INST_OK INAME ISTATUS IMODE RSTAT N_OPEN FLSN CLSN
2022-07-28 19:23:59 OPEN OK DM01 OPEN PRIMARY VALID 30 104503 104503

8.将从库切换成主库
login
用户名:sysdba
密码:
[monitor] 2022-07-28 19:27:26: 登录监视器成功!

switchover GRP1.DM02

[dmdba@db02 bin]$ ./dmmonitor /dm8/data/DM/dmmonitor.ini
[monitor] 2022-07-28 19:28:29: DMMONITOR[4.0] V8
[monitor] 2022-07-28 19:28:29: DMMONITOR[4.0] IS READY.

[monitor] 2022-07-28 19:28:29: 收到守护进程(DM01)消息
WTIME WSTATUS INST_OK INAME ISTATUS IMODE RSTAT N_OPEN FLSN CLSN
2022-07-28 19:28:29 OPEN OK DM01 OPEN STANDBY NULL 31 106953 106953

[monitor] 2022-07-28 19:28:29: 收到守护进程(DM02)消息
WTIME WSTATUS INST_OK INAME ISTATUS IMODE RSTAT N_OPEN FLSN CLSN
2022-07-28 19:28:29 OPEN OK DM02 OPEN PRIMARY VALID 31 117260 117261

9.查询新主库升级后的版本
SQL> select id_code();

行号 ID_CODE()

---

1 --03134283890-20220720-165295-10045 Pack11

10.停掉原主库的守护进程和数据库实例
[dmdba@db01 bin]$ ps -ef|grep dms
dmdba 5980 5908 0 19:32 pts/1 00:00:00 grep --color=auto dms
[dmdba@db01 bin]$ ps -ef|grep dmw
dmdba 5982 5908 0 19:32 pts/1 00:00:00 grep --color=auto dmw

11.开始原主库升级
[dmdba@db02 tmp]$ scp DMInstall.bin dmdba@192.168.54.110:/tmp/
The authenticity of host ‘192.168.54.110 (192.168.54.110)’ can’t be established.
ECDSA key fingerprint is SHA256:B+YhL+ea4w/AuhruZOacs4sHOaF/50+8f1FFhF7v5eU.
ECDSA key fingerprint is MD5:bd:a2:4c:8f:19:c3:38:b3:77:77:59:75:50:e7:7d:8a.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added ‘192.168.54.110’ (ECDSA) to the list of known hosts.
dmdba@192.168.54.110’s password:
DMInstall.bin 100% 911MB 8.5MB/s 01:46

[dmdba@db01 tmp]$ ./DMInstall.bin -i
请选择安装语言(C/c:中文 E/e:英文) [C/c]:c
解压安装程序…
欢迎使用达梦数据库安装程序

是否输入Key文件路径? (Y/y:是 N/n:否) [Y/y]:n
请以root系统用户执行命令:
/home/dmdba/dmdbms/script/root/root_installer.sh

安装结束

[dmdba@db01 tmp]$ exit
登出
[root@db01 tmp]# . /home/dmdba/dmdbms/script/root/root_installer.sh
修改服务器权限
创建DmAPService服务
创建服务(DmAPService)完成
启动DmAPService服务

12.备份原主库bin文件
[dmdba@db01 soft]$ mv bin bin.bak
[dmdba@db01 dmdbms]$ cp -r bin /dm8/soft/

13。开启原主库守护进程
[dmdba@db01 dmdbms]$ cd /dm8/soft/bin
[dmdba@db01 bin]$ ./dmwatcher /dm8/data/DM/dmwatcher.ini
DMWATCHER[4.0] V8
DMWATCHER[4.0] IS READY

14.查询监控（数据追平）
[dmdba@db02 bin]$ ./dmmonitor /dm8/data/DM/dmmonitor.ini
[monitor] 2022-07-29 16:56:34: DMMONITOR[4.0] V8
[monitor] 2022-07-29 16:56:34: DMMONITOR[4.0] IS READY.

[monitor] 2022-07-29 16:56:34: 收到守护进程(DM02)消息
WTIME WSTATUS INST_OK INAME ISTATUS IMODE RSTAT N_OPEN FLSN CLSN
2022-07-29 16:56:34 OPEN OK DM02 OPEN PRIMARY VALID 31 124842 124842

[monitor] 2022-07-29 16:56:35: 收到守护进程(DM01)消息
WTIME WSTATUS INST_OK INAME ISTATUS IMODE RSTAT N_OPEN FLSN CLSN
2022-07-29 16:56:35 OPEN OK DM01 OPEN STANDBY VALID 31 124841 124841

15。查看新从库版本信息
[dmdba@db01 bin]$ ./disql sysdba/dmorcl123456:15236

服务器[LOCALHOST:15236]:处于备库打开状态
登录使用时间 : 19.556(ms)
disql V8
SQL> select id_code();

行号 ID_CODE()

---

1 --03134283890-20220720-165295-10045 Pack11

已用时间: 17.338(毫秒). 执行号:0.
SQL>

16.将新主库切换成从库，新从库切换成主库
[dmdba@db02 bin]$ ./dmmonitor /dm8/data/DM/dmmonitor.ini
[monitor] 2022-07-29 17:01:02: DMMONITOR[4.0] V8
[monitor] 2022-07-29 17:01:02: DMMONITOR[4.0] IS READY.

[monitor] 2022-07-29 17:01:02: 收到守护进程(DM02)消息
WTIME WSTATUS INST_OK INAME ISTATUS IMODE RSTAT N_OPEN FLSN CLSN
2022-07-29 17:01:02 OPEN OK DM02 OPEN STANDBY NULL 32 127374 127374

[monitor] 2022-07-29 17:01:03: 收到守护进程(DM01)消息
WTIME WSTATUS INST_OK INAME ISTATUS IMODE RSTAT N_OPEN FLSN CLSN
2022-07-29 17:01:02 OPEN OK DM01 OPEN PRIMARY VALID 32 127375 127376

17.主从集群升级成功