【我和openGauss的故事】openGauss5.0企业版集群一主一备安装V1.0

操作系统版本
cat /etc/redhat-release
CentOS Linux release 7.9.2009 (Core)

数据库版本
openGauss 5.0 企业版

设置主机名、 ip、  hosts文件

关闭防火墙、selinux

设置时区、时间同步

关闭SWAP分区（建议要求）
注释 swap 行
vim /etc/fstab

查看
free -h 查看 swap一行全是 0 表示swap关闭
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.

yum install -y libaio-devel flex bison ncurses-devel glibc-devel patch lsb_release readline-devel expect bzip2 ntp lsof
1.

rpm -qa libaio-devel flex bison ncurses-devel glibc-devel patch lsb_release readline-devel expect bzip2
1.

cat >>/etc/sysctl.conf<<EOF
net.ipv4.tcp_fin_timeout=60
net.ipv4.tcp_retries1=5
net.ipv4.tcp_syn_retries=5
#net.sctp.path_max_retrans=10
#net.sctp.max_init_retransmits=10
vm.min_free_kbytes=408677
net.ipv4.ip_local_port_range=26000 65535
net.ipv4.tcp_max_tw_buckets=10000
net.ipv4.tcp_tw_reuse=0
net.ipv4.tcp_tw_recycle=0
net.ipv4.tcp_keepalive_time=30
net.ipv4.tcp_keepalive_intvl=30
net.ipv4.tcp_retries2=12
net.ipv4.tcp_rmem=8192 250000 16777216
net.ipv4.tcp_wmem=8192 250000 16777216
net.core.wmem_max=21299200
net.ipv4.tcp_tw_reuse=1
net.ipv4.tcp_tw_recycle=1
net.core.netdev_max_backlog=65535
net.ipv4.tcp_max_syn_backlog=65535
net.core.somaxconn=65535
EOF
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.

cat /etc/sysctl.conf
1.

sysctl -p
1.

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
ifconfig ens32 mtu 8192
EOF

chmod 755 /etc/rc.d/rc.local
systemctl enable rc-local
systemctl start rc-local
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.

cat /sys/kernel/mm/transparent_hugepage/enabled
cat /sys/kernel/mm/transparent_hugepage/defrag
1.
2.

echo "* soft nofile 1000000" >>/etc/security/limits.conf
echo "* hard nofile 1000000" >>/etc/security/limits.conf
 echo "* hard  nproc  unlimited" >>/etc/security/limits.conf
 echo "* soft   nproc  unlimited" >>/etc/security/limits.conf
1.
2.
3.
4.

cat>> /etc/profile<<EOF
export LANG=en_US.UTF-8
EOF
source /etc/profile
1.
2.
3.
4.

cat /etc/profile | grep LANG
1.

yum install libaio-devel flex bison ncurses-devel glibc-devel patch redhat-lsb python3 bzip2 –y

mv /usr/bin/python /usr/bin/python.bak
ln -s /usr/bin/python3 /usr/bin/python
1.
2.
3.
4.

vim /usr/bin/yum
#!/usr/bin/python2.7
:wq! 保存退出

vim /usr/libexec/urlgrabber-ext-down
/usr/bin/python2.7
:wq! 保存退出
1.
2.
3.
4.
5.
6.
7.

yum makecache
1.

mkdir -p /opt/software/openGauss
1.

# tar -zxvf openGauss-5.0.0-CentOS-64bit-all.tar.gz
# tar -zxvf openGauss-5.0.0-CentOS-64bit-om.tar.gz
1.
2.

mkdir -p /opt/openGauss
chmod -R 755 /opt/openGauss
1.
2.

 # find / -name cluster_config_template.xml

# cp /opt/software/openGauss/script/gspylib/etc/conf/cluster_config_template.xml /opt/software/openGauss/cluster_config.xml


# vi cluster_config.xml
1.
2.
3.
4.
5.
6.

# /opt/software/openGauss/script/gs_checkos   -i A -h gaussdb01
  --detail
1.
2.

/etc/sysctl.conf
vm.min_free_kbytes=408677
net.ipv4.ip_local_port_range=26000 65535
…………………………………………
……………………………………………

# blockdev --setra 16384 /dev/sdb
……………………………………………..
1.
2.
3.
4.
5.
6.
7.
8.

# /opt/software/openGauss/script/gs_preinstall -U omm -G dbgrp -X /opt/software/openGauss/cluster_config.xml
1.

rm -rf /opt/openGauss/*
chown omm:dbgrp -R /opt/openGauss
chown omm:dbgrp -R /opt/software/openGauss
# chmod -R 755  /opt/openGauss
# chmod -R 755  /opt/software/openGauss
1.
2.
3.
4.
5.

# /opt/software/openGauss/script/gs_preinstall -U omm -G dbgrp -X /opt/software/openGauss/cluster_config.xml
1.

#su  - omm
$[omm@postgresql script]$ gs_install -X  /opt/software/openGauss/cluster_config.xml
1.
2.

# cat /opt/openGauss/dn/postgresql.conf|grep -i wal_level
1.

# cat /opt/openGauss/dn/postgresql.conf|grep -i hot_standby
1.

openGauss=# create table tb1 (id int,name text);
CREATE TABLE

openGauss=#  insert into tb1 (id,name) values (10,'Jacky');
1.
2.
3.
4.

gsql -d postgres -p 15400


-- omm用户
[omm@gaussdb01 ~]$ gs_om -t status --detail
[   Cluster State   ]

cluster_state   : Normal
redistributing  : No
current_az      : AZ_ALL

[  Datanode State   ]

    node     node_ip         port      instance                  state
--------------------------------------------------------------------------------------
1  gaussdb01 10.10.80.236    15400      6001 /opt/openGauss/dn   P Primary Normal 
2  gaussdb02 10.10.80.237    15400      6002 /opt/openGauss/dn   S Standby Normal
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.

$ gs_om -t status --all
1.

$ gs_ctl query -D /opt/openGauss/dn
1.