openGauss5.1.0企业版单机安装（opengauss初学编）

测试环境

操作系统版本：openEuler-22.03-LTS-SP2-x86_64

硬件配置：          4c/8G/40GB         

节点信息：    [主节点]  172.20.XX.101

                [备节点] 

                [级联备] 

操作步骤

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"

## optional options,please take care of this

## echo "MTU=8192"   /etc/sysconfig/network-scripts/ifcfg-ens34

## For 10GB Ethernet environment , please set rx = 4096、tx = 4096

## 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. 安装依赖包（上网安装也可以配置本地yum）

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

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" >>   /etc/systemd/logind.conf

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    ## 执行初始化脚本[SCTP内核参数告警可以忽略]

关闭HISTORY记录（可以不关闭）

步骤 1 修改根目录下/etc/profile文件。

vim /etc/profile

步骤 2 设置HISTSIZE值为0。例如，系统中HISTSIZE默认值为1000，将其修改为0。

HISTSIZE=0

步骤 3 保存/etc/profile。

:wq

步骤 4 设置/etc/profile生效。

source /etc/profile

二、单机安装

mkdir –p  /opt/software/openGauss

chmod 755 -R /opt/software

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 omm

echo "Hyjc@2022" |passwd --stdin omm

设置lib库

export LD_LIBRARY_PATH=/opt/software/openGauss/script/gspylib/clib:$LD_LIBRARY_PATH

chown –R omm:dbgrp /opt/software/openGauss

安装openGauss前需要创建cluster_config.xml文件。cluster_config.xml文件包含部署openGauss的服务器信息、安装路径、IP地址以及端口号等。用于告知openGauss如何部署。用户需根据不同场景配置对应的XML文件。

如果是openEuler的操作系统（openEuler 20.03），执行如下命令打开performance.sh文件，用#注释sysctl -w vm.min_free_kbytes=112640 &> /dev/null，键入“ESC”键进入指令模式，执行 :wq 保存并退出修改。

vi /etc/profile.d/performance.sh

vi  /opt/software/openGauss/cluster_config_template.xml

<?xml version="1.0" encoding="utf-8"?>

<ROOT>

  <CLUSTER>

    <PARAM name="clusterName" value="Cluster_template" />

    <PARAM name="nodeNames" value="opengaussdb1"/>

    <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"/>

  </CLUSTER>

  <DEVICELIST>

    <DEVICE sn="opengaussdb1">

      <PARAM name="name" value="opengaussdb1"/>

      <PARAM name="azName" value="AZ1"/>

      <PARAM name="azPriority" value="1"/>

      <PARAM name="backIp1" value="172.20.XX.101"/>

      <PARAM name="sshIp1" value="172.20.XX.101"/>

      <!-- dn -->

      <PARAM name="dataNum" value="1"/>

      <PARAM name="dataPortBase" value="26000"/>

      <PARAM name="dataNode1" value="/opt/huawei/install/data/dn"/>

    </DEVICE>

  </DEVICELIST>

</ROOT>

预安装检查

[root@opengaussdb1 script]# python3 gs_preinstall -U omm -G dbgrp -X /opt/software/openGauss/cluster_config_template.xml

su – omm

安装

gs_install -X /opt/software/openGauss/cluster_config_template.xml

[omm@opengaussdb1 script]$ gsql -d postgres -p 26000

gsql ((openGauss 5.1.0 build b5a8d5b0) compiled at 2023-09-28 00:39:45 commit 0 last mr  )

Non-SSL connection (SSL connection is recommended when requiring high-security)

Type "help" for help.

openGauss=# \l

                          List of databases

   Name    | Owner | Encoding  | Collate | Ctype | Access privileges

-----------+-------+-----------+---------+-------+-------------------

 postgres  | omm   | SQL_ASCII | C       | C     |

 template0 | omm   | SQL_ASCII | C       | C     | =c/omm           +

           |       |           |         |       | omm=CTc/omm

 template1 | omm   | SQL_ASCII | C       | C     | =c/omm           +

           |       |           |         |       | omm=CTc/omm

(3 rows)

openGauss=# \q

至此安装完成