达梦(主备)MPP搭建

最新推荐文章于 2025-05-26 11:29:52 发布

2201_75559416

最新推荐文章于 2025-05-26 11:29:52 发布

阅读量182

点赞数

文章标签：网络前端 linux

本文链接：https://blog.youkuaiyun.com/2201_75559416/article/details/128508780

版权

本文详细介绍了达梦数据库的主备MPP环境搭建过程，包括环境规划、初始化实例、配置归档、启动实例、备份恢复、配置OGUID等关键步骤，确保高可用性和数据安全性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1、环境规划

主机		IP	实例名	PORT_NUM	MAL_INST_DW_PORT	MAL_PORT	MAL_DW_PORT
主机A	主A	192.168.42.129	EP11	5236	5246	5337	5347
主机A	备B	192.168.42.129	EP22	5237	5247	5338	5348
主机B	主B	192.168.42.130	EP12	5236	5246	5337	5347
主机B	备A	192.168.42.130	EP21	5237	5247	5338	5348

2、初始化主备实例

./dminit PATH=/dm8/data CASE_SENSITIVE=N CHARSET=1 INSTANCE_NAME=EP11 PORT_NUM=5236
./dminit PATH=/dm8/data1 CASE_SENSITIVE=N CHARSET=1 INSTANCE_NAME=EP22 PORT_NUM=5237

[dmdba@mpp1 bin]$ ./dminit PATH=/dm8/data CASE_SENSITIVE=N CHARSET=1 INSTANCE_NAME=EP11
initdb V8
db version: 0x7000c
file dm.key not found, use default license!
License will expire on 2023-01-10
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
 log file path: /dm8/data/DAMENG/DAMENG01.log
 log file path: /dm8/data/DAMENG/DAMENG02.log
write to dir [/dm8/data/DAMENG].
create dm database success. 2022-12-31 10:41:11
[dmdba@mpp1 bin]$ ./dminit PATH=/dm8/data1 CASE_SENSITIVE=N CHARSET=1 INSTANCE_NAME=EP22
initdb V8
db version: 0x7000c
file dm.key not found, use default license!
License will expire on 2023-01-10
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
 log file path: /dm8/data1/DAMENG/DAMENG01.log
 log file path: /dm8/data1/DAMENG/DAMENG02.log
write to dir [/dm8/data1/DAMENG].
create dm database success. 2022-12-31 10:44:29

./dminit PATH=/dm8/data CASE_SENSITIVE=N CHARSET=1 INSTANCE_NAME=EP12 PORT_NUM=5236
./dminit PATH=/dm8/data1 CASE_SENSITIVE=N CHARSET=1 INSTANCE_NAME=EP21 PORT_NUM=5237

[dmdba@mpp2 bin]$  ./dminit PATH=/dm8/data CASE_SENSITIVE=N CHARSET=1 INSTANCE_NAME=EP12
initdb V8
db version: 0x7000c
file dm.key not found, use default license!
License will expire on 2023-01-10
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
 log file path: /dm8/data/DAMENG/DAMENG01.log
 log file path: /dm8/data/DAMENG/DAMENG02.log
write to dir [/dm8/data/DAMENG].
create dm database success. 2022-12-31 10:44:55
[dmdba@mpp2 bin]$  ./dminit PATH=/dm8/data1 CASE_SENSITIVE=N CHARSET=1 INSTANCE_NAME=EP21
initdb V8
db version: 0x7000c
file dm.key not found, use default license!
License will expire on 2023-01-10
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
 log file path: /dm8/data1/DAMENG/DAMENG01.log
 log file path: /dm8/data1/DAMENG/DAMENG02.log
write to dir [/dm8/data1/DAMENG].
create dm database success. 2022-12-31 10:45:04

3、配置归档

修改文件dm.ini ARCH_INI=1

ARCH_INI                        = 1                     #dmarch.ini

创建dmarch.ini文件

[ARCHIVE_REALTIME1]
ARCH_TYPE = REALTIME #实时归档类型
ARCH_DEST = EP21 #实时归档目标实例名
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL #本地归档类型
ARCH_DEST = /dm8/data/arch #本地归档文件存放路径       
ARCH_FILE_SIZE = 1024 #单位 Mb，本地单个归档文件最大值
ARCH_SPACE_LIMIT = 20480  #单位Mb，0 表示无限制，范围1024~4294967294M

4、前台启动A、B上主库实例

[dmdba@mpp1 bin]$ ./dmserver /dm8/data/DAMENG/dm.ini

5、分别进行脱机备份和恢复

./dmrman ctlstmt="backup database '/dm8/data/DAMENG/dm.ini' full to backup_file_01 backupset '/dm8/BACKUP

最低0.47元/天解锁文章