美文网首页
GreenPlum安装的一些注意事项

GreenPlum安装的一些注意事项

作者: nagioswork | 来源:发表于2016-08-18 19:19 被阅读598次

1、千万要注意主机名不能是localhost,否则会安装失败,在/etc/hosts中添加的主机名称要和服务器的主机名称相同。
就因为这个地方没有注意到,花费一个下午才解决。
添加主机名称的对应关系
<pre>
[gpadmin@gp-node0 gpconfigs]$ more /etc/hosts
11.0.1.200 gp-node0
11.0.1.201 gp-node1
11.0.1.202 gp-node2
11.0.1.203 gp-node3
11.0.1.204 gp-node4
11.0.1.205 gp-node5
11.0.1.206 gp-node6
11.0.1.207 gp-node7
</pre>
修改主机名称
<pre>
[root@localhost ~]# vi /etc/hostname
gp-node2
</pre>

2、所有机器的语言环境比较为en_US.utf8,否则初始化数据库会失败
<pre>
[gpadmin@gp-node0 ~]$ vi .bash_profile

.bash_profile

Get the aliases and functions

if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

User specific environment and startup programs

PATH=$PATH:$HOME/.local/bin:$HOME/bin

export PATH
source /usr/local/greenplum-db-4.3.9.0/greenplum_path.sh
export MASTER_DATA_DIRECTORY=/data/gpdata/master/gpseg-1
export LC_ALL=en_US.UTF-8
export LANG=en_US.utf8
~
".bash_profile" 16L, 362C written
[gpadmin@gp-node0 ~]$ . .bash_profile
[gpadmin@gp-node0 ~]$ locale
LANG=en_US.utf8
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=en_US.UTF-8
</pre>
执行gpinitsystem -c /home/gpadmin/gpconfigs/gpinitsystem_config -h /opt/gpinit/all_host
如果初始化提示:
<pre>
20160818:18:33:28:000853 gpinitsystem:gp-node0:gpadmin-[INFO]:-Checking new segment hosts, please wait...
bash: /bin/locale: No such file or directory
bash: /bin/locale: No such file or directory
执行:
ln -s /usr/bin/locale /bin/locale
</pre>
其他的操作系统参数设置:
A、Linux System Settings
Set the following parameters in the /etc/sysctl.conf
file and reboot:
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、Set the following parameters in the /etc/security/limits.conf file:

  • soft nofile 65536
  • hard nofile 65536
  • soft nproc 131072
  • hard nproc 131072
    其他的磁盘调度、ntp服务、关闭SELinux、关闭防火墙、 磁盘预读取配置就不一一说明,参照官方文档就可
    其他注意事项,GP使用了大量的python脚本,操作系统上的python环境一定要正常,否则会有莫名其妙的错误。
    不想看英文,也可参照:http://www.cnblogs.com/liuyungao/p/5689588.html

相关文章

网友评论

      本文标题: GreenPlum安装的一些注意事项

      本文链接:https://www.haomeiwen.com/subject/cawvsttx.html