greenplum 4.22配置

vi /etc/sysctl.conf

xfs_mount_options = rw,noatime,inode64,allocsize=16m
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
vm.overcommit_memory = 2

vi /etc/security/limits.conf
* soft nofile 65536
* hard nofile 65536
* soft nproc 131072
* hard nproc 131072

mount 选项
rw,noatime,inode64,allocsize=16m

修改io的读写方式
The Linux disk I/O scheduler for disk access supports different policies, such as CFQ, AS, and deadline.
For example:
echo deadline > /sys/block/sda/queue/scheduler

查看硬盘数据块的读取
# /sbin/blockdev --getra /dev/sdb

修改硬盘读取的块
# /sbin/blockdev --setra 16385 /dev/sda

下载解压
unzip greenplum-db-4.2.x.x-PLATFORM.zip

安装调用
# /bin/bash greenplum-db-4.2.x.x-PLATFORM.bin

安装访问
Do you accept the Greenplum Database license agreement? [yes|no]
********************************************************************************
yes

The installer will prompt you to provide an installation path. Press ENTER
********************************************************************************
Install Greenplum Database into ? [yes|no]
********************************************************************************
yes

/usr/local/greenplum-db-4.2.2.4

su - root
source greenplum_path.sh

useradd gpadmin
passwd gpadmin

vi /etc/all_hosts
local_master
local_segment

gpseginstall -f /etc/all_hosts -u gpadmin -p P@$$word

su - gpadmin
source /usr/local/greenplum-db/greenplum_path.sh

查看安装后的配置
gpssh -f /etc/all_hosts -e ls -l $GPHOME

校验
gpssh-exkeys -f /etc/all_hosts

安装兼容oracle的数据库函数库
psql -d testdb -f \

$GPHOME/share/postgresql/contrib/orafunc.sql

安装镜像机器的元数据地方
gpssh -h smdw -e 'mkdir /data/master'
gpssh -h smdw -e 'chown gpadmin /data/master'

创建segment的文件，用gpssh配置segment机器
source /usr/local/greenplum-db-4.2.x.x/greenplum_path.sh
gpssh -f /home/gpadmin/segment -e 'mkdir /data/primary'
gpssh -f /home/gpadmin/segment -e 'mkdir /data/mirror'
gpssh -f /home/gpadmin/segment -e 'chown gpadmin:gpadmin /data/primary'
gpssh -f /home/gpadmin/segment -e 'chown gpadmin:gpadmin /data/mirror'

配置时钟同步
主服务器配置有ntp的服务器
server 10.6.220.20
节点服务器配置
server local_master prefer
server smdw

同步时钟
gpssh -f /etc/all_hosts -v -e 'ntpd'

安装校验
gpcheck -f /etc/all_hosts -m local_master

测试网络带宽
gpcheckperf -f /etc/all_hosts -r N -d /tmp > subnet1.out

初始化数据库
su - gpadmin
mkdir gpconfigs
cp /usr/local/greenplum-db/docs/cli_help/gpconfigs/gpinitsystem_config /home/gpadmin/gpconfigs/gpinitsystem_config
修改文件master，数据存储目录

执行安装
gpinitsystem -c gpinitsystem_config -h gpconfigs/hostfile_gpinitsystem

查看安装完以后的状态
gpstate -s
会提示你需要配置master_data_directory的状态
20130318:16:42:46:031279 gpstate:local_master:gpadmin-[INFO]:-Starting gpstate with args: -s
20130318:16:42:46:031279 gpstate:local_master:gpadmin-[CRITICAL]:-gpstate failed. (Reason='Environment Variable MASTER_DATA_DIRECTORY not set!') exiting...

增加master的环境变量
vi .bash_profile

source /usr/local/greenplum-db/greenplum_path.sh
export MASTER_DATA_DIRECTORY=/data/master/gpseg-1
export PGPORT=5432
export PGUSER=gpadmin
export PGDATABASE=EMC Greenplum DW

拷贝
$ scp .bashrc standby_hostname:`pwd`

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25223017/viewspace-756515/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25223017/viewspace-756515/