Greenplum 6.5.0安装

1. 环境
   系统：CentOS 7
   机器四台，一台master，三个segment(16C，64G)

2. 安装软件依赖

yum install apr apr-util bash bzip2 curl krb5-devel libcurl libevent libxml2 libyaml zlib openldap openssh openssl openssl-libs perl readline rsync R sed tar zip

3. 安装jdk
   集群上所有机器上都需要安装jdk 8或者以上的版本

4. 硬件和网络
   

5. 存储
   Greenplum只支持xfs格式的存储

6. 禁用SELinux
   如果Greenplum数据库服务运行在CentOS或者RedHat系统上，那么SELinux必须禁用。

   [root@gpdb01 ~]# vim /etc/selinux/config 
   SELINUX=disabled
   

   如果系统上安装了系统安全服务(SSSD)，需要将SSSD中的selinux_provider配置设置为none。

   [root@gpdb01 ~]# vim /etc/sssd/sssd.conf
   selinux_provider=none
   

7. 禁用Firewall

   ###对于Centos 6
   chkconfig --list iptables
   iptables 0:off 1:off 2:off 3:off 4:off 5:off 6:off
   chkconfig iptables off
   
   ###对于CentOS 7
   systemctl status firewalld
   systemctl stop firewalld.service
   systemctl disable firewalld.service
   

8. 配置系统参数

   [root@gpdb01 ~]# vim /etc/sysctl.conf
   # kernel.shmall = _PHYS_PAGES / 2 # See Shared Memory Pages
   kernel.shmall = 8094587
   # kernel.shmmax = kernel.shmall * PAGE_SIZE
   kernel.shmmax = 33155428352
   kernel.shmmni = 4096
   vm.overcommit_memory = 2 # See Segment Host Memory
   vm.overcommit_ratio = 95 # See Segment Host Memory
   net.ipv4.ip_local_port_range = 10000 65535 # See Port Settings
   kernel.sem = 500 2048000 200 4096
   kernel.sysrq = 1
   kernel.core_uses_pid = 1
   kernel.msgmnb = 65536
   kernel.msgmax = 65536
   kernel.msgmni = 2048
   net.ipv4.tcp_syncookies = 1
   net.ipv4.conf.default.accept_source_route = 0
   net.ipv4.tcp_max_syn_backlog = 4096
   net.ipv4.conf.all.arp_filter = 1
   net.core.netdev_max_backlog = 10000
   net.core.rmem_max = 2097152
   net.core.wmem_max = 2097152
   vm.swappiness = 10
   vm.zone_reclaim_mode = 0
   vm.dirty_expire_centisecs = 500
   vm.dirty_writeback_centisecs = 100
   vm.dirty_background_ratio = 0 # See System Memory
   vm.dirty_ratio = 0
   #vm.dirty_background_bytes = 1610612736
   #vm.dirty_bytes = 4294967296
   vm.min_free_kbytes = 983391
   
   
   

9. 系统资源限制
   修改/etc/security/limits.conf ，增加以下参数:

   * soft nofile 524288
   * hard nofile 524288
   * soft nproc 131072
   * hard nproc 131072
   

   RHEL / CentOS 6 修改：/etc/security/limits.d/90-nproc.conf 文件的nproc 为131072
   RHEL / CentOS 7 修改：/etc/security/limits.d/20-nproc.conf 文件的nproc 为131072

   [gpadmin@gpdb01 ~]$ vim /etc/security/limits.d/20-nproc.conf
   # Default limit for number of user's processes to prevent
   # accidental fork bombs.
   # See rhbz #432903 for reasoning.
   
   *          soft    nproc     131072
   root       soft    nproc     unlimited
   

未完待续