达梦数据库DM8实时主备集群自动&手动切换主备

1主库故障后备库自动切换为主库
1.1 主备状态查看

1.2 主库服务器断电

[root@dmp ~]# shutdown -h 0

Broadcast message from root@dmp
(/dev/pts/0) at 16:50 …

The system is going down for halt NOW!

1.3 备库自动接管

[monitor] 2021-02-11 17:12:07: Received message timeout from(GRP1_RT_01)
WTIME WSTATUS INST_OK INAME ISTATUS IMODE RSTAT N_OPEN FLSN CLSN
2021-02-24 16:50:49 ERROR OK GRP1_RT_01 OPEN PRIMARY VALID 19 62877 62877

[monitor] 2021-02-11 17:12:08: Check primary instance error in group(GRP1), start to auto takeover

[monitor] 2021-02-11 17:12:08: Notify group(GRP1)'s active dmwatcher to set MID
[monitor] 2021-02-11 17:12:08: Notify group(GRP1)'s active dmwatcher to set MID success
[monitor] 2021-02-11 17:12:08: Start to takeover use instance GRP1_RT_02
[monitor] 2021-02-11 17:12:08: Notify dmwatcher(GRP1_RT_02) switch to TAKEOVER status
[monitor] 2021-02-11 17:12:08: Dmwatcher process GRP1_RT_02 status switching [OPEN–>TAKEOVER]
[monitor] 2021-02-11 17:12:08: Switch dmwatcher GRP1_RT_02 to TAKEOVER status success
[monitor] 2021-02-11 17:12:08: Instance GRP1_RT_02 start to execute sql SP_SET_GLOBAL_DW_STATUS(0, 7)
[monitor] 2021-02-11 17:12:08: Instance GRP1_RT_02 execute sql SP_SET_GLOBAL_DW_STATUS(0, 7) success
[monitor] 2021-02-11 17:12:08: Instance GRP1_RT_02 start to execute sql SP_APPLY_KEEP_PKG()
[monitor] 2021-02-11 17:12:08: Instance GRP1_RT_02 execute sql SP_APPLY_KEEP_PKG() success
[monitor] 2021-02-11 17:12:08: Instance GRP1_RT_02 start to execute sql ALTER DATABASE MOUNT
[monitor] 2021-02-11 17:12:10: Instance GRP1_RT_02 execute sql ALTER DATABASE MOUNT success
[monitor] 2021-02-11 17:12:10: Instance GRP1_RT_02 start to execute sql ALTER DATABASE PRIMARY
[monitor] 2021-02-11 17:12:10: Instance GRP1_RT_02 execute sql ALTER DATABASE PRIMARY success
[monitor] 2021-02-11 17:12:13: Notify instance GRP1_RT_02 to change all arch status to be invalid
[monitor] 2021-02-11 17:12:13: Succeed to change all instances arch status to be invalid
[monitor] 2021-02-11 17:12:13: Instance GRP1_RT_02 start to execute sql ALTER DATABASE OPEN FORCE
[monitor] 2021-02-11 17:12:15: Instance GRP1_RT_02 execute sql ALTER DATABASE OPEN FORCE success
[monitor] 2021-02-11 17:12:15: Instance GRP1_RT_02 start to execute sql SP_SET_GLOBAL_DW_STATUS(7, 0)
[monitor] 2021-02-11 17:12:15: Instance GRP1_RT_02 execute sql SP_SET_GLOBAL_DW_STATUS(7, 0) success
[monitor] 2021-02-11 17:12:15: Notify dmwatcher(GRP1_RT_02) switch to OPEN status
[monitor] 2021-02-11 17:12:15: Dmwatcher process GRP1_RT_02 status switching [TAKEOVER–>OPEN]
[monitor] 2021-02-11 17:12:16: Switch dmwatcher GRP1_RT_02 to OPEN status success
[monitor] 2021-02-11 17:12:16: Notify group(GRP1)'s dmwatcher to do clear
[monitor] 2021-02-11 17:12:16: Clean request of dmwatcher processer GRP1_RT_02 success
[monitor] 2021-02-11 17:12:16: Success to takeover use instance GRP1_RT_02

[monitor] 2021-02-11 17:12:16: Group(GRP1) use instance GRP1_RT_02 auto takeover success

1.4 主备状态查看验证

1.5 验证主备数据是否同步
1.5.1主库创建表插入数据并提交

[root@dms1 bin]# ./disql SYSDBA/SYSDBA@192.168.3.132

Server[192.168.3.132:5236]:mode is primary, state is open
login used time : 7.768(ms)
disql V8
SQL> create table t1(di number(12));
executed successfully
used time: 82.061(ms). Execute id is 5.
SQL> insert into t1 values(1);
affect rows 1

used time: 1.569(ms). Execute id is 106.
SQL> commit;
executed successfully
used time: 7.765(ms). Execute id is 107.
SQL> select * from t1;

LINEID DI

---

1 1

used time: 0.759(ms). Execute id is 108.

1.5.2备库查看该表的数据

[root@dmp bin]# ./disql SYSDBA/SYSDBA@LOCALHOST

Server[LOCALHOST:5236]:mode is standby, state is open
login used time : 6.006(ms)
disql V8
SQL> select * from t1;

LINEID DI

---

1 1

used time: 46.085(ms). Execute id is 0.

2主库备库手动切换（switchover）
2.1 在监视器做switchover
login
username:SYSDBA
password:
[monitor] 2021-02-11 17:26:16: Login dmmonitor success!

switchover
[monitor] 2021-02-11 17:26:21: Start to switchover instance GRP1_RT_01
[monitor] 2021-02-11 17:26:21: Notify dmwatcher(GRP1_RT_02) switch to SWITCHOVER status
[monitor] 2021-02-11 17:26:21: Dmwatcher process GRP1_RT_02 status switching [OPEN–>SWITCHOVER]
[monitor] 2021-02-11 17:26:21: Switch dmwatcher GRP1_RT_02 to SWITCHOVER status success
[monitor] 2021-02-11 17:26:21: Notify dmwatcher(GRP1_RT_01) switch to SWITCHOVER status
[monitor] 2021-02-11 17:26:21: Dmwatcher process GRP1_RT_01 status switching [OPEN–>SWITCHOVER]
[monitor] 2021-02-11 17:26:22: Switch dmwatcher GRP1_RT_01 to SWITCHOVER status success
[monitor] 2021-02-11 17:26:22: Instance GRP1_RT_02 start to execute sql SP_SET_GLOBAL_DW_STATUS(0, 6)
[monitor] 2021-02-11 17:26:22: Instance GRP1_RT_02 execute sql SP_SET_GLOBAL_DW_STATUS(0, 6) success
[monitor] 2021-02-11 17:26:22: Instance GRP1_RT_01 start to execute sql SP_SET_GLOBAL_DW_STATUS(0, 6)
[monitor] 2021-02-11 17:26:22: Instance GRP1_RT_01 execute sql SP_SET_GLOBAL_DW_STATUS(0, 6) success
[monitor] 2021-02-11 17:26:22: Instance GRP1_RT_02 start to execute sql ALTER DATABASE MOUNT
[monitor] 2021-02-11 17:26:24: Instance GRP1_RT_02 execute sql ALTER DATABASE MOUNT success
[monitor] 2021-02-11 17:26:24: Instance GRP1_RT_01 start to execute sql SP_APPLY_KEEP_PKG()
[monitor] 2021-02-11 17:26:24: Instance GRP1_RT_01 execute sql SP_APPLY_KEEP_PKG() success
[monitor] 2021-02-11 17:26:24: Instance GRP1_RT_01 start to execute sql ALTER DATABASE MOUNT
[monitor] 2021-02-11 17:26:25: Instance GRP1_RT_01 execute sql ALTER DATABASE MOUNT success
[monitor] 2021-02-11 17:26:25: Instance GRP1_RT_02 start to execute sql ALTER DATABASE STANDBY
[monitor] 2021-02-11 17:26:25: Instance GRP1_RT_02 execute sql ALTER DATABASE STANDBY success
[monitor] 2021-02-11 17:26:25: Instance GRP1_RT_01 start to execute sql ALTER DATABASE PRIMARY
[monitor] 2021-02-11 17:26:26: Instance GRP1_RT_01 execute sql ALTER DATABASE PRIMARY success
[monitor] 2021-02-11 17:26:26: Notify instance GRP1_RT_01 to change all arch status to be invalid
[monitor] 2021-02-11 17:26:26: Succeed to change all instances arch status to be invalid
[monitor] 2021-02-11 17:26:26: Instance GRP1_RT_02 start to execute sql ALTER DATABASE OPEN FORCE
[monitor] 2021-02-11 17:26:26: Instance GRP1_RT_02 execute sql ALTER DATABASE OPEN FORCE success
[monitor] 2021-02-11 17:26:26: Instance GRP1_RT_01 start to execute sql ALTER DATABASE OPEN FORCE
[monitor] 2021-02-11 17:26:28: Instance GRP1_RT_01 execute sql ALTER DATABASE OPEN FORCE success
[monitor] 2021-02-11 17:26:28: Instance GRP1_RT_02 start to execute sql SP_SET_GLOBAL_DW_STATUS(6, 0)
[monitor] 2021-02-11 17:26:28: Instance GRP1_RT_02 execute sql SP_SET_GLOBAL_DW_STATUS(6, 0) success
[monitor] 2021-02-11 17:26:28: Instance GRP1_RT_01 start to execute sql SP_SET_GLOBAL_DW_STATUS(6, 0)
[monitor] 2021-02-11 17:26:28: Instance GRP1_RT_01 execute sql SP_SET_GLOBAL_DW_STATUS(6, 0) success
[monitor] 2021-02-11 17:26:28: Notify dmwatcher(GRP1_RT_02) switch to OPEN status
[monitor] 2021-02-11 17:26:28: Dmwatcher process GRP1_RT_02 status switching [SWITCHOVER–>OPEN]
[monitor] 2021-02-11 17:26:28: Switch dmwatcher GRP1_RT_02 to OPEN status success
[monitor] 2021-02-11 17:26:28: Notify dmwatcher(GRP1_RT_01) switch to OPEN status
[monitor] 2021-02-11 17:26:28: Dmwatcher process GRP1_RT_01 status switching [SWITCHOVER–>OPEN]
[monitor] 2021-02-11 17:26:28: Switch dmwatcher GRP1_RT_01 to OPEN status success
[monitor] 2021-02-11 17:26:28: Notify group(GRP1)'s dmwatcher to do clear
[monitor] 2021-02-11 17:26:28: Clean request of dmwatcher processer GRP1_RT_01 success
[monitor] 2021-02-11 17:26:28: Clean request of dmwatcher processer GRP1_RT_02 success
[monitor] 2021-02-11 17:26:28: Switchover instance GRP1_RT_01 success

2021-02-11 17:26:28
#================================================================================#
GROUP OGUID MON_CONFIRM MODE MPP_FLAG
GRP1 453331 TRUE AUTO FALSE

<>
IP MAL_DW_PORT WTIME WTYPE WCTLSTAT WSTATUS INAME INST_OK N_EP N_OK ISTATUS IMODE DSC_STATUS RTYPE RSTAT
192.168.0.141 52141 2021-02-24 17:05:21 GLOBAL VALID OPEN GRP1_RT_01 OK 1 1 OPEN PRIMARY DSC_OPEN REALTIME VALID

EP INFO:
INST_PORT INST_OK INAME ISTATUS IMODE DSC_SEQNO DSC_CTL_NODE RTYPE RSTAT FSEQ FLSN CSEQ CLSN DW_STAT_FLAG
5236 OK GRP1_RT_01 OPEN PRIMARY 0 0 REALTIME VALID 4036 64293 4036 65650 NONE

<>
IP MAL_DW_PORT WTIME WTYPE WCTLSTAT WSTATUS INAME INST_OK N_EP N_OK ISTATUS IMODE DSC_STATUS RTYPE RSTAT
192.168.0.142 52142 2021-02-24 17:05:30 GLOBAL VALID OPEN GRP1_RT_02 OK 1 1 OPEN STANDBY DSC_OPEN REALTIME INVALID

EP INFO:
INST_PORT INST_OK INAME ISTATUS IMODE DSC_SEQNO DSC_CTL_NODE RTYPE RSTAT FSEQ FLSN CSEQ CLSN DW_STAT_FLAG
5236 OK GRP1_RT_02 OPEN STANDBY 0 0 REALTIME INVALID 4035 64292 4035 64292 NONE

DATABASE(GRP1_RT_02) APPLY INFO FROM (GRP1_RT_01):
DSC_SEQNO[0], (ASEQ, SSEQ, KSEQ)[4035, 4035, 4035], (ALSN, SLSN, KLSN)[64292, 64292, 64292], N_TSK[0], TSK_MEM_USE[0]

#================================================================================#

[monitor] 2021-02-11 17:26:31: Dmwatcher process GRP1_RT_01 status switching [OPEN–>RECOVERY]
WTIME WSTATUS INST_OK INAME ISTATUS IMODE RSTAT N_OPEN FLSN CLSN
2021-02-24 17:05:24 RECOVERY OK GRP1_RT_01 OPEN PRIMARY VALID 21 65650 65650

[monitor] 2021-02-11 17:26:34: Dmwatcher process GRP1_RT_01 status switching [RECOVERY–>OPEN]
WTIME WSTATUS INST_OK INAME ISTATUS IMODE RSTAT N_OPEN FLSN CLSN
2021-02-24 17:05:27 OPEN OK GRP1_RT_01 OPEN PRIMARY VALID 21 65650 65650

主备切换成功

2.2 验证主备数据是否同步
2.2.1主库插入数据并提交

SQL> insert into t1 values(2);
affect rows 1

used time: 2.865(ms). Execute id is 1.
SQL> commit ;
executed successfully
used time: 5.862(ms). Execute id is 2.

2.2.2备库验证数据
SQL> select * from t1;

LINEID DI

---

1 1
2 2

used time: 4.598(ms). Execute id is 205.