PanweiDB分布式数据库安装（PanWeiDB_V2.0_dist）

1. 安装准备工作 

1.1. 配置本地YUM源

mount -t auto /dev/cdrom  /mnt

rm -rf /etc/yum.repos.d/
mkdir -p /etc/yum.repos.d/
cat >> /etc/yum.repos.d/CentOS-Media.repo<<EOF
# CentOS-Media.repo
#
#  This repo can be used with mounted DVD media, verify the mount point for
#  CentOS-7.  You can use this repo and yum to install items directly off the
#  DVD ISO that we release.
#
# To use this repo, put in your DVD and use it with the other repos too:
#  yum --enablerepo=c7-media [command]
#  
# or for ONLY the media repo, do this:
#
#  yum --disablerepo=\* --enablerepo=c7-media [command]

[c7-media]
name=CentOS-$releasever - Media
baseurl=file:///mnt/
gpgcheck=0
enabled=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7
EOF


yum clean all
yum makecache

1.2. 安装rpm依赖包

yum install -y bison flex patch bzip2 ntp

1.3. 检查是否支持 rdtscp 指令集

cat /proc/cpuinfo | grep rdtscp

1.4. sysctl配置

cat>>/etc/sysctl.conf<<EOF
kernel.sem = 40960 2048000 40960 20480
EOF

1.5. 配置RemoveIPC配置

echo -e "\nRemoveIPC=yes" | sudo tee -a /etc/systemd/logind.conf

1.6. 关闭防火墙与selinux

systemctl status firewalld
systemctl stop firewalld
systemctl disable firewalld
sed -i 's/=enforcing/=disabled/g'  /etc/selinux/config
setenforce 0
Getenforce

1.7. 关闭透明大页

cat >> /etc/rc.d/rc.local<<EOF
if test -f /sys/kernel/mm/transparent_hugepage/enabled;
then
echo never > /sys/kernel/mm/transparent_hugepage/enabled
fi
if test -f /sys/kernel/mm/transparent_hugepage/defrag;
then
echo never > /sys/kernel/mm/transparent_hugepage/defrag
fi
EOF

1.8. 数据盘配置

vgcreate datavg /dev/sdb
lvcreate -l 99%VG -n pwlv datavg
mkfs.xfs  /dev/datavg/pwlv  
Dump2fs -h /dev/datavg/pwlv|grep inode
cat>>/etc/fstab<<EOF
/dev/datavg/pwlv /omm                       xfs     defaults        0 0
EOF
mount /omm

查看i2node
df -i
可通过如下命令动态扩容inode
 xfs_growfs -m 25 /dev/mapper/datavg-pwlv
 xfs_info /dev/mapper/datavg-pwlv |grep imax

mkdir -p /omm/data/gtm/gtm1
mkdir -p /omm/data/gtm/gtm2
mkdir -p /omm/data/coord/cn1
mkdir -p /omm/data/coord/cn2
mkdir -p /omm/data/dn1/dn1_1
mkdir -p /omm/data/dn1/dn1_2
mkdir -p /omm/data/dn1/dn1_3
mkdir -p /omm/data/dn2/dn2_1
mkdir -p /omm/data/dn2/dn2_2
mkdir -p /omm/data/dn2/dn2_3
mkdir -p /omm/omm_package
mkdir -p /omm/omm_db
chown -R omm:dbgrp  /omm

# 创建swap文件为20GB
dd if=/dev/zero of=swapfile bs=1M count=28672
# 标记为swap空间
mkswap /root/swapfile
# 设置文件权限
chmod -R 0600 /root/swapfile
# 激活swap文件
swapon /root/swapfile
echo "/root/swapfile  swap swap defaults 0 0" >> /etc/fstab

放置安装包/omm/omm_package
tar -xvf PanWeiDB_V2.0_dist_S3.1.0_B02_x86_64.tar.gz
tar -xvf PanWeiDB_V2.0_dist_S3.1.0_B02_x86_64_om.tar.gz

1.9. 创建用户 

groupadd dbgrp 
useradd -m -d /omm omm -g dbgrp 
passwd omm

1.10. 配置主机名 

hostnamectl set-hostname pwhost16
hostnamectl set-hostname pwhost17
hostnamectl set-hostname pwhost18

1.11. 配置互信

cd /omm/omm_package/script/ 
./ha_preinstall -s --add-user --add-trust --root-passwd='root' --set-user-passwd='omm' -h 192.168.1.