安装前的规划

环境

业务IP	内部通信IP	实例名	操作系统
192.168.40.137	192.168.253.130	xpcldb1	Redhat7.8
192.168.40.138	192.168.253.131	xpcldb2	Redhat7.8
192.168.40.139	192.168.253.132	xpcldb3	Redhat7.8

端口信息

实例名	PORT_NUM	MAL_INST_HOST	MAL_INST_PORT	MAL_HOST	MAL_PORT
xpcdb1	5236	192.168.40.137	5236	192.168.253.130	5269
xpcdb2	5236	192.168.40.138	5236	192.168.253.131	5269
xpcdb3	5236	192.168.40.139	5236	192.168.253.132	5269

数据库初始化参数

数据库初始化参数页大小：16K
簇大小：16
字符集：UTF-8
字符串比较大小写敏感：是
长度以字符为单位：否
数据库名：xpcdb1,xpcdb2,xpcdb3
实例名：xpcdb1,xpcdb2,xpcdb3 
端口：5236，5269
日志文件大小：共 2 个(每个256MB)
是否启用归档：不启用

安装路径规划

实例名	ip地址	安装路径	数据目录路径
xpcdb1	192.168.40.137	/dm/dmdbms/dm8	/dm/dmdata/
xpcdb2	192.168.40.138	/dm/dmdbms/dm8	/dm/dmdata/
xpcdb3	192.168.40.139	/dm/dmdbms/dm8	/dm/dmdata/

数据库安装

192.168.40.137/138/139

mount /dev/cdrom /mnt
su - dmdba
 
./DMInstall.bin -i

root:
/dm/dmdbms/dm8/script/root/root_installer.sh

数据库初始化

192.168.40.137/138/139，然后各启动一次实例后退出

su - dmdba
dminit path=/dm/dmdata db_name=xpcdb1 instance_name=xpcdb1 LOG_SIZE=256 SYSDBA_PWD=dameng123 EXTENT_SIZE=16 PAGE_SIZE=16 charset=1

dminit path=/dm/dmdata db_name=xpcdb2 instance_name=xpcdb2 LOG_SIZE=256 SYSDBA_PWD=dameng123 EXTENT_SIZE=16 PAGE_SIZE=16 charset=1

dminit path=/dm/dmdata db_name=xpcdb3 instance_name=xpcdb3 LOG_SIZE=256 SYSDBA_PWD=dameng123 EXTENT_SIZE=16 PAGE_SIZE=16 charset=1


dmserver /dm/dmdata/xpcdb1/dm.ini 
dmserver /dm/dmdata/xpcdb2/dm.ini 
dmserver /dm/dmdata/xpcdb3/dm.ini

注册服务

root用户:

cd /dm/dmdbms/dm8/script/root
./dm_service_installer.sh -t dmserver -dm_ini /dm/dmdata/xpcdb1/dm.ini -p xpcdb1

cd /dm/dmdbms/dm8/script/root
./dm_service_installer.sh -t dmserver -dm_ini /dm/dmdata/xpcdb2/dm.ini -p xpcdb2

cd /dm/dmdbms/dm8/script/root
./dm_service_installer.sh -t dmserver -dm_ini /dm/dmdata/xpcdb3/dm.ini -p xpcdb3

更改dm.ini参数

su - dmdba
vi /dm/dmdata/xpcdb1/dm.ini 
vi /dm/dmdata/xpcdb2/dm.ini 
vi /dm/dmdata/xpcdb3/dm.ini

192.168.40.137:
INSTANCE_NAME = xpcdb1 
PORT_NUM = 5236
MAL_INI = 1
MPP_INI = 1

192.168.40.138:
INSTANCE_NAME = xpcdb2 
PORT_NUM = 5236
MAL_INI = 1
MPP_INI = 1

192.168.40.139:
INSTANCE_NAME = xpcdb3 
PORT_NUM = 5236
MAL_INI = 1
MPP_INI = 1

配置dmmai.ini文件

192.168.40.137/138/139

su - dmdba

vi /dm/dmdata/xpcdb1/dmmal.ini 
vi /dm/dmdata/xpcdb2/dmmal.ini 
vi /dm/dmdata/xpcdb3/dmmal.ini 

[MAL_INST1]
MAL_INST_NAME = xpcdb1	 # 实例名和dm.ini中的INSTANCE_NAME 一致
MAL_HOST = 192.168.253.130      #MAL 系统监听TCP连接的IP地址
MAL_PORT = 5269	            #MAL 系统监听TCP连接的端口
MAL_INST_HOST = 192.168.40.137	 #实例的对外服务IP地址
MAL_INST_PORT = 5236	         # 实例的对外服务端口和dm.ini中的PORT_NUM 一致

[MAL_INST2]
MAL_INST_NAME = xpcdb2 
MAL_HOST = 192.168.253.131
MAL_PORT = 5269	
MAL_INST_HOST = 192.168.40.138
MAL_INST_PORT = 5236

[MAL_INST3]
MAL_INST_NAME = xpcdb3 
MAL_HOST = 192.168.253.132
MAL_PORT = 5269
MAL_INST_HOST = 192.168.40.139
MAL_INST_PORT = 5236

配置控制文件

在192.168.40.137上做好，然后拷贝到另外两台机器

vi /dm/dmdata/xpcdb1/dmmpp.ini

[SERVICE_NAME1] 
MPP_SEQ_NO = 0
MPP_INST_NAME = xpcdb1

[SERVICE_NAME2] 
MPP_SEQ_NO = 1
MPP_INST_NAME = xpcdb2

[SERVICE_NAME3] 
MPP_SEQ_NO = 2
MPP_INST_NAME = xpcdb3

启动节点

192.168.40.137/138/139

DmServicexpcdb1 start 
DmServicexpcdb2 start 
DmServicexpcdb3 start

登录测试

disql sysdba/dameng123
select * from v$mpp_cfg_item;

业务数据测试

192.168.40.137创建测试数据

disql sysdba/dameng123

create tablespace test01 datafile '/dm/dmdata/xpcdb/test01.dbf' size 100 autoextend off;
create tablespace test01_idx datafile '/dm/dmdata/xpcdb/test01_idx01.dbf' size 100 autoextend off;
create user "test01" identified by "test123456" default tablespace test01 default index tablespace test01_idx;
grant dba to test01;
select PATH from v$datafile;

conn test01/test123456@192.168.40.137:5236;
create table test01 (id int,name varchar(50),create_date date);
insert into test01 values(1,'达梦','2022-10-15');
insert into test01 values(2,'达梦数据库','2022-10-16');
insert into test01 values(3,'DM','2022-10-17');
insert into test01 values(4,'DMDB','2022-10-18');
insert into test01 values(5,'DM8','2022-10-19');
commit;
select count(*) from test01;

192.168.40.138查看