RHEL 7.5安装greenplum 集群

1、环境介绍：

more /etc/redhat-release 

Red Hat Enterprise Linux Server release 7.5 (Maipo)

系统安装采取最小化安装。

greenplum-db-5.16.0-rhel7-x86_64.zip

下载地址：

https://network.pivotal.io/products/pivotal-gpdb/#/releases/280281/file_groups/1355

​

more /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

192.168.15.201  rhmdw

192.168.15.202  rhsdw1

192.168.15.203  rhsdw2

 

 

 

2、系统调整

 

 systemctl stop firewalld.service

systemctl disable firewalld.service

 

 yum -y install psmisc-22.20-15.el7.x86_64 unzip

 

 sed -i 's/SELINUX=enforcing/SELINUX=disabled/' /etc/sysconfig/selinux 

 

pvcreate /dev/sda3

  Physical volume "/dev/sda3" successfully created.

vgextend rhel /dev/sda3

  Volume group "rhel" successfully extended

lvcreate -n gplum -L +10000M rhel

  Logical volume "gplum" created.

mkfs.xfs /dev/rhel/gplum

meta-data=/dev/rhel/gplum        isize=512    agcount=4, agsize=640000 blks

         =                       sectsz=512   attr=2, projid32bit=1

         =                       crc=1        finobt=0, sparse=0

data     =                       bsize=4096   blocks=2560000, imaxpct=25

         =                       sunit=0      swidth=0 blks

naming   =version 2              bsize=4096   ascii-ci=0 ftype=1

log      =internal log           bsize=4096   blocks=2560, version=2

         =                       sectsz=512   sunit=0 blks, lazy-count=1

realtime =none                   extsz=4096   blocks=0, rtextents=0

 

 

echo "/dev/mapper/rhel-gplum   /gp                       xfs     defaults        0 0" >> /etc/fstab

mount -a

df -hT

文件系统               类型      容量  已用  可用 已用% 挂载点

/dev/mapper/rhel-root  xfs       5.0G  1.2G  3.9G   24% /

devtmpfs               devtmpfs  1.2G     0  1.2G    0% /dev

tmpfs                  tmpfs     1.2G     0  1.2G    0% /dev/shm

tmpfs                  tmpfs     1.2G  8.6M  1.2G    1% /run

tmpfs                  tmpfs     1.2G     0  1.2G    0% /sys/fs/cgroup

/dev/sda1              xfs       197M  120M   77M   61% /boot

tmpfs                  tmpfs     229M     0  229M    0% /run/user/0

/dev/sr0               iso9660   4.4G  4.4G     0  100% /mnt

/dev/mapper/rhel-gplum xfs       9.8G   33M  9.8G    1% /gp

 

 

3、准备安装，所有节点操作

 

3.1、添加用户及组

 

 

groupadd supergroup

groupadd gpadmin

useradd -G supergroup,gpadmin gpadmin

 

chown -R gpadmin:gpadmin /gp

 

3.2、

echo "/usr/local/lib" >>  /etc/ld.so.conf

ls -lrt /etc/security/limits.conf ^C

cat <<eof>> /etc/security/limits.conf 

> * soft nofile 65536

> * hard nofile 65536

> * soft nproc 131072

> * hard nproc 131072

> eof

cat <<eof>> /etc/sysctl.conf 

> kernel.shmmax = 500000000

> kernel.shmmni = 4096

> kernel.shmall = 4000000000

> kernel.sem = 500 1024000 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.ip_forward = 0

> net.ipv4.conf.default.accept_source_route = 0

> net.ipv4.tcp_tw_recycle = 1

> net.ipv4.tcp_max_syn_backlog = 4096

> net.ipv4.conf.all.arp_filter = 1

> net.ipv4.ip_local_port_range = 1025 65535

> net.core.netdev_max_backlog = 10000

> net.core.rmem_max = 2097152

> net.core.wmem_max = 2097152

> vm.overcommit_memory = 2

> eof

sysctl -p

 

3.3、安装cmake3.x

[root@rhmdw soft]# sh cmake-3.13.4-Linux-x86_64.sh 

CMake Installer Version: 3.13.4, Copyright (c) Kitware

......

Do you accept the license? [yN]: 

y

By default the CMake will be installed in:

  "/soft/cmake-3.13.4-Linux-x86_64"

Do you want to include the subdirectory cmake-3.13.4-Linux-x86_64?

Saying no will install in: "/soft" [Yn]: 

y

......

[root@rhmdw soft]# mv cmake-3.13.4-Linux-x86_64 /usr/bin/

[root@rhmdw soft]# ln -sf /usr/bin/cmake-3.13.4-Linux-x86_64/bin/cmake /usr/bin/cmake

 

3.4 配置时间同步

 

 

3.5 调整CPU调度模式，调整deadline，rhel 7 3.6 默认为该模式

 

3.6 修改磁盘预读参数

blockdev --setra 65535 /dev/sda

echo "blockdev --setra 65535 /dev/sda" >> /etc/rc.d/rc.local

===