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< 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< cp /opt/software/openGauss/clusterconfig.xml /opt/software/openGauss/script/clusterconfig.xml |
| 【配置环境变量】 cat>> /etc/profile< 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 |
