背景:
DM7常见的数据守护是一主一备2台数据库,某些特殊场景需要用到一主两备3台数据库来提升数据安全。该篇文章主要介绍一主两备数据库的搭建方法以及故障切换测试。
一、环境
服务器ip 数据库状态 内存
10.111.77.79 主库 31G
10.111.77.80 备库 31G
10.111.77.81 备库 31G
数据库安装包DMInstall.bin
二、部署一主两备(79/80/81):
2.1、分别在3台服务器上安装数据库软件
cd /opt
[dmdba@YNKJ-XZZHGLXT7779 opt]$ ./DMInstall.bin -i
2.2、在10.111.77.79上初始化数据库实例
[dmdba@YNKJ-XZZHGLXT7779 bin]$ pwd
/dmdata1/dmdbms/bin
[dmdba@YNKJ-XZZHGLXT7779 bin]$ ./dminit path=/dmdata1 db_name=TEST instance_name=YNZHTEST page_size=16 extent_size=16
initdb V7.6.1.38-Build(2019.12.05-116618)ENT
db version: 0x7000a
file dm.key not found, use default license!
License will expire on 2020-12-05
log file path: /dmdata1/TEST/TEST01.log
log file path: /dmdata1/TEST/TEST02.log
write to dir [/dmdata1/TEST].
create dm database success. 2020-08-07 15:04:58
2.3、前台启动数据库
[dmdba@YNKJ-XZZHGLXT7779 bin]$ ./dmserver /dmdata1/TEST/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 V7.6.1.38-Build(2019.12.05-116618)ENT startup…
License will expire on 2020-12-05
ckpt lsn: 0
ndct db load finished
ndct fill fast pool finished
set EP[0]'s pseg state to inactive
iid page’s trxid = 1
NEXT TRX ID = 2
pseg recv finished
nsvr_startup end.
aud sys init success.
aud rt sys init success.
trx: 2 purged 1 pages
trx: 21 purged 1 pages
trx: 22 purged 1 pages
trx: 23 purged 1 pages
trx: 24 purged 1 pages
trx: 35 purged 1 pages
trx: 155 purged 1 pages
trx: 172 purged 1 pages
trx: 173 purged 1 pages
trx: 174 purged 1 pages
trx: 175 purged 1 pages
trx: 176 purged 1 pages
trx: 177 purged 1 pages
trx: 179 purged 1 pages
trx: 181 purged 1 pages
trx: 184 purged 1 pages
trx: 190 purged 1 pages
trx: 200 purged 1 pages
trx: 208 purged 16 pages
trx: 213 purged 1 pages
trx: 214 purged 1 pages
trx: 215 purged 1 pages
trx: 216 purged 1 pages
trx: 217 purged 1 pages
trx: 218 purged 1 pages
trx: 219 purged 1 pages
trx: 220 purged 1 pages
trx: 221 purged 1 pages
trx: 222 purged 1 pages
trx: 223 purged 1 pages
trx: 224 purged 1 pages
trx: 225 purged 1 pages
trx: 226 purged 1 pages
trx: 227 purged 1 pages
trx: 262 purged 1 pages
trx: 264 purged 1 pages
trx: 265 purged 1 pages
trx: 266 purged 1 pages
trx: 271 purged 10 pages
trx: 298 purged 1 pages
trx: 299 purged 1 pages
trx: 300 purged 1 pages
trx: 301 purged 1 pages
trx: 307 purged 1 pages
trx: 309 purged 1 pages
trx: 311 purged 1 pages
trx: 316 purged 1 pages
trx: 321 purged 1 pages
trx: 326 purged 1 pages
trx: 328 purged 1 pages
trx: 331 purged 1 pages
trx: 333 purged 1 pages
trx: 339 purged 1 pages
trx: 340 purged 1 pages
trx: 351 purged 4 p