greenplum 主从部署

# host解析
vim /etc/hosts
192.168.12.235 node1.iotplatform.com
192.168.11.202 node2.iotplatform.com

# 创建用户
useradd gpadmin
yes gpadmin|passwd gpadmin

# 创建相关目录
mkdir -p /data/gpadmin/master
mkdir -p /data/gpadmin/mirror
mkdir -p /data/gpadmin/primary
mkdir -p /user/searchlight

# 解压文件
mkdir /opt/iotplatform
tar xf greenplum-db-6.16.0.tar.gz -C /opt/iotplatform/

# 安装
cd /opt/iotplatform/greenplum-db-6.16.0/
rpm -ivh apr-1.4.8-5.el7.x86_64.rpm
rpm -ivh  apr-util-1.5.2-6.el7.x86_64.rpm
rpm -ivh  bzip2-1.0.6-13.el7.x86_64.rpm
rpm -ivh  libevent-2.0.21-4.el7.x86_64.rpm
rpm -ivh  zip-3.0-11.el7.x86_64.rpm
yum -y install krb5-devel libyaml
rpm -ivh  greenplum-db-6.16.0-rhel7-x86_64.rpm

# 配置主机列表
vim /usr/local/greenplum-db-6.16.0/bin/allhosts
node1.iotplatform.com
node2.iotplatform.com

# 
echo 'kernel.shmall = 2041774
kernel.shmmax = 8363106304
kernel.shmmni = 4096
vm.overcommit_memory = 1
vm.overcommit_ratio = 95
net.ipv4.ip_local_port_range = 10000 65535
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.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 = 3
vm.dirty_ratio = 10
vm.max_map_count=655360
' >> /etc/sysctl.conf

# 生效
sysctl -p

# 授权
chown -R gpadmin:gpadmin /usr/local/greenplum*
chown -R gpadmin:gpadmin /data/gpadmin
chown -R gpadmin:gpadmin /home/gpadmin
chown -R gpadmin:gpadmin /user/searchlight
setfacl -m d:u:gpadmin:rwx -R /user/searchlight
chmod +x /usr/local/greenplum-db-6.16.0/*.sh

# 生成秘钥
su - gpadmin -c "[ ! -f /home/gpadmin/.ssh/id_rsa.pub ] && ssh-keygen -t rsa -P \"\" -f /home/gpadmin/.ssh/id_rsa"
su - gpadmin -c "cat /home/gpadmin/.ssh/id_rsa.pub >> /home/gpadmin/.ssh/authorized_keys"

chmod 700 /home/gpadmin/.ssh
chmod 600 /home/gpadmin/.ssh/authorized_keys

# 推送秘钥,两台都要推送
ssh-copy-id -i ~/.ssh/id_rsa.pub # host解析
vim /etc/hosts