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

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

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

cat >>/etc/sysctl.conf<<EOFnet.ipv4.tcp_fin_timeout=60net.ipv4.tcp_retries1=5net.ipv4.tcp_syn_retries=5#net.sctp.path_max_retrans=10#net.sctp.max_init_retransmits=10vm.min_free_kbytes=408677net.ipv4.ip_local_port_range=26000 65535net.ipv4.tcp_max_tw_buckets=10000net.ipv4.tcp_tw_reuse=0net.ipv4.tcp_tw_recycle=0net.ipv4.tcp_keepalive_time=30net.ipv4.tcp_keepalive_intvl=30net.ipv4.tcp_retries2=12net.ipv4.tcp_rmem=8192 250000 16777216net.ipv4.tcp_wmem=8192 250000 16777216net.core.wmem_max=21299200net.ipv4.tcp_tw_reuse=1net.ipv4.tcp_tw_recycle=1net.core.netdev_max_backlog=65535net.ipv4.tcp_max_syn_backlog=65535net.core.somaxconn=65535EOF

cat /etc/sysctl.conf

sysctl -p

cat >> /etc/rc.d/rc.local<<EOFif test -f /sys/kernel/mm/transparent_hugepage/enabled;thenecho never > /sys/kernel/mm/transparent_hugepage/enabledfiif test -f /sys/kernel/mm/transparent_hugepage/defrag;thenecho never > /sys/kernel/mm/transparent_hugepage/defragfiifconfig ens32 mtu 8192EOF
chmod 755 /etc/rc.d/rc.localsystemctl enable rc-localsystemctl start rc-local

cat /sys/kernel/mm/transparent_hugepage/enabledcat /sys/kernel/mm/transparent_hugepage/defrag

echo "* soft nofile 1000000" >>/etc/security/limits.confecho "* hard nofile 1000000" >>/etc/security/limits.conf echo "* hard  nproc  unlimited" >>/etc/security/limits.conf echo "* soft   nproc  unlimited" >>/etc/security/limits.conf

cat>> /etc/profile<<EOFexport LANG=en_US.UTF-8EOFsource /etc/profile

cat /etc/profile | grep LANG

yum install libaio-devel flex bison ncurses-devel glibc-devel patch redhat-lsb python3 bzip2 –y
mv /usr/bin/python /usr/bin/python.bakln -s /usr/bin/python3 /usr/bin/python

vim /usr/bin/yum#!/usr/bin/python2.7:wq! 保存退出
vim /usr/libexec/urlgrabber-ext-down/usr/bin/python2.7:wq! 保存退出

yum makecache

mkdir -p /opt/software/openGauss

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

mkdir -p /opt/openGausschmod -R 755 /opt/openGauss

 # 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

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

/etc/sysctl.confvm.min_free_kbytes=408677net.ipv4.ip_local_port_range=26000 65535………………………………………………………………………………………
# blockdev --setra 16384 /dev/sdb……………………………………………..

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

rm -rf /opt/openGauss/*chown omm:dbgrp -R /opt/openGausschown omm:dbgrp -R /opt/software/openGauss# chmod -R 755  /opt/openGauss# chmod -R 755  /opt/software/openGauss

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

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

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

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

openGauss=# create table tb1 (id int,name text);CREATE TABLE
openGauss=#  insert into tb1 (id,name) values (10,'Jacky');

gsql -d postgres -p 15400

-- omm用户[omm@gaussdb01 ~]$ gs_om -t status --detail[   Cluster State   ]
cluster_state   : Normalredistributing  : Nocurrent_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

$ gs_om -t status --all

$ gs_ctl query -D /opt/openGauss/dn