一、系统要求(具体参考Greenplum手册,本次以Greeplum Database 4.3版本为准)
1.操作系统:CentOS 5.0及以上,'cat /etc/redhat-release',环境为CentOS 7
2.数据存储分区要求格式为‘xfs’,可以使用mount -l命令查看分区挂载情况,满足。
3.cpu:Pentium Pro compatible (P3/Athlon and above),使用cat /proc/cpuinfo查看(只分了两个cpu)
4.内存:16G每台主机,使用free -h命令查看(2G内存)
5.硬盘:
- 150MB per host for Greenplum installation
- Approximately 300MB per segment instance for meta data
- Appropriate free space for data with disks at no more than 70% capacity
- High-speed, local storage(共8G空间)
6.网络:10 Gigabit Ethernet within the array
Dedicated, non-blocking switch
7.bash shell
GNU tars
GNU zip
GNU sed (used by the Greenplum Database installer)
查看master是否安装了ssl
【以下操作均为所有节点】
8.禁用SELinux(控制进程访问资源)、iptables、firewalld(防火墙有安全需求可以启用)
a.sestatus查看SELinux状态,编辑‘/etc/selinux/config’文件修改,SELINUX=disabled【注意大小写】
b.查看firewalld状态:‘systemctl status firewalld’, 关闭firewalld:'systemctl stop firewalld', 'systemctl disable firewalld'
9.设置系统参数(shared_memory, network, user limits)
a.修改/etc/systemctl.conf文件:
kernel.shmmax = 500000000 kernel.shmmni = 4096 kernel.shmall = 4000000000 kernel.sem = 250 512000 100 2048 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
b./etc/security/limits.conf
* soft nofile 65536 * hard nofile 65536 * soft nproc 131072 * hard nproc 131072
c.grubby --update-kernel=ALL --args="elevator=deadline"
d.修改read-ahead:/sbin/blockdev --setra 16384 /dev/sdb
【为了防止重启失效,将命令写入/etc/rc.local文件中,并将rc.local赋予可执行权限】
e.配置/etc/hosts文件,包含所有节点地址
f.Disable Transparent Huge Pages (THP):'grubby --update-kernel=ALL --args="transparent_hugepage=never"'
检查:cat /sys/kernel/mm/*transparent_hugepage/enabled always [never]
g.创建gpadmin用户
h.并且Disable IPC object removal(CentOS7.2版本以上,查看版本cat /etc/redhat-release):
/etc/systemd/logind.conf service systemd-logind restart