Greenplum - Linux安装文档

[root@mdw greenplum-db]# source greenplum_path.sh [root@mdw greenplum-db]# [root@mdw greenplum-db]# env HOSTNAME=mdw TERM=vt100 SHELL=/bin/bash HISTSIZE=1000

SSH_CLIENT=192.168.4.100 57120 22 GPHOME=/usr/local/greenplum-db/. OLDPWD=/usr/local SSH_TTY=/dev/pts/1 USER=root

LD_LIBRARY_PATH=/usr/local/greenplum-db/./lib:/usr/local/greenplum-db/./ext/python/lib: LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*.sh=01;32:*.csh=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35: MAIL=/var/spool/mail/root

PATH=/usr/local/greenplum-db/./bin:/usr/local/greenplum-db/./ext/python/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin INPUTRC=/etc/inputrc

PWD=/usr/local/greenplum-db LANG=en_US.UTF-8

PYTHONHOME=/usr/local/greenplum-db/./ext/python SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass SHLVL=1 HOME=/root

OPENSSL_CONF=/usr/local/greenplum-db/./etc/openssl.cnf PYTHONPATH=/usr/local/greenplum-db/./lib/python LOGNAME=root CVS_RSH=ssh

SSH_CONNECTION=192.168.4.100 57120 192.168.4.108 22 LESSOPEN=|/usr/bin/lesspipe.sh %s G_BROKEN_FILENAMES=1 _=/bin/env

[root@mdw greenplum-db]# cd /tmp [root@mdw tmp]# ls

gconfd-root mapping-root VMwareDnD greenplum-db-4.2.2.4-build-1-CE-RHEL5-i386.bin README_INSTALL vmware-file-mod0 greenplum-db-4.2.2.4-build-1-CE-RHEL5-i386.zip vmware-config0 vmware-root [root@mdw tmp]# vi all_hosts

mdw

sdw2 sdw3

[root@mdw tmp]# gpseginstall -f all_hosts -u gpadmin -p gpadmin (这步安装很长,很容易报错，输入密码，多敲几次，需要等等)

20141104:01:14:11:015674 gpseginstall:mdw:root-[INFO]:-Installation Info: link_name greenplum-db

binary_path /usr/local/greenplum-db-4.2.2.4 binary_dir_location /usr/local

binary_dir_name greenplum-db-4.2.2.4

20141104:01:14:11:015674 gpseginstall:mdw:root-[INFO]:-check cluster password access *** Enter password for mdw:

20141104:01:14:15:015674 gpseginstall:mdw:root-[INFO]:-de-duplicate hostnames 20141104:01:14:16:015674 gpseginstall:mdw:root-[INFO]:-master hostname: mdw

20141104:01:14:18:015674 gpseginstall:mdw:root-[INFO]:-check for user gpadmin on cluster 20141104:01:14:18:015674 gpseginstall:mdw:root-[INFO]:-add user gpadmin on master 20141104:01:14:19:015674 gpseginstall:mdw:root-[INFO]:-add user gpadmin on cluster

20141104:01:14:19:015674 gpseginstall:mdw:root-[INFO]:-chown -R gpadmin:gpadmin /usr/local/greenplum-db

20141104:01:14:19:015674 gpseginstall:mdw:root-[INFO]:-chown -R gpadmin:gpadmin /usr/local/greenplum-db-4.2.2.4 20141104:01:14:19:015674 gpseginstall:mdw:root-[INFO]:-rm -f /usr/local/greenplum-db-4.2.2.4.tar; rm -f /usr/local/greenplum-db-4.2.2.4.tar.gz 20141104:01:14:19:015674 gpseginstall:mdw:root-[INFO]:-cd /usr/local; tar cf greenplum-db-4.2.2.4.tar greenplum-db-4.2.2.4 20141104:01:14:31:015674 gpseginstall:mdw:root-[INFO]:-gzip /usr/local/greenplum-db-4.2.2.4.tar

20141104:01:14:42:015674 gpseginstall:mdw:root-[INFO]:-remote command: mkdir -p /usr/local 20141104:01:14:43:015674 gpseginstall:mdw:root-[INFO]:-remote command: rm -rf /usr/local/greenplum-db-4.2.2.4

20141104:01:14:43:015674 gpseginstall:mdw:root-[INFO]:-scp software to remote location root@sdw3's password: root@sdw2's password: root@sdw3's password: root@sdw2's password:

root@sdw2's password: （输入密码）

20141104:01:15:41:015674 gpseginstall:mdw:root-[INFO]:-remote command: gzip -f -d /usr/local/greenplum-db-4.2.2.4.tar.gz

20141104:01:15:49:015674 gpseginstall:mdw:root-[INFO]:-md5 check on remote location

20141104:01:15:51:015674 gpseginstall:mdw:root-[INFO]:-remote command: cd /usr/local; tar xf greenplum-db-4.2.2.4.tar

20141104:01:16:01:015674 gpseginstall:mdw:root-[INFO]:-remote command: rm -f /usr/local/greenplum-db-4.2.2.4.tar

20141104:01:16:04:015674 gpseginstall:mdw:root-[INFO]:-remote command: cd /usr/local; rm -f

greenplum-db; ln -fs greenplum-db-4.2.2.4 greenplum-db

20141104:01:16:05:015674 gpseginstall:mdw:root-[INFO]:-remote command: chown -R gpadmin:gpadmin /usr/local/greenplum-db

20141104:01:16:05:015674 gpseginstall:mdw:root-[INFO]:-remote command: chown -R gpadmin:gpadmin /usr/local/greenplum-db-4.2.2.4 20141104:01:16:05:015674 gpseginstall:mdw:root-[INFO]:-rm -f /usr/local/greenplum-db-4.2.2.4.tar.gz 20141104:01:16:06:015674

gpseginstall:mdw:root-[INFO]:-/usr/local/greenplum-db/./sbin/gpchangeuserpassword --user gpadmin --password gpadmin 20141104:01:16:13:015674 gpseginstall:mdw:root-[INFO]:-remote command: . /usr/local/greenplum-db/./greenplum_path.sh;

/usr/local/greenplum-db/./sbin/gpchangeuserpassword --user gpadmin --password gpadmin 20141104:01:16:16:015674 gpseginstall:mdw:root-[INFO]:-exchange ssh keys for user root 20141104:01:16:29:015674 gpseginstall:mdw:root-[INFO]:-exchange ssh keys for user gpadmin 20141104:01:16:34:015674

gpseginstall:mdw:root-[INFO]:-/usr/local/greenplum-db/./sbin/gpfixuserlimts -f /etc/security/limits.conf -u gpadmin 20141104:01:16:35:015674 gpseginstall:mdw:root-[INFO]:-remote command: . /usr/local/greenplum-db/./greenplum_path.sh; /usr/local/greenplum-db/./sbin/gpfixuserlimts -f /etc/security/limits.conf -u gpadmin

20141104:01:16:36:015674 gpseginstall:mdw:root-[INFO]:-version string on master: gpssh version 4.2.2.4 build 1 Community Edition 20141104:01:16:36:015674 gpseginstall:mdw:root-[INFO]:-remote command: . /usr/local/greenplum-db/./greenplum_path.sh; /usr/local/greenplum-db/./bin/gpssh --version 20141104:01:16:37:015674 gpseginstall:mdw:root-[INFO]:-remote command: . /usr/local/greenplum-db-4.2.2.4/greenplum_path.sh; /usr/local/greenplum-db-4.2.2.4/bin/gpssh --version

20141104:01:16:42:015674 gpseginstall:mdw:root-[INFO]:-SUCCESS -- Requested commands completed

[root@mdw tmp]#

[root@mdw tmp]# cd /home/ [root@mdw home]# ls gpadmin pushi

[root@mdw home]# su - gpadmin [gpadmin@mdw ~]$

[root@mdw tmp]# cd /usr/local/ [root@mdw local]# ls

bin etc games greenplum-db greenplum-db-4.2.2.4 include lib libexec sbin share src

[root@sdw2 local]# su - gpadmin [root@sdw2 local]# ls

bin etc games greenplum-db greenplum-db-4.2.2.4 greenplum-db-4.2.2.4.tar.gz

include lib libexec sbin share src

[root@sdw2 local]# su - gpadmin [gpadmin@sdw2 ~]$

[root@sdw3 local]# ls

bin etc games greenplum-db greenplum-db-4.2.2.4 greenplum-db-4.2.2.4.tar.gz include lib libexec sbin share src [root@sdw3 local]# su - gpadmin [gpadmin@sdw3 ~]$

安装Greenplum(3) 1

在所有主机上初始化配置Greenplum 验证操作系统设置

初始化Greenplum数据库系统

课程目标

2在所有主机上初始化配置Greenplum 验证安装

a) 切换到gpamdin用户并获取环境变量 $ su - gpadmin # source /usr/local/greenplum-db/greenplum_path.sh

b) 使用gpssh工具来测试无密码登录所有主机 $ gpssh -f /tmp/all_hosts -e ls -l $GPHOME

c) 将\添加到.bashrc文件最后

[root@mdw local]# su - gpadmin [gpadmin@mdw ~]$ cat .bashrc # .bashrc

# Source global definitions if [ -f /etc/bashrc ]; then . /etc/bashrc fi

# User specific aliases and functions [gpadmin@mdw ~]$ env HOSTNAME=mdw SHELL=/bin/bash TERM=vt100 HISTSIZE=1000 USER=gpadmin