|
greenplum数据库集群的安装实例(续)--greenplum集群的安装
3、greenplum集群的安装
1)greenplum集群软件greenplum官网上下载,本实例用到的版本是greenplum-db-4.0.0.0-build-1-RHEL5-i386.zip。安装greenplum数据库集群时,大部分工作都是主节点master host上完成的。本实例中的master host为:
OS:Redhat Enterprise 5
HOSTNAME:linux84
IP:172.16.3.84
2) 所有安装机器(linux84, rhel-1, rhel-2)参数文件的修改
编辑/etc/sysctl.conf,修改下列参数项:
kernel.shmmax = 500000000
kernel.shmmni = 4096
kernel.shmall = 4000000000
kernel.sem = 250 64000 100 512
net.ipv4.tcp_tw_recycle=1
net.ipv4.tcp_max_syn_backlog=4096
net.core.netdev_max_backlog=10000
vm.overcommit_memory=2
net.ipv4.ip_local_port_range = 1025 65535
编辑/etc/security/limits.conf,修改下列参数项:
* soft nofile 65536
* hard nofile 65536
* soft nproc 131072
* hard nproc 131072
3)修改主节点linux84的 /etc/hosts文件
添加代码行:
172.16.3.84 linux84
172.16.17.101 rhel-1
172.16.17.202 rhel-2
4)开始安装(172.16.3.84机器上安装)
a.root用户下创建greenplum管理员用户
172.16.3.84机器
# useradd gpadmin
#passwd gpadmin
172.16.17.101机器
# useradd gpadmin
# passwd gpadmin
172.16.17.101机器
# useradd gpadmin
#passwd gpadmin
b.root用户下解压安装文件
# unzip /app/greenplum/greenplum-db-4.0.0.0-build-1-RHEL5-i386.zip
提示安装目录,输入:/app/greenplum/gp4.0
然后:
# mkdir /app/greenplum/masterdata
# chown -R gpadmin.gpadmin /app/greenplum
c.172.16.3.84机器上创建如下文件
/home/gpadmin/all_host
文件内容:
172.16.3.84
172.16.17.101
172.16.17.202
/home/gpadmin/seg_host
172.16.17.101
172.16.17.202
d.172.16.3.84机器 环境变量设置
# source /app/greenplum/gp4.0/greenplum-db/greenplum_path.sh
将文件greenplum-db/greenplum_path.sh中的环境变量
添加到pgadmin的user’s startup shell profile(such as /home/gpadmin/.bashrc)中,
然后,
$ source~/.bashrc
e. 172.16.3.84机器上交换ssh keys
在root用户运行命令:
# gpssh-exkeys -f /home/gpadmin/all_host
在gpadmin用户运行命令:
$ gpssh-exkeys -f /home/gpadmin/all_host
f.创建segment host 的安装包并传送到segment host
# su - gpadmin
$ gtar -cvf /home/gpadmin/gp.tar /app/greenplum/gp4.0
$ gpssh -f /home/gpadmin/seg_host
=>mkdir /app/greenplum
=>mkdir /app/greenplum/segdata
=>chown -R gpadmin.gpadmin /app/greenplum
$ gpscp -f /home/gpadmin/seg_host /home/gpadmin/gp.tar=:/app/greenplum
$ gpssh -f /home/gpadmin/seg_host
=>gtar --directory /app/greenplum -xvf /app/greenplum/gp.tar
=>ln -s /app/greenplum/gp4.0 /app/greenplum/greenplum-db
=>chown -R gpadmin.gpadmin /app/greenplum
=>rm /app/greenplum/gp.tar
g.所有机器的时间同步
$ gpssh-f /home/gpadmin/all_host -v date
$ gpssh-f /home/gpadmin/all_host -v ntpd
h.os的检查验证
# su - gpadmin
$ pcheckos -f /home/gpadmin/all_host
如果验证未通过,则需根据提示进行相应配置,时间未同步可以忽略。
i.创建greenplum 安装配置文件
# su - gpadmin
$ cp $GPHOME/docs/cli_help/gp_init_config_example /home/gpadmin/gp_init_config
$ vi gp_init_config
文件 gp_init_config 内容如下:
ARRAY_NAME="Greenplum"
MACHINE_LIST_FILE=/home/gpadmin/seg_host
SEG_PREFIX=gpseg
PORT_BASE=50000
declare-a DATA_DIRECTORY=(/app/greenplum/segdata /app/greenplum/segdata)
MASTER_HOSTNAME=mdw1
MASTER_DIRECTORY=/app/greenplum/masterdata
MASTER_PORT=5432
TRUSTED SHELL=ssh
CHECK_POINT_SEGMENT=8
ENCODING=UNICODE
j.初始化数据库
# su - gpadmin
$ gpinitsystem -c /home/gpadmin/gp_init_config
=>Continue with Greenplum creation? y
=>Greenplum Database instance successfully created.
k.将MASTER_DATA_DIRECTORY加入环境中
修改 gpadmin用户的.bash_profile以及/etc/profile,加入
MASTER_DATA_DIRECTORY=/app/greenplum/masterdata
export MASTER_DATA_DIRECTORY
整个安装过程完成。 |
|