openGauss一主八备安装过程

环境准备（所有节点操作）

环境说明

安装依赖包

#配置本地yum源
mount /dev/cdrom /mnt
cd /etc/yum.repos.d
mkdir bk
mv *.repo bk/
echo "[CentOS]" >> /etc/yum.repos.d/test.repo
echo "name =CentOS 7.x DVD" >> /etc/yum.repos.d/test.repo
echo "baseurl=file:///mnt" >> /etc/yum.repos.d/test.repo
echo "gpgcheck=0" >> /etc/yum.repos.d/test.repo
echo "enabled=1" >> /etc/yum.repos.d/test.repo
cat /etc/yum.repos.d/test.repo

#更新软件包缓存
yum makecache


#安装依赖包
yum install -y libaio-devel
yum install -y flex
yum install -y bison
yum install -y ncurses-devel
yum install -y glibc-devel
yum install -y patch
yum install -y redhat-lsb-core
yum install -y readline-devel
yum install -y python3
#采用交互式预安装的时候需要安装expect包
yum install -y expect


检查依赖包安装情况

rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' libaio-devel flex bison ncurses-devel glibc-devel patch redhat-lsb-core readline-devel python3 expect


修改操作系统配置

修改 hosts 文件

echo '***.***.***.***00 primary' >> /etc/hosts
echo '***.***.***.***01 standby1' >> /etc/hosts
echo '***.***.***.***02 standby2' >> /etc/hosts
echo '***.***.***.***03 standby3' >> /etc/hosts
echo '***.***.***.***04 standby4' >> /etc/hosts
echo '***.***.***.***05 standby5' >> /etc/hosts
echo '***.***.***.***06 standby6' >> /etc/hosts
echo '***.***.***.***07 standby7' >> /etc/hosts
echo '***.***.***.***08 standby8' >> /etc/hosts


修改 SELINUX 值

vim /etc/selinux/config
SELINUX=disabled
#sed -i 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/selinux/config


关闭防火墙：

systemctl status firewalld
systemctl disable firewalld.service
systemctl stop firewalld.service
reboot


设置字符集参数

#将各数据库节点的字符集设置为相同的字符集，可以在/etc/profile文件中添加“export LANG=XXX”（XXX为Unicode编码）。
echo 'export LANG=en_US.UTF8' >> /etc/profile
#echo 'export LANG=zh_CN.UTF8' >> /etc/profile
source /etc/profile


拷贝时区文件

#cp /usr/share/zoneinfo/$地区/$时区 /etc/localtime
cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime


检查各数据库节点时间和时区是否一致

date
#如果不一致使用如下命令模板修改
date -s "Sat Sep 27 16:00:07 CST 2020"


可选）关闭 swap 交换内存

swapoff -a


关闭 RemoveIPC。CentOS 操作系统默认为关闭，可以跳过该步骤。

#1.修改/etc/systemd/logind.conf文件中的“RemoveIPC”值为“no”。
a.使用VIM打开logind.conf文件。
vim /etc/systemd/logind.conf
b.修改“RemoveIPC”的值“no”。
RemoveIPC=no
#2.修改/usr/lib/systemd/system/systemd-logind.service文件中的“RemoveIPC”值为“no”。
a.使用VIM打开systemd-logind.service文件。
vim /usr/lib/systemd/system/systemd-logind.service
b.修改“RemoveIPC”的值“no”。
RemoveIPC=no
#3.重新加载配置参数。
systemctl daemon-reload
systemctl restart systemd-logind
#4.检查修改是否生效。
loginctl show-session | grep RemoveIPC
systemctl show systemd-logind | grep RemoveIPC


设置网卡 MTU 值，将各数据库节点的网卡 MTU 值设置为相同大小。

ifconfig
#使用如下命令将各数据库节点的网卡MTU值设置为相同大小。对于X86，MTU值推荐1500；对于ARM，MTU值推荐8192。
#ifconfig 网卡名称 mtu mtu值


关闭 HISTORY 记录，为避免指令历史记录安全隐患，需关闭各主机的 history 指令。

vim /etc/profile
HISTSIZE=0
#sed -i 's/HISTSIZE=1000/HISTSIZE=0/g' /etc/profile
cat /etc/profile|grep HISTSIZE
source /etc/profile


设置 root 用户远程登录

修改 PermitRootLogin 配置，允许用户远程登录。

vim /etc/ssh/sshd_config
#PermitRootLogin no
OR：
PermitRootLogin yes

cat /etc/ssh/sshd_config|grep PermitRootLogin


修改 Banner 配置，去掉连接到系统时，系统提示的欢迎信息。欢迎信息会干扰安装时远程操作的返回结果，影响安装正常执行。

vim /etc/ssh/sshd_config
#Banner XXXX

cat /etc/ssh/sshd_config|grep Banner


使设置生效

systemctl restart sshd.service


安装 openGauss

创建 XML 配置文件

vim /tmp/8standby.xml

检查 xml 文件里面的端口是否被占用

lsof -i:15400
lsof -i:15000


下载解压软件包

mkdir -p /software/unzip
cd /software
wget https://opengauss.obs.cn-south-1.myhuaweicloud.com/3.1.0/x86/openGauss-3.1.0-CentOS-64bit-all.tar.gz
cd unzip
tar -zxvf ../openGauss-3.1.0-CentOS-64bit-all.tar.gz
tar -zxvf openGauss-3.1.0-CentOS-64bit-om.tar.gz


初始化安装环境

创建用户和组（主节点操作即可）

groupadd dbgrp
useradd -g dbgrp -d /home/omm -m -s /bin/bash omm
echo ****@***|passwd --stdin omm


预安装

cd /software/unzip/script/
./gs_preinstall -U omm -G dbgrp -X /tmp/8standby.xml --sep-env-file=/home/omm/env

#预安装完整流程
[root@primary script]# ./gs_preinstall -U omm -G dbgrp -X /tmp/8standby.xml --sep-env-file=/home/omm/env
Parsing the configuration file.
Successfully parsed the configuration file.
Installing the tools on the local node.
Successfully installed the tools on the local node.
Are you sure you want to create trust for root (yes/no)?yes
Please enter password for root
Password:
Successfully created SSH trust for the root permission user.
Setting host ip env
Successfully set host ip env.
Distributing package.
Begin to distribute package to tool path.
Successfully distribute package to tool path.
Begin to distribute package to package path.
Successfully distribute package to package path.
Successfully distributed package.
Are you sure you want to create the user[omm] and create trust for it (yes/no)? yes
Preparing SSH service.
Successfully prepared SSH service.
Installing the tools in the cluster.
Successfully installed the tools in the cluster.
Checking hostname mapping.
Successfully checked hostname mapping.
Creating SSH trust for [omm] user.
Please enter password for current user[omm].
Password:
Checking network information.
All nodes in the network are Normal.
Successfully checked network information.
Creating SSH trust.
Creating the local key file.
Successfully created the local key files.
Appending local ID to authorized_keys.
Successfully appended local ID to authorized_keys.
Updating the known_hosts file.
Successfully updated the known_hosts file.
Appending authorized_key on the remote node.
Successfully appended authorized_key on all remote node.
Checking common authentication file content.
Successfully checked common authentication content.
Distributing SSH trust file to all node.
Distributing trust keys file to all node successfully.
Successfully distributed SSH trust file to all node.
Verifying SSH trust on all hosts.
Successfully verified SSH trust on all hosts.
Successfully created SSH trust.
Successfully created SSH trust for [omm] user.
Checking OS software.
Successfully check os software.
Checking OS version.
Successfully checked OS version.
Creating cluster's path.
Successfully created cluster's path.
Set and check OS parameter.
Setting OS parameters.
Successfully set OS parameters.
Warning: Installation environment contains some warning messages.
Please get more details by "/software/unzip/script/gs_checkos -i A -h primary,standby1,standby2,standby3,standby4,standby5,standby6,standby7,standby8 --detail".
Set and check OS parameter completed.
Preparing CRON service.
Successfully prepared CRON service.
Setting user environmental variables.
Successfully set user environmental variables.
Setting the dynamic link library.
Successfully set the dynamic link library.
Setting Core file
Successfully set core path.
Setting pssh path
Successfully set pssh path.
Setting Cgroup.
Successfully set Cgroup.
Set ARM Optimization.
No need to set ARM Optimization.
Fixing server package owner.
Setting finish flag.
Successfully set finish flag.
Preinstallation succeeded.
[root@primary script]#


安装

su - omm
source /home/omm/env
gs_install -X /tmp/8standby.xml

Successfully installed application.
end deploy..
[omm@primary ~]$


安装后配置

su - omm
source /home/omm/env
#gsql终端设置
cd
cat >.gsqlrc