Java知识分享网 - 轻松学习从此开始!    

Java知识分享网

Java1234官方群25:java1234官方群17
Java1234官方群25:838462530
        
SpringBoot+SpringSecurity+Vue+ElementPlus权限系统实战课程 震撼发布        

最新Java全栈就业实战课程(免费)

springcloud分布式电商秒杀实战课程

IDEA永久激活

66套java实战课程无套路领取

锋哥开始收Java学员啦!

锋哥开始收Java学员啦!

Greenplum6.4.0安装部署手册 PDF 下载


分享到:
时间:2020-05-28 15:21来源:http://www.java1234.com 作者:小锋  侵权举报
Greenplum6.4.0安装部署手册 PDF 下载
失效链接处理

Greenplum6.4.0安装部署手册 PDF 下载

 

本站整理下载:
 
相关截图:
 
主要内容:

1 操作系统版本:CentOS Linux release 7
2,POSTGRES 版本:9.4.24, GP 版本:6.4.0
3,GP 规划(如果是单节点,把 IP 换成一样就行)
mdw_192.168.0.169------>主管理节点
sdw01_192.168.0.170------>计算节点 1
sdw02_192.168.0.171------>计算节点 2
smdw_192.168.0.172------>备管理节点
4,HOSTNAME 修改(所有 GP 机器)
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.0.169 mdw 
192.168.0.170 sdw01 
192.168.0.171 sdw02
192.168.0.172 smdw
5,创建用户,密码,目录创建,权限给予(MASTER)
groupadd gpadmin;useradd gpadmin -g gpadmin -G gpadmin;echo gpadmin | passwd --stdin 
gpadmin;
rm -rf /data/master;rm -rf /data/mirror;rm -rf /data/primary;
mkdir -p /data/master ;mkdir -p /data/primary;mkdir -p /data/mirror;
chown -R gpadmin /data/master;
chown -R gpadmin /data/primary;
chown -R gpadmin /data/mirror;
6,Selinux 禁用,防火墙关闭
systemctl stop firewalld
iptables -F
setenforce 0
sed -i "/^SELINUX=/cSELINUX=disabled" /etc/selinux/config
systemctl stop firewalld;systemctl disable firewalld
7,/etc/sysctl.conf 参数修改(所有机器)
sed -i '/fs.suid_dumpable/d' /etc/sysctl.conf
sed -i '/kernel.randomize_va_space/d' /etc/sysctl.conf
sed -i '/net.ipv4.ip_forward/d' /etc/sysctl.conf
sed -i '/net.ipv4.conf.all.send_redirects/d' /etc/sysctl.conf
sed -i '/net.ipv4.conf.default.send_redirects/d' /etc/sysctl.conf
sed -i '/net.ipv4.conf.all.accept_source_route/d' /etc/sysctl.conf
sed -i '/net.ipv4.conf.all.accept_redirects/d' /etc/sysctl.conf
sed -i '/net.ipv4.conf.all.secure_redirects/d' /etc/sysctl.conf
sed -i '/net.ipv4.conf.default.secure_redirects/d' /etc/sysctl.conf
sed -i '/net.ipv4.conf.all.log_martians/d' /etc/sysctl.conf
sed -i '/net.ipv4.conf.default.log_martians/d' /etc/sysctl.conf
sed -i '/net.ipv4.icmp_echo_ignore_broadcasts/d' /etc/sysctl.conf
sed -i '/net.ipv4.icmp_ignore_bogus_error_responses/d' /etc/sysctl.conf
sed -i '/net.ipv4.conf.all.rp_filter/d' /etc/sysctl.conf
sed -i '/net.ipv4.conf.default.rp_filter/d' /etc/sysctl.conf
sed -i '/net.ipv6.conf.all.accept_ra/d' /etc/sysctl.conf
sed -i '/net.ipv6.conf.default.accept_ra/d' /etc/sysctl.conf
sed -i '/net.ipv6.conf.all.accept_redirects/d' /etc/sysctl.conf
sed -i '/net.ipv6.conf.default.accept_redirects/d' /etc/sysctl.conf
sed -i '/kernel.shmmax/d' /etc/sysctl.conf
sed -i '/kernel.shmmni/d' /etc/sysctl.conf
sed -i '/kernel.shmall/d' /etc/sysctl.conf
sed -i '/kernel.sem/d' /etc/sysctl.conf
sed -i '/kernel.sysrq/d' /etc/sysctl.conf
sed -i '/kernel.core_uses_pid/d' /etc/sysctl.conf
sed -i '/kernel.msgmnb/d' /etc/sysctl.conf
sed -i '/kernel.msgmax/d' /etc/sysctl.conf
sed -i '/kernel.msgmni/d' /etc/sysctl.conf
sed -i '/net.ipv4.tcp_syncookies/d' /etc/sysctl.conf
sed -i '/net.ipv4.conf.default.accept_source_route/d' /etc/sysctl.conf
sed -i '/net.ipv4.tcp_max_syn_backlog/d' /etc/sysctl.conf
sed -i '/net.ipv4.tcp_syn_retries/d' /etc/sysctl.conf
sed -i '/net.ipv4.tcp_tw_recycle/d' /etc/sysctl.conf
sed -i '/net.ipv4.conf.all.arp_filter/d' /etc/sysctl.conf
sed -i '/net.ipv4.ip_local_port_range/d' /etc/sysctl.conf
sed -i '/net.ipv4.ip_local_reserved_ports/d' /etc/sysctl.conf
sed -i '/net.ipv6.conf.all.disable_ipv6/d' /etc/sysctl.conf
sed -i '/net.ipv6.conf.default.disable_ipv6/d' /etc/sysctl.conf
sed -i '/net.core.netdev_max_backlog/d' /etc/sysctl.conf
sed -i '/net.core.rmem_default/d' /etc/sysctl.conf
sed -i '/net.core.rmem_max/d' /etc/sysctl.conf
sed -i '/net.core.wmem_max/d' /etc/sysctl.conf
sed -i '/vm.overcommit_memory/d' /etc/sysctl.conf
sed -i '/vm.overcommit_ratio/d' /etc/sysctl.conf
sed -i '/vm.swappiness/d' /etc/sysctl.conf
sed -i '/vm.zone_reclaim_mode/d' /etc/sysctl.conf
sed -i '/vm.dirty_expire_centisecs/d' /etc/sysctl.conf
sed -i '/vm.dirty_writeback_centisecs/d' /etc/sysctl.conf
sed -i '/vm.dirty_background_bytes/d' /etc/sysctl.conf
sed -i '/vm.dirty_background_ratio/d' /etc/sysctl.conf
sed -i '/vm.dirty_bytes/d' /etc/sysctl.conf
cat<<endoff>>/etc/sysctl.conf
fs.suid_dumpable = 0
kernel.randomize_va_space = 2
net.ipv4.ip_forward = 0
net.ipv4.conf.all.send_redirects = 0
net.ipv4.conf.default.send_redirects = 0
net.ipv4.conf.all.accept_source_route = 0
net.ipv4.conf.all.accept_redirects = 0
net.ipv4.conf.all.secure_redirects = 1
net.ipv4.conf.default.secure_redirects = 1
net.ipv4.conf.all.log_martians = 1
net.ipv4.conf.default.log_martians = 1
net.ipv4.icmp_echo_ignore_broadcasts = 1
net.ipv4.icmp_ignore_bogus_error_responses = 1
net.ipv4.conf.all.rp_filter = 1
net.ipv4.conf.default.rp_filter = 1
net.ipv6.conf.all.accept_ra = 0
net.ipv6.conf.default.accept_ra = 0
net.ipv6.conf.all.accept_redirects = 0
net.ipv6.conf.default.accept_redirects = 0
kernel.shmmax = 50000000000
kernel.shmmni = 40960
kernel.shmall = 40000000000
kernel.sem = 1000 40960000 1000 40960
kernel.sysrq = 1
kernel.core_uses_pid = 1
kernel.msgmnb = 1048576
kernel.msgmax = 1048576
kernel.msgmni = 32768
net.ipv4.tcp_syncookies = 1
net.ipv4.conf.default.accept_source_route = 0
net.ipv4.tcp_max_syn_backlog = 32768
net.ipv4.tcp_syn_retries = 3
net.ipv4.tcp_tw_recycle = 0
net.ipv4.conf.all.arp_filter = 1
net.ipv4.ip_local_port_range = 1025 65535
net.ipv4.ip_local_reserved_ports = 5432,40000-40127,41000-41127,50000-50127,51000-51127
net.ipv6.conf.all.disable_ipv6 = 1
net.ipv6.conf.default.disable_ipv6 = 1
net.core.netdev_max_backlog = 80000
net.core.rmem_default = 2097152
net.core.rmem_max = 16777216
net.core.wmem_max = 16777216
vm.overcommit_memory = 2
vm.overcommit_ratio = 95
vm.swappiness = 0
vm.zone_reclaim_mode = 0
vm.dirty_expire_centisecs = 200
vm.dirty_writeback_centisecs = 100
vm.dirty_background_bytes = 0
vm.dirty_background_ratio = 5
vm.dirty_bytes = 0
endo

 

------分隔线----------------------------

锋哥公众号


锋哥微信


关注公众号
【Java资料站】
回复 666
获取 
66套java
从菜鸡到大神
项目实战课程

锋哥推荐