CentOS7.6下载地址：https://archive.kernel.org/centos-vault/7.6.1810/isos/x86_64/
opengauss2.1.0企业版：https://opengauss.org/zh/download.html
| 【配置主机名和IP】 hostname && ifconfig |grep broadcast|awk '{print $2}' ed -i '/hostname/d' /etc/hosts echo "192.168.80.3 hostname ##openGauss OM IP Hosts Mapping" >>/etc/hosts cat /etc/hosts|grep openGauss hostname && ifconfig |grep broadcast|awk '{print $2}' |
| 【关闭防火墙*inactive (dead)】 systemctl stop firewalld.service systemctl disable firewalld.service systemctl status firewalld |
| 【关闭SELinux*SELINUX=disabled】 getenforce sed -i 's/^SELINUX=.*/SELINUX=disabled/' /etc/selinux/config setenforce 0 getenforce cat /etc/selinux/config|grep SELINUX |
| 【设置root用户远程登陆*PermitRootLogin yes】 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 systemctl restart sshd.service cat /etc/ssh/sshd_config |grep -v ^#|grep -E 'PermitRootLogin|Banner' |
| 【设置字符集参数*export LANG=en_US.UTF-8】 cat>> /etc/profile<<EOF export LANG=en_US.UTF-8 EOF cat /etc/profile | grep LANG |
| 【设置时区和时间】 rm -fr /etc/localtime ln -s /usr/share/zoneinfo/Asia/Shanghai /etc/localtime date -R hwclock echo -e "\n" |
| 【配置NTPD】 yum install ntp -y vi /etc/ntp.conf 添加： restrict 192.168.0.0 mask 255.255.255.0 nomodify notrap server 127.127.1.0 # local clock fudge 127.127.1.0 stratum 10 server node1 注释： 所有的server行 service ntpd start chkconfig ntpd on |
| 【关闭交换区】 cp /etc/fstab /etc/fstab.bak sed -i '/swap/s/^/#/' /etc/fstab cat /etc/fstab|grep -v ^#|grep -v '^$' swapoff -a free -m |
| 【配置操作系统参数】 cat >> /etc/sysctl.conf << EOF net.ipv4.tcp_max_tw_buckets = 10000 net.ipv4.tcp_tw_reuse = 1 net.ipv4.tcp_tw_recycle = 1 net.ipv4.tcp_keepalive_time = 30 net.ipv4.tcp_keepalive_probes = 9 net.ipv4.tcp_keepalive_intvl = 30 net.ipv4.tcp_retries1 = 5 net.ipv4.tcp_syn_retries = 5 net.ipv4.tcp_synack_retries = 5 net.sctp.path_max_retrans = 10 net.sctp.max_init_retransmits = 10 net.sctp.association_max_retrans = 10 net.sctp.hb_interval = 30000 net.ipv4.tcp_retries2 = 12 vm.overcommit_memory = 0 net.sctp.sndbuf_policy = 0 net.sctp.rcvbuf_policy = 0 net.sctp.sctp_mem = 94500000 915000000 927000000 net.sctp.sctp_rmem = 8192 250000 16777216 net.sctp.sctp_wmem = 8192 250000 16777216 net.ipv4.tcp_rmem = 8192 250000 16777216 net.ipv4.tcp_wmem = 8192 250000 16777216 net.core.wmem_max = 21299200 net.core.rmem_max = 21299200 net.core.wmem_default = 21299200 net.core.rmem_default = 21299200 net.ipv4.ip_local_port_range = 26000 65535 kernel.sem = 250 6400000 1000 25600 vm.min_free_kbytes = 419430 ##suggest to set as physical memory * 5% net.core.somaxconn = 65535 net.ipv4.tcp_syncookies = 1 net.sctp.addip_enable = 0 net.core.netdev_max_backlog = 65535 net.ipv4.tcp_max_syn_backlog = 65535 net.ipv4.tcp_fin_timeout = 60 kernel.shmall = 1152921504606846720 kernel.shmmax = 18446744073709551615 net.ipv4.tcp_sack = 1 net.ipv4.tcp_timestamps = 1 vm.extfrag_threshold = 500 vm.overcommit_ratio = 90 net.ipv4.ip_local_reserved_ports = 20050-20057,26000-26007 net.sctp.sctp_mem = 94500000 915000000 927000000 net.sctp.sctp_rmem = 8192 250000 16777216 net.sctp.sctp_wmem = 8192 250000 16777216 EOF
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 net.ipv4.tcp_fin_timeout = 60 EOF
sysctl -p |
| 【修改系统资源限制】 echo "* soft stack 3072" >> /etc/security/limits.conf echo "* hard stack 3072" >> /etc/security/limits.conf echo "* soft nofile 1000000" >> /etc/security/limits.conf echo "* hard nofile 1000000" >> /etc/security/limits.conf echo "* soft nproc unlimited" >> /etc/security/limits.d/90-nproc.conf tail -n 4 /etc/security/limits.conf tail -n 1 /etc/security/limits.d/90-nproc.conf |
| 【关闭透明页】 echo never > /sys/kernel/mm/transparent_hugepage/enabled echo never > /sys/kernel/mm/transparent_hugepage/defrag sed -i '/^GRUB_CMDLINE_LINUX/d' /etc/default/grub echo "GRUB_CMDLINE_LINUX=\"rhgb quiet transparent_hugepage=never\"" >> /etc/default/grub grub2-mkconfig -o /boot/grub2/grub.cfg 重启后： grep Huge /proc/meminfo |
| 【安装软件包】 rpm -qa libaio-devel flex bison ncurses-devel glibc-devel patch redhat-lsb-core readline-devel bzip2 python3 java-1.8.0-openjdk* yum install -y lksctp* yum install -y java-1.8.0-openjdk* psmisc bzip2 python3 python3-devel yum install libaio-devel flex bison ncurses-devel glibc-devel patch readline-devel redhat-lsb-core |
| 【openGuass存放】 mkdir -p /opt/software/openGauss chmod 755 -R /opt/software 将openGuass移动或存放至 /opt/software/下 |
| 【解压缩openGauss DBMS介质】 cd /opt/software/openGauss tar -zxvf openGauss-2.1.0-CentOS-64bit-all.tar.gz tar -zxvf openGauss-2.1.0-CentOS-64bit-om.tar.gz |
| 【创建XML文件】 cd /opt/software/openGauss cat > clusterconfig.xml<<EOF
<?xml version="1.0" encoding="UTF-8"?> <ROOT> <!-- openGauss整体信息 --> <CLUSTER> <!-- 数据库名称 --> <PARAM name="clusterName" value="dbCluster" /> <!-- 数据库节点名称(hostname) --> <PARAM name="nodeNames" value="hostname" /> <!-- 数据库安装目录--> <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" /> <!-- 数据库core文件目录--> <PARAM name="corePath" value="/opt/huawei/corefile" /> <!-- 节点IP，与数据库节点名称列表一一对应 --> <PARAM name="backIp1s" value="192.168.80.3"/> </CLUSTER> <!-- 每台服务器上的节点部署信息 --> <DEVICELIST> <!-- 节点1上的部署信息 --> <DEVICE sn="node1"> <!-- 节点1的主机名称 --> <PARAM name="name" value="zhang"/> <!-- 节点1所在的AZ及AZ优先级 --> <PARAM name="azName" value="AZ1"/> <PARAM name="azPriority" value="1"/> <!-- 节点1的IP，如果服务器只有一个网卡可用，将backIP1和sshIP1配置成同一个IP --> <PARAM name="backIp1" value="192.168.80.3"/> <PARAM name="sshIp1" value="192.168.80.3"/>
<!--dbnode--> <PARAM name="dataNum" value="1"/> <PARAM name="dataPortBase" value="26000"/> <PARAM name="dataNode1" value="/opt/huawei/install/data/dn01"/> <PARAM name="dataNode1_syncNum" value="0"/> </DEVICE> </DEVICELIST> </ROOT> cp /opt/software/openGauss/clusterconfig.xml /opt/software/openGauss/script/clusterconfig.xml |
| 【配置环境变量】 cat>> /etc/profile<<EOF export LD_LIBRARY_PATH=/opt/software/openGauss/script/gspylib/clib:$LD_LIBRARY_PATH EOF 重启生效： echo $LD_LIBRARY_PATH |
| 【交互式检查*Preinstallation succeeded.】 cd /opt/software/openGauss/script ./gs_preinstall -U omm -G dbgrp -X /opt/software/openGauss/clusterconfig.xml |
| 【安装openGauss DBMS和创建数据库】 su - cd /opt/software/openGauss/script chmod -R 775 /opt/software/openGauss/script chown -R omm:dbgrp /opt/software/openGauss/script su - omm cd /opt/software/openGauss/script gs_install -X /opt/software/openGauss/script/clusterconfig.xml \ --gsinit-parameter="--encoding=UTF8" \ --dn-guc="max_connections=1000" \ --dn-guc="max_process_memory=3GB" \ --dn-guc="shared_buffers=128MB" \ --dn-guc="bulk_write_ring_size=128MB" \ --dn-guc="cstore_buffers=16MB"
pwd cat ~/.bashrc gs_om -t status gs_om -t stop&&gs_om -t start |
| 【登录】 gsql -d postgres -p 26000 -r |
| 【维护】 gs_om -t start gs_om -t stop gs_om -t status --detail |