Greenplum6.8.1安装

systemctl stop firewalld

systemctl disable firewalld

sed -ri '/^SELINUX=/cSELINUX=disabled' /etc/selinux/config

setenforce 0    (临时关闭)

192.168.124.175 minio1

192.168.124.176 minio2

192.168.124.177 minio3

192.168.124.178 minio4

rpm -q apr apr-util bash bzip2 curl krb5 libcurl libevent libxml2 libyaml zlib openldap openssh-client openssl openssl-libs perl readline rsync R sed tar zip krb5-devel | grep "is not installed" | awk '{print $2}' | xargs echo yum install -y

echo $(expr $(getconf \_PHYS\_PAGES) / 2) 

echo $(expr $(getconf \_PHYS\_PAGES) / 2 \\* $(getconf PAGE\_SIZE))

vm.overcommit\_memory 系统使用该参数来确定可以为进程分配多少内存。对于GP数据库，此参数应设置为2。  

vm.overcommit\_ratio 以为进程分配内的百分比，其余部分留给操作系统。默认值为50。建议设置95(根据主机内存大小自行设置)

vm.dirty\_background\_ratio = 0

vm.dirty\_ratio = 0

vm.dirty\_background\_bytes = 1610612736 # 1.5GB

vm.dirty\_bytes = 4294967296 # 4GB

vm.dirty\_background\_ratio = 3

vm.dirty\_ratio = 10

awk 'BEGIN {OFMT = "%.0f";} /MemTotal/ {print "vm.min\_free\_kbytes =", $2 \* .03;}' /proc/meminfo >> /etc/sysctl.conf 

net.ipv4.ipfrag\_high\_thresh = 41943040

net.ipv4.ipfrag\_low\_thresh = 31457280

net.ipv4.ipfrag\_time = 60

#共享内存设置

kernel.shmall = 485033

kernel.shmmax = 1986695168 # 这里的俩个参数为该节点第一步分别计算出的数据

kernel.shmmni = 4096



# See Segment Host Memory           

vm.overcommit\_memory = 2

vm.overcommit\_ratio = 90



# 系统内存

vm.dirty\_background\_ratio = 3

vm.dirty\_ratio = 10

vm.dirty\_expire\_centisecs = 500

vm.dirty\_writeback\_centisecs = 100

vm.zone\_reclaim\_mode = 0

vm.min\_free\_kbytes = 116408



# See Port Settings 端口设定

net.ipv4.ip\_local\_port\_range = 10000 65535



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

\* soft nofile 524288

\* hard nofile 524288

\* soft nproc 131072

\* hard nproc 131072

kernel.core\_pattern=/var/core/core.%h.%t

\* soft  core unlimited

#获取预读值

/sbin/blockdev --getra <devname>

#设置预读值

/sbin/blockdev --setra 16384 /dev/sda



# 永久设置

vim /etc/rc.d/rc.local

/sbin/blockdev --setra 16384 /dev/sda



chmod +x /etc/rc.d/rc.local

grubby --update-kernel=ALL --args="elevator=deadline"

vim /etc/rc.local         //添加如下内容

if test -f /sys/kernel/mm/transparent\_hugepage/enabled; then

 echo never > /sys/kernel/mm/transparent\_hugepage/enabled

fi

if test -f /sys/kernel/mm/transparent\_hugepage/defrag; then

 echo never > /sys/kernel/mm/transparent\_hugepage/defrag

fi

# 在GRUB\_CMDLINE\_LINUX加入选项 transparent\_hugepage=never

vim etc/default/grub      

GRUB\_TIMEOUT=5

GRUB\_DISTRIBUTOR="$(sed 's, release .\*$,,g' /etc/system-release)"

GRUB\_DEFAULT=saved

GRUB\_DISABLE\_SUBMENU=true

GRUB\_TERMINAL\_OUTPUT="console"

GRUB\_CMDLINE\_LINUX="rd.lvm.lv=fedora/swap rd.lvm.lv=fedora/root rhgb quiet transparent\_hugepage=never"

GRUB\_DISABLE\_RECOVERY="true"

# 根据启动方式，重新生成grub配置文件

grub2-mkconfig -o /boot/grub2/grub.cfg      //bios

grub2-mkconfig -o /boot/efi/EFI/redhat/grub.cfg       //uefi

#重启

reboot

# 确认结果，显示为never

cat /sys/kernel/mm/transparent\_hugepage/enabled

cat /sys/kernel/mm/transparent\_hugepage/defrag

vim /etc/ssh/sshd\_config

MaxSessions 200

MaxStartups 100:30:1000

vim /etc/systemd/logind.conf

RemoveIPC=no



systemctl restart systemd-logind.service

service systemd-logind restart

echo $LANG

# 如果不是en\_US.UTF-8的，执行下面语句

localectl set-locale LANG=en\_US.UTF-8

groupadd -g 1530 gpadmin

useradd -u 1530 gpadmin -r -m -g gpadmin

passwd gpadmin

su - gpadmin

ssh-keygen -t rsa 

visudo

gpadmin         ALL=(ALL)       NOPASSWD: ALL

sudo yum install ./greenplum-db-<version>-<platform>.rpm

sudo chown -R gpadmin:gpadmin /usr/local/greenplum\*

sudo chgrp -R gpadmin /usr/local/greenplum\*

source /usr/local/greenplum-db-<version>/greenplum\_path.sh



ssh-copy-id minio1

ssh-copy-id minio2

ssh-copy-id minio3

ssh-copy-id minio4

vim hostfile\_exkeys

minio1

minio2

minio3

minio4

gpssh-exkeys -f hostfile\_exkeys

gpssh -f hostfile\_exkeys -e 'ls -l /usr/local/greenplum-db-<version>'

vim /home/gpadmin/.bashrc

source /usr/local/greenplum-db/greenplum\_path.sh

export PGPORT=5432

export MASTER\_DATA\_DIRECTORY=/gpdata/master/gpseg-1

export PGDATABASE=zndb



source /home/gpadmin/.bashrc

mkdir -p /gpdata/master

chown gpadmin:gpadmin /gpdata/master

source /usr/local/greenplum-db/greenplum\_path.sh 

mkdir -p /gpdata/master

chown gpadmin:gpadmin /gpdata/master

source /usr/local/greenplum-db/greenplum\_path.sh 

mkdir -p /gpdata/primary

mkdir -p /gpdata/mirror

chown -R gpadmin:gpadmin /gpdata/\*

su - gpadmin

source /usr/local/greenplum-db/greenplum\_path.sh

vim hostfile\_gpinitsystem

minio1

minio2

minio3

minio4

cp $GPHOME/docs/cli\_help/gpconfigs/gpinitsystem\_config  /home/gpadmin/gpconfigs/gpinitsystem\_config

vim gpinitsystem\_config



# FILE NAME: gpinitsystem\_config

# Configuration file needed by the gpinitsystem

################################################

#### REQUIRED PARAMETERS

################################################



#### Name of this Greenplum system enclosed in quotes.

ARRAY\_NAME="Greenplum Data Platform"



#### Naming convention for utility-generated data directories.

SEG\_PREFIX=gpseg



#### Base number by which primary segment port numbers

#### are calculated.

PORT\_BASE=16000



#### File system location(s) where primary segment data directories

#### will be created. The number of locations in the list dictate

#### the number of primary segments that will get created per

#### physical host (if multiple addresses for a host are listed in

#### the hostfile, the number of segments will be spread evenly across

#### the specified interface addresses).

declare -a DATA\_DIRECTORY=(/gpdata/primary /gpdata/primary)



#### OS-configured hostname or IP address of the master host.

MASTER\_HOSTNAME=minio1



#### File system location where the master data directory

#### will be created.

MASTER\_DIRECTORY=/gpdata/master



#### Port number for the master instance.

MASTER\_PORT=5432



#### Shell utility used to connect to remote hosts.

TRUSTED\_SHELL=ssh



#### Maximum log file segments between automatic WAL checkpoints.

CHECK\_POINT\_SEGMENTS=8



#### Default server-side character set encoding.

ENCODING=UNICODE



################################################

#### OPTIONAL MIRROR PARAMETERS

################################################



#### Base number by which mirror segment port numbers

#### are calculated.

MIRROR\_PORT\_BASE=17000



#### File system location(s) where mirror segment data directories

#### will be created. The number of mirror locations must equal the

#### number of primary locations as specified in the

#### DATA\_DIRECTORY parameter.

declare -a MIRROR\_DATA\_DIRECTORY=(/gpdata/mirror /gpdata/mirror)



################################################

#### OTHER OPTIONAL PARAMETERS

################################################



#### Create a database of this name after initialization.

DATABASE\_NAME=zndb



#### Specify the location of the host address file here instead of

#### with the -h option of gpinitsystem.

#MACHINE\_LIST\_FILE=/home/gpadmin/gpconfigs/hostfile\_gpinitsystem

gpinitsystem -c gpinitsystem\_config -h hostfile\_gpinitsystem -s minio2 --mirror-mode=spread

gpconfig -s TimeZone

gpconfig -c TimeZone -v 'Asia/Shanghai'

vim /gpdata/master/gpseg-1/pg\_hba.conf

...



host all    all  192.168.124.0/24 md5





# 重新加载配置文件

gpstop -u 

psql -d postgres



alter user gpadmin with password 'gpadmin';