测试环境
**操作系统版本：**openEuler-22.03-LTS-SP2-x86_64
硬件配置： 4c/8G/40GB
节点信息： [主节点] 172.20.XX.101
[备节点] 172.20.XX.102
[级联备] 172.20.XX.103
操作步骤
1. 从openGauss开源社区下载对应平台的安装包。
a.通过https://opengauss.org/zh/download/登录openGauss开源社区，选择对应平台的企业版安装包。
b.单击“下载”。
2. 检查安装包。
主节点解压安装包，检查安装目录及文件是否齐全。在安装包所在目录执行以下命令：
tar -zxvf openGauss-x.x.x-openEuler-64bit-all.tar.gz
ls -lb
执行ls命令，显示类似如下信息：
total 91M
-rw-r–r-- 1 root root 65 Dec 25 11:03 openGauss-x.x.x-openEuler-64bit-om.sha256
-rw-r–r-- 1 root root 12910775 Dec 25 11:03 openGauss-x.x.x-openEuler-64bit-om.tar.gz
-rw-r–r-- 1 root root 13474 Dec 25 11:03 upgrade_sql.tar.gz
-rw-r–r-- 1 root root 65 Dec 25 11:03 upgrade_sql.sha256
-rw-r–r-- 1 root root 65 Dec 25 11:03 openGauss-x.x.x-openEuler-64bit.sha256
-rw-r–r-- 1 root root 73334256 Dec 25 11:03 openGauss-x.x.x-openEuler-64bit.tar.bz2
opengauss 5.1.0企业版安装指南
https://docs-opengauss.osinfra.cn/zh/docs/5.1.0/docs/InstallationGuide/%E4%BC%81%E4%B8%9A%E7%89%88%E5%AE%89%E8%A3%85.html
一、所有服务器运行环境初始化
示例脚本如下[仅供参考]：
vi /root/initenv.sh
-------------------------------------------------------------------------------------------
#!/bin/bash#_# 1.__关闭_ _firewalld service_
systemctl disable firewalld.service
systemctl stop firewalld.service
echo "Firewalld " `systemctl status firewalld|grep Active`
echo "1.Disable firewalld service completed."
echo -e "\n"
## 2. 关闭SELINUX
sed -i '/^SELINUX=/d' /etc/selinux/config
echo "SELINUX=disabled" >> /etc/selinux/config
cat /etc/selinux/config|grep "SELINUX=disabled"
echo "2.Disable SELINUX completed."
echo -e "\n"
## 3.配置Configure encoding
echo "LANG=en_US.UTF-8" >> /etc/profile
source /etc/profile
echo $LANG
echo "3.Configure encoding completed."
echo -e "\n"
## 4. 配置Configure Timezone
rm -fr /etc/localtime
ln -s /usr/share/zoneinfo/Asia/Shanghai /etc/localtime
date -R
hwclock
echo "4.Configure Timezone completed."
echo -e "\n"
## 5. 关闭 SWAP分区
sed -i '/swap/s/^/#/' /etc/fstab
swapoff -a
free -m
echo "5.Close swap partition completed."
echo -e "\n"
## 6. 配置 SSH Service
sed -i '/Banner/s/^/#/' /etc/ssh/sshd_config
sed -i '/PermitRootLogin/s/^/#/' /etc/ssh/sshd_config
echo -e "\n" /etc/ssh/sshd_config
echo "Banner none " >> /etc/ssh/sshd_config
echo "PermitRootLogin yes" >> /etc/ssh/sshd_config
cat /etc/ssh/sshd_config |grep -v ^#|grep -E 'PermitRoot|Banner'
echo "6.Configure SSH Service completed."
echo -e "\n"
## 7. 安装依赖包（上网安装也可以配置本地）
mkdir /etc/yum.repos.d/bak
mv /etc/yum.repos.d/*.repo /etc/yum.repos.d/bak/
wget -O /etc/yum.repos.d/CentOS-Base.repo https://repo.huaweicloud.com/repository/conf/openeuler_x86_64.repo
yum clean all
yum install -y bzip2 python3 expect tar ##需要安装expect包否则会报错
yum install -y libaio-devel flex bison ncurses-devel glibc-devel patch redhat-lsb-core readline-devel
echo "7.Configure YUM and Install Packages completed."
echo -e "\n"
## 8. Close transparent_hugepage openeuler不需要配置
################Only for CentOS [Close transparent_hugepage]#####################
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
chmod +x /etc/rc.d/rc.local
echo "8.Close transparent_hugepage completed."
echo -e "\n"
################################################################################
## 9. 配置操作系统参数 Parameter
cat /etc/sysctl.conf <<EOF
net.ipv4.tcp_retries1 = 5
net.ipv4.tcp_syn_retries = 5
net.sctp.path_max_retrans = 10
net.sctp.max_init_retransmits = 10
EOF
sysctl -p
################Only for openEuler[Disable RemoveIPC]#####################
sed -i '/^RemoveIPC/d' /etc/systemd/logind.conf
sed -i '/^RemoveIPC/d' /usr/lib/systemd/system/systemd-logind.service
echo "RemoveIPC=no"
>>
echo “RemoveIPC=no” >> _ /usr/lib/systemd/system/systemd-logind.service_
systemctl daemon-reload
systemctl restart systemd-logind
loginctl show-session | grep RemoveIPC
systemctl show systemd-logind | grep RemoveIPC
echo “10.Disable RemoveIPC completed.”
echo -e “\n”
echo -e “\n”
##########################################################################
-------------------------------------------------------------------------------------------
sh /root/initenv.sh ##
步骤 1 修改根目录下/etc/profile文件。
vim /etc/profile
步骤 2 设置HISTSIZE值为0。例如，系统中HISTSIZE默认值为1000，将其修改为0。
HISTSIZE=0
步骤 3 保存/etc/profile。
:wq
步骤 4 设置/etc/profile生效。
source /etc/profile
二、一主一备一级联配置
1、配置XML文件
# mkdir –p /opt/software/openGauss
chmod 755 -R /opt/software
# vi /opt/software/openGauss/cluster_config.xml
-----------------------------------------------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<ROOT>
<!-- openGauss
<CLUSTER>
<PARAM name="clusterName" value="Cluster_template" />
<PARAM name="nodeNames" value="opengaussdb1,opengaussdb2,opengaussdb3" />
<PARAM name="gaussdbAppPath" value="/opt/huawei/install/app" />
<PARAM name="gaussdbLogPath" value="/var/log/omm" />
<PARAM name="tmpMppdbPath" value="/opt/huawei/tmp"/>
<PARAM name="gaussdbToolPath" value="/opt/huawei/install/om" />
<PARAM name="corePath" value="/opt/huawei/corefile"/>
<PARAM name="backIp1s" value="172.20.XX.101,172.20.XX.102,172.20.XX.103"/>
</CLUSTER>
<!-- 每台服务器上的节点部署信息 -->
<DEVICELIST>
<!-- node1上的节点部署信息-->
<DEVICE sn="opengaussdb1">
<PARAM name="name" value="opengaussdb1"/>
<PARAM name="azName" value="AZ1"/>
<PARAM name="azPriority" value="1"/>
<!-- 如果服务器只有一个网卡可用，将backIP1和sshIP1配置成同一个IP -->
<PARAM name="backIp1" value="172.20.XX.101"/>
<PARAM name="sshIp1" value="172.20.XX.101"/>
<!-- cm主-->
<PARAM name="cmsNum" value="1"/>
<PARAM name="cmDir" value="/opt/huawei/install/cm"/>
<PARAM name="cmServerPortBase" value="15300"/>
<PARAM name="cmServerListenIp1" value="172.20.XX.101,172.20.XX.102,172.20.XX.103"/>
<PARAM name="cmServerHaIp1" value="172.20.XX.101,172.20.XX.102,172.20.XX.103"/>
<!-- cmServerlevel目前只支持1 -->
<PARAM name="cmServerlevel" value="1"/>
<!-- cms主及所有备的hostname -->
<PARAM name="cmServerRelation" value="opengaussdb1,opengaussdb2,opengaussdb3"/>
<!--dn-->
<PARAM name="dataNum" value="1"/>
<PARAM name="dataPortBase" value="26000"/>
<PARAM name="dataNode1" value="/opt/huawei/install/data/dn,opengaussdb2,/opt/huawei/install/data/dn,opengaussdb3,/opt/huawei/install/data/dn"/>
<PARAM name="dataNode1_syncNum" value="0"/>
</DEVICE>
<!-- node2上的节点部署信息，其中“name”的值配置为主机名称-->
<DEVICE sn="opengaussdb2">
<PARAM name="name" value="opengaussdb2"/>
<PARAM name="azName" value="AZ1"/>
<PARAM name="azPriority" value="1"/>
<!-- 如果服务器只有一个网卡可用，将backIP1和sshIP1配置成同一个IP -->
<PARAM name="backIp1" value="172.20.XX.102"/>
<PARAM name="sshIp1" value="172.20.XX.102"/>
<!-- cm -->
<PARAM name="cmDir" value="/opt/huawei/install/cm"/>
<PARAM name="cmServerPortStandby" value="15300"/>
</DEVICE>
<!-- node3上的节点部署信息，其中“name”的值配置为主机名称 -->
<DEVICE sn="opengaussdb3">
<PARAM name="name" value="opengaussdb3"/>
<PARAM name="azName" value="AZ1"/>
<PARAM name="azPriority" value="1"/>
<!-- 如果服务器只有一个网卡可用，将backIP1和sshIP1配置成同一个IP -->
<PARAM name="backIp1" value="172.20.XX.103"/>
<PARAM name="sshIp1" value="172.20.XX.103"/>
<PARAM name="cascadeRole" value="on"/>
<!-- cm -->
<PARAM name="cmDir" value="/opt/huawei/install/cm"/>
<PARAM name="cmServerPortStandby" value="15300"/>
</DEVICE>
</DEVICELIST>
</ROOT>-----------------------------------------------------------------------------
2、一执行预安装gs_preinstall
1. 解压软件包
主节点操作
cd /opt/software/openGauss
tar -zxvf openGauss-2.0.0-CentOS-64bit-all.tar.gz
tar -zxvf openGauss-2.0.0-CentOS-64bit-om.tar.gz
tar -jxf openGauss-x.x.x-openEuler-64bit.tar.bz2 -C /opt/software/openGauss
tar -zxvf openGauss-5.1.0-openEuler-64bit-cm.tar.gz
groupadd dbgrp
useradd -g dbgrp -m omm -d /home/omm ##应该不用提前创建用户，官网手册也没有提前创建
echo “XX” |passwd --stdin omm
chown –R omm:dbgrp /opt
2. 执行预安装
[root@prod ~]# cd /opt/software/openGauss/script
[root@opengaussdb1 script]# python3 gs_preinstall -U omm -G dbgrp -X /opt/software/openGauss/cluster_config_template.xml
---------------------------------------------------------------------------------------------
– 根据输出提示，使用gs_checkos工具检查操作预安装结果
[root@opengaussdb1 script]# /opt/software/openGauss/script/gs_checkos -i A -h opengaussdb1,opengaussdb2,opengaussdb3 --detail
三、执行安装gs_install
[root@prod ~]# su – omm
[omm@opengaussdb1 ~]$ gs_install -X /opt/software/openGauss/cluster_config_template.xml
注：[GAUSS-51806] : The cluster has been installed.
执行vi ~/.bashrc查看环境变量，将GAUSS_ENV=2改为GAUSS_ENV=1，重新执行安装命令即可。
四、检查主备信息
## 查询集群健康状态
[omm@opengaussdb1 ~]$ gs_om -t status
-----------------------------------------------------------------------
cluster_state : Normal
redistributing : No
balanced : Yes
-----------------------------------------------------------------------
## 查询主备同步信息
[omm@opengaussdb1 ~]$ gs_ctl query -D /opt/huawei/install/data/dn
[2023-12-15 15:45:57.577][138274][][gs_ctl]: gs_ctl query ,datadir is /opt/huawei/install/data/dn
HA state:
local_role : Primary
static_connections : 2
db_state : Normal
detail_information : Normal
Senders info:
sender_pid : 135221
local_role : Primary
peer_role : Standby
peer_state : Normal
state : Streaming
sender_sent_location : 0/5000308
sender_write_location : 0/5000308
sender_flush_location : 0/5000308
sender_replay_location : 0/5000308
receiver_received_location : 0/5000308
receiver_write_location : 0/5000308
receiver_flush_location : 0/5000308
receiver_replay_location : 0/5000308
sync_percent : 100%
sync_state : Quorum
sync_priority : 1
sync_most_available : Off
channel : 172.20.XX.101:26001-->172.20.XX.102:55552
Receiver info:
No information
## 查询集群节点配置信息
[omm@opengaussdb1 ~]$ gs_om -t view
NodeHeader:
version:301
time:1702626147
nodeCount:3
node:1
============================================================
azName:AZ1
azPriority:1
node :1
nodeName:opengaussdb1
ssh channel :
sshChannel 1:172.20.XX.101
datanodeCount :1
datanodeInstanceType :primary
datanode 1:
datanodeLocalDataPath :/opt/huawei/install/data/dn
datanodeXlogPath :
datanodeListenIP 1:172.20.XX.101
datanodePort :26000
datanodeLocalHAIP 1:172.20.XX.101
datanodeLocalHAPort :26001
dn_replication_num: 3
datanodePeer0DataPath :/opt/huawei/install/data/dn
datanodePeer0HAIP 1:172.20.XX.102
datanodePeer0HAPort :26001
datanodePeer1DataPath :/opt/huawei/install/data/dn
datanodePeer1HAIP 1:172.20.XX.103
datanodePeer1HAPort :26001
============================================================
azName:AZ1
azPriority:1
node :2
nodeName:opengaussdb2
ssh channel :
sshChannel 1:172.20.XX.102
datanodeCount :1
datanodeInstanceType :standby
datanode 1:
datanodeLocalDataPath :/opt/huawei/install/data/dn
datanodeXlogPath :
datanodeListenIP 1:172.20.XX.102
datanodePort :26000
datanodeLocalHAIP 1:172.20.XX.102
datanodeLocalHAPort :26001
dn_replication_num: 3
datanodePeer0DataPath :/opt/huawei/install/data/dn
datanodePeer0HAIP 1:172.20.XX.101
datanodePeer0HAPort :26001
datanodePeer1DataPath :/opt/huawei/install/data/dn
datanodePeer1HAIP 1:172.20.XX.103
datanodePeer1HAPort :26001
============================================================
azName:AZ1
azPriority:1
node :3
nodeName:opengaussdb3
ssh channel :
sshChannel 1:172.20.XX.103
datanodeCount :1
datanodeInstanceType :cascade_standby
datanode 1:
datanodeLocalDataPath :/opt/huawei/install/data/dn
datanodeXlogPath :
datanodeListenIP 1:172.20.XX.103
datanodePort :26000
datanodeLocalHAIP 1:172.20.XX.103
datanodeLocalHAPort :26001
dn_replication_num: 3
datanodePeer0DataPath :/opt/huawei/install/data/dn
datanodePeer0HAIP 1:172.20.XX.101
datanodePeer0HAPort :26001
datanodePeer1DataPath :/opt/huawei/install/data/dn
datanodePeer1HAIP 1:172.20.XX.102
datanodePeer1HAPort :26001
============================================================最后修改时间：2023-12-18 14:17:45
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
