提示:文章写完后,目录可以自动生成,如何生成可参考右边的帮助文档
文章目录
一、 系统配置
echo "192.168.115.155 rd155" >> /etc/hosts
echo "192.168.115.156 rd156" >> /etc/hosts
cat /etc/hosts
echo "export LANG=en_US.UTF8" >> ~/.bash_profile
cat ~/.bash_profile
# 集群需要
# 心跳IP为
# 节点1
10.10.10.80
# 节点2
10.10.10.81
二、 防火墙和selinux
systemctl status firewalld.service
systemctl stop firewalld.service
systemctl disable firewalld.service
echo "SELINUX=disabled" > /etc/selinux/config
echo "SELINUXTYPE=targeted" >> /etc/selinux/config
cat /etc/selinux/config
setenforce 0
三、修改资源限制
# 修改/etc/security/limits.conf在尾部追加
vim /etc/security/limits.conf
dmdba soft nice 0
dmdba hard nice 0
dmdba soft as unlimited
dmdba hard as unlimited
dmdba soft fsize unlimited
dmdba hard fsize unlimited
dmdba soft nproc 65536
dmdba hard nproc 65536
dmdba soft nofile 65536
dmdba hard nofile 65536
dmdba soft core unlimited
dmdba hard core unlimited
dmdba soft data unlimited
dmdba hard data unlimited
四、修改内核参数
# 麒麟v10
fs.file-max = 6815744
fs.aio-max-nr = 1048576
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
vm.dirty_ratio = 80
vm.dirty_expire_centisecs = 500
vm.dirty_writeback_centisecs = 100
vm.swappiness=10
vm.dirty_background_ratio = 0
vm.min_free_kbytes = 2097152
kernel.core_pattern = /dmdata/core.%p
# Oracle Linux 注意kernel.shmmax的值
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 2202144
net.core.rmem_max = 4194304
net.core.wmem_default = 2202144
net.core.wmem_max = 1048576
五、 创建用户及组
groupadd dinstall
useradd -g dinstall -m -d /home/dmdba -s /bin/bash dmdba
echo "pwd" |passwd --stdin dmdba
mkdir /dm/dmdbms -p
mkdir /dm/dmbak -p
mkdir /dm/dmarch -p
mkdir /dm/dmdata -p
chown dmdba:dinstall /dm -R
六、 环境变量
su - dmdba
vim ~/.bash_profile
export LANG=zh_CN.UTF8
export DM_INSTALL_TMPDIR=/tmp
export DM_HOME=/dm/dmdbms
export PATH=$DM_HOME/bin:$PATH:$HOME/bin
source ~/.bash_profile
七、实例化
# 节点1
cd $DM_HOME/bin
./dminit path=/dm/dmdata DB_NAME=RDDB INSTANCE_NAME=RDDB1 PORT_NUM=5136 EXTENT_SIZE=16 PAGE_SIZE=8 LOG_SIZE=1024 CASE_SENSITIVE=Y CHARSET=1 LENGTH_IN_CHAR=0 BLANK_PAD_MODE=0 SYSDBA_PWD="pwd" SYSAUDITOR_PWD="pwd" ELOG_PATH=/home/dmdba
# 节点2
cd $DM_HOME/bin
./dminit path=/dm/dmdata DB_NAME=RDDB INSTANCE_NAME=RDDB2 PORT_NUM=5136 EXTENT_SIZE=16 PAGE_SIZE=8 LOG_SIZE=1024 CASE_SENSITIVE=Y CHARSET=1 LENGTH_IN_CHAR=0 BLANK_PAD_MODE=0 SYSDBA_PWD="pwd" SYSAUDITOR_PWD="pwd" ELOG_PATH=/home/dmdba
八、启动数据库(前台)
# 节点1
cd $DM_HOME/bin
./dmserver /dm/dmdata/RDDB1/dm.ini
# 节点2
cd $DM_HOME/bin
./dmserver /dm/dmdata/RDDB2/dm.ini
# 成功启动后正常退出系统
九、注册服务
# 节点1
cd $DM_HOME/bin
./dm_service_installer.sh -t dmserver -dm_ini /dm/dmdata/RDDB1/dm.ini -p rddb1
# 节点2
cd $DM_HOME/bin
./dm_service_installer.sh -t dmserver -dm_ini /dm/dmdata/RDDB2/dm.ini -p rddb2
十、修改dm.ini参数
# 节点1
su - dmdba
vim /dm/dmdata/RDDB1/dm.ini
PORT_NUM = 5136
MAL_INI = 1
MPP_INI = 1
# 节点2
vim /dm/dmdata/RDDB2/dm.ini
PORT_NUM = 5136
MAL_INI = 1
MPP_INI = 1
十一、配置MAL参数
# 节点1
vim /dm/dmdata/rddb1/dmmal.ini
[MAL_INST1]
MAL_INST_NAME = RDDB1
MAL_HOST = 10.10.10.80
MAL_PORT = 5269
MAL_INST_HOST = 192.168.115.155
MAL_INST_PORT = 5136
[MAL_INST2]
MAL_INST_NAME = RDDB2
MAL_HOST = 10.10.10.81
MAL_PORT = 5269
MAL_INST_HOST = 192.168.115.156
MAL_INST_PORT = 5236
# 节点2
vim /dm/dmdata/rddb2/dmmal.ini
[MAL_INST1]
MAL_INST_NAME = RDDB1
MAL_HOST = 10.10.10.80
MAL_PORT = 5269
MAL_INST_HOST = 192.168.115.155
MAL_INST_PORT = 5136
[MAL_INST2]
MAL_INST_NAME = RDDB2
MAL_HOST = 10.10.10.81
MAL_PORT = 5269
MAL_INST_HOST = 192.168.115.156
MAL_INST_PORT = 5136
十二、mpp控制文件
# 节点1
vim /dm/dmdata/rddb1/dmmpp.ini
[SERVICE_NAME1]
MPP_SEQ_NO = 0
MPP_INST_NAME = RDDB1
[SERVICE_NAME2]
MPP_SEQ_NO = 1
MPP_INST_NAME = RDDB2
# 节点2
vim /dm/dmdata/rddb2/dmmpp.ini
[SERVICE_NAME1]
MPP_SEQ_NO = 0
MPP_INST_NAME = RDDB1
[SERVICE_NAME2]
MPP_SEQ_NO = 1
MPP_INST_NAME = RDDB2
十三、mpp控制文件转化
# 节点1
cd $DM_HOME/bin
./dmctlcvt type=2 SRC=/dm/dmdata/RDDB1/dmmpp.ini DEST=/dm/dmdata/RDDB1/dmmpp.ctl
# 节点2
./dmctlcvt type=2 SRC=/dm/dmdata/RDDB2/dmmpp.ini DEST=/dm/dmdata/RDDB2/dmmpp.ctl
十四、启动服务
# 节点1
systemctl start DmServicerddb1
# 节点2
systemctl start DmServicerddb2
十五、测试数据入库
create tablespace tbs_richard datafile 'richard01.dbf' size 256 autoextend off;
create user bgx identified by "Bgx123.com" default tablespace tbs_richard default index tablespace tbs_richard;
grant soi to bgx;
grant vti to bgx;
grant public to bgx;
grant resource to bgx;
create table bgx.base_veut_info (id int,name varchar(50),create_date date);
insert into bgx.base_veut_info values(1,'Richard','2022-04-01');
insert into bgx.base_veut_info values(15,'mongodb','2022-03-06');
insert into bgx.base_veut_info values(16,'redis','2022-03-07');
insert into bgx.base_veut_info values(17,'greenplum','2022-03-08');
insert into bgx.base_veut_info values(18,'postgresql','2022-03-09');
insert into bgx.base_veut_info values(19,'es','2022-05-01');
insert into bgx.base_veut_info values(20,'tidb','2022-05-02');
insert into bgx.base_veut_info values(21,'db2','2022-05-03');
insert into bgx.base_veut_info values(22,'sqlserver','2022-05-04');
insert into bgx.base_veut_info values(23,'etl','2022-05-05');
insert into bgx.base_veut_info values(24,'clickhouse','2022-05-06');
insert into bgx.base_veut_info values(25,'hadoop','2022-06-01');
insert into bgx.base_veut_info values(26,'hive','2022-06-02');
insert into bgx.base_veut_info values(27,'hbase','2022-06-03');
insert into bgx.base_veut_info values(28,'bigdata','2022-06-04');
insert into bgx.base_veut_info values(29,'nbu','2022-06-05');
insert into bgx.base_veut_info values(30,'linux','2022-06-06');
commit;
总结
例如:以上就是今天要讲的内容,本文仅仅简单介绍了达梦MPP的部署和使用,想更深入学习达梦MPP请参考https://eco.dameng.com/。