一、部署环境
操作系统Centos7.9
greenplum版本6.26 #下载地址：https://github.com/greenplum-db/gpdb/releases
1.1集群规划
192.168.5.11 master
192.168.5.12 segment1
192.168.5.13 segment2
主机名称
hostnamectl set-hostname master
hostnamectl set-hostname segment1
hostnamectl set-hostname segment2
hosts设置
vim /etc/hosts
192.168.5.11 master mdw
192.168.5.12 segment1 sdw1
192.168.5.13 segment2 sdw2
1.2 用户及用户组建
groupadd gpadmin
useradd gpadmin
passwd gpadminf
二、greenplum配置
2.1 机器列表
su gpadmin
mkdir conf
vim all_hosts
master
segment1
segment2
vim /seg_hosts
segment1
segment2
2.2 ssh免密
gpadmin用户下操作
生成密钥对
ssh-keygen -t rsa
分发公钥
ssh-copy-id gpadmin@master
ssh-copy-id gpadmin@segment1
ssh-copy-id gpadmin@segment2
2.3 关闭防火墙
systemctl stop firewalld
systemctl disable firewalld
2.4 禁用selinux
sed -i "s#^SELINUX=.*#SELINUX=disabled#g" /etc/selinux/config
2.5 修改系统文件限制
cat <<EOF > /etc/security/limits.conf
soft nofile 524288
hard nofile 524288
soft nporc 131072
soft nporc 131072
EOF
2.6 修改ssh连接数
cat <<EOF >> /etc/ssh/sshd_config
MaxStartups 200
MaxSessions 200
EOF
2.7 修改内核参数
cat <<EOF > /etc/sysctl.conf
# kernel.shmall = _PHYS_PAGES / 2
kernel.shmall = 742216
# kernel.shmmax = kernel.shmall * PAGE_SIZE
kernel.shmmax = 3040116736
kernel.shmmni = 4096
vm.overcommit_memory = 2
vm.overcommit_ratio = 95
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
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
EOF
使设置生效
sysctl -p
重启所有节点
三、greenplum安装