达梦数据库单机安装配置
1.达梦数据库项目实战环境准备
物理主机:16G/32内存
CPU:8线程
硬盘500G
虚拟机环境:VMware Workstation 15.5
虚拟机网卡:192.168.1.120
2.Linux环境准备(1台)
主机名:dmdb01
CPU:1CPU 2核
内存:4G
硬盘:100G、101G、102G、103G、104G
安装包:rhel-server-7.6-x86_64-dvd.iso
网卡:桥接模式 192.168.1.101
3.准备磁盘与分区比(规范)
创建LVM磁盘格式
pvcreate /dev/sdb /dev/sdc /dev/sdd /dev/sde
vgcreate dmappvg /dev/sdb
vgcreate dmdatavg /dev/sdc
vgcreate dmlogvg /dev/sdd
vgcreate dmbakvg /dev/sde
lvcreate -n dmapplv -L 99G dmappvg
lvcreate -n dmdatalv -L 100G dmdatavg
lvcreate -n dmloglv -L 100G dmlogvg
lvcreate -n dmbaklv -L 100G dmbakvg
mkfs.xfs /dev/dmappvg/dmapplv
mkfs.xfs /dev/dmdatavg/dmdatalv
mkfs.xfs /dev/dmlogvg/dmloglv
mkfs.xfs /dev/dmbakvg/dmbaklv
mkdir -p /dm/dmdbms
mkdir -p /dm/dmdata
mkdir -p /dm/dmarch
mkdir -p /dm/dmback
mount /dev/dmappvg/dmapplv /dm/dmdbms
mount /dev/dmdatavg/dmdatalv /dm/dmdata
mount /dev/dmlogvg/dmloglv /dm/dmarch
mount /dev/dmbakvg/dmbaklv /dm/dmback
vi /etc/fstab
/dev/dmappvg/dmapplv /dm/dmdbms xfs defaults 0 0
/dev/dmdatavg/dmdatalv /dm/dmdata xfs defaults 0 0
/dev/dmlogvg/dmloglv /dm/dmarch xfs defaults 0 0
/dev/dmbakvg/dmbaklv /dm/dmback xfs defaults 0 0
4.操作系统环境配置
4.1.配置hosts文件
echo “192.168.1.100 dmdb01” >> /etc/hosts
4.2.配置语言环境
echo “export LANG=en_US.UTF8” >> ~/.bash_profile
4.3.修改资源限制参数
vi /etc/security/limits.conf
dmdba soft nproc 65536
dmdba hard nproc 65536
dmdba soft nofile 65536
dmdba hard nofile 65536
dmdba soft stack 65536
dmdba hard stack 65536
echo “* - nproc 65536” > /etc/security/limits.d/90-nproc.conf
4.4.设置系统安全策略
echo “SELINUX=disabled” > /etc/selinux/config
echo “SELINUXTYPE=targeted” >> /etc/selinux/config
setenforce 0
4.5.关闭防火墙
systemctl status firewalld.service
systemctl stop firewalld.service
systemctl disable firewalld.service
关闭防火墙视情况关闭或开放端口(默认5236)
4.6.控制资源分配限制
echo “session required pam_limits.so” >> /etc/pam.d/login
cat /etc/pam.d/login
4.7.关闭透明大页、numa
vi /etc/default/grub
GRUB_CMDLINE_LINUX=“crashkernel=auto rhgb quiet numa=off transparent_hugepage=never elevator=deadline”
grub2-mkconfig -o /etc/grub2.cfg
4.8.磁盘调度算法
方法(官方推荐)
vi /etc/default/grub
GRUB_CMDLINE_LINUX=“crashkernel=auto rhgb quiet numa=off transparent_hugepage=never elevator=deadline”
4.9.修改内核参数
vi /etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
net.ipv4.ip_local_port_range = 1024 65535
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
vm.overcommit_memory=0
vm.swappiness=1
vm.min_free_kbytes=51200 --测试环境
sysctl -p
4.9.创建用户
groupadd -g 66000 dinstall
useradd -u 66000 -g dinstall -m -d /home/dmdba -s /bin/bash dmdba
echo “dameng” | passwd --stdin dmdba
mkdir -p /dm/dmdbms/dm8
chown -R dmdba:dinstall /dm
chmod -R 775 /dm
4.10.配置dmdba用户环境变量
vi ~/.bash_profile
export LANG=zh_CN.UTF8
export DM_INSTALL_TMPDIR=/tmp
export DM_HOME=/dm/dmdbms/dm8
export PATH=
D
M
H
O
M
E
/
b
i
n
:
DM_HOME/bin:
DMHOME/bin:PATH:$HOME/bin
source ~/.bash_profile
5.达梦数据库安装配置(Linux+DM)
达梦数据库安装前规划
服务器名:dmdb01
操作系统:RHEL 7.6
软件名称:达梦8数据库
IP地址:192.168.1.100
时区:+0800
内存:4G
OS用户名/密码:root/rootroot,dmdba/dmdba
系统组:dinstall
数据库ID:dameng
数据库名称:dameng
归档文件:无
数据库版本:DM Database Server x64 V8
DM_HOME目录:/dm/dmdbms/dm8
数据文件路径:/dm/dmdata
数据库监听端口:5236
数据库字符集:GB18030
数据库用户:sysdba/dameng123
页大小:32k
日志组:2个512M(生产环境3个2G)
6.达梦数据库安装配置(命令行)
6.1命令行安装:
切换到dmdba用户开始安装
cd /mnt
./DMInstall.bin -i
c
n
y
21
1
/dm/dmdbms/dm8
y
y
使用root用户执行脚本(/dm/dmdbms/dm8/script/root/root_installer.sh)
6.2.达梦数据库实例创建
切换到dmdba用户
cd /dm/dmdbms/dm8/bin
./dminit path=/dm/dmdata db_name=dmmeng instance_name=dameng port_num=5236 LOG_SIZE=512 SYSDBA_PWD=dameng123 EXTENT_SIZE=32 PAGE_SIZE=32
6.3.注册系统服务:
切换到root用户
cd /dm/dmdbms/dm8/script/root
./dm_service_installer.sh -t dmserver -p dameng -dm_ini /dm/dmdata/dameng/dm.ini
6.4.启动数据库服务
切换到root用户
systemctl enable DmServicedameng.service
systemctl start DmServicedameng.service
systemctl stop DmServicedameng.service
6.5测试连接数据库
切换到dmdba用户
disql sysdba/ dameng123
select * from v
d
a
t
a
f
i
l
e
;
s
e
l
e
c
t
n
a
m
e
,
s
t
a
t
u
s
datafile; select name,status
datafile;selectname,status from v
d
a
t
a
b
a
s
e
;
s
e
l
e
c
t
∗
f
r
o
m
v
database; select * from v
database;select∗fromvversion;
6.6.卸载数据库
切换到root用户
cd /dm/dmdbms/dm8/script/root
./dm_service_uninstaller.sh -n DmServicedameng
y
rm -rf /dm/dmdata/dameng
cd /dm/dmdbms/dm8
./uninstall.sh -i
y
y
rm -rf /dm/dmdbms/dm8/*
欢迎进入达梦社区
https://eco.dameng.com