| 失效链接处理 |
|
Greenplum6.4.0安装部署手册 PDF 下载
本站整理下载：
提取码：paa8
相关截图：
主要内容：
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
|
| Java1234官方群25： | 
|
| Java1234官方群25： | 838462530 |
苏公网安备 32061202001004号
