service NetworkManager stop
systemctl disable NetworkManager
service iptables stop
service ip6tables stop
chkconfig iptables off
chkconfig ip6tables off
systemctl disable firewalld
systemctl stop firewalld
vi /etc/selinux/config
vi /etc/hosts
vi /etc/sysctl.conf
kernel.sem = 500 2048000 200 4096
vi /etc/security/limits.conf
* soft nofile 524288
* hard nofile 524288
* soft nproc 131072
* hard nproc 131072
useradd gpadmin
yum install ed -y
mkdir /data1
chown gpadmin:gpadmin /data1/
mkdir master
mkdir p1 p2
root :yum install -y greenplum-db-6.13.0-rhel7-x86_64.rpm
cd ~
vi all_host
greenplum1
greenplum2
greenplum3
su - gpadmin
source /usr/local/greenplum-db/greenplum_path.sh
mkdir .ssh
chmod 700 ~/.ssh
ssh-keygen -t rsa
ssh-copy-id -i gpadmin@greenplum1
gpssh-exkeys -f all_host
三节点：
vi .bashrc
source /usr/local/greenplum-db/greenplum_path.sh
export MASTER_DATA_DIRECTORY=/data1/master/gpseg-1
export PGPORT=5432
export PGUSER=gpadmin
PATH=$PATH:$HOME/.local/bin:$HOME/bin
export PATH
主节点：
vi seg_host
greenplum2
greenplum3
复制参数文件
cp $GPHOME/docs/cli_help/gpconfigs/gpinitsystem_config /home/gpadmin/gpinitsystem_config
修改
vi gpinitsystem_config
declare -a DATA_DIRECTORY=(/data1/p1 /data1/p2)
MASTER_HOSTNAME=greenplum1
MASTER_DIRECTORY=/data1/master
declare -a MIRROR_DATA_DIRECTORY=(/data1/m1 /data1/m2 )
集群初始化
gpinitsystem -c gpinitsystem_config -h seg_host
创建数据库
createdb -h 127.0.0.1 -p 5432 gpadmin
Standby初始化
gpinitstandby -s greenplum3
---------gptext安装-----------------
三节点：
yum install -y java-1.8.0-openjdk.x86_64
yum -y install nc
yum -y install lsof
主节点：
su - gpadmin
gpssh -f all_host
=>mkdir /usr/local/greenplum-text-3.7.0
=>mkdir /usr/local/greenplum-solr
=> mkdir /data1/gptext
=> exit
vi gptext_install_config
declare -a GPTEXT_HOSTS=(greenplum1 greenplum2 greenplum3)
declare -a DATA_DIRECTORY=(/data1/gptext/p1 /data1/gptext/p2)
JAVA_OPTS="-Xms2048M -Xmx2048M"
declare -a ZOO_HOSTS=(greenplum1 greenplum2 greenplum3)
ZOO_DATA_DIR="/data1/gptext/master/"
安装gptext:
./greenplum-text-3.1.0-rhel6_x86_64.bin -c gptext_install_config
启动gptext
source $GPHOME/greenplum_path.sh
source /usr/local/greenplum-text-3.1.0/greenplum-text_path.sh
gptext-installsql bigdata //在数据库安装gptext实例，bigdata是本地数据库
gptext-start //启动gptext
----------gpcc安装-------------
安装前检查：
gpstate确认greenplum数据库已被安装并正在运行
环境变量MASTER_DATA_DIRECTORY已设置并生效
gpadmin有/usr/local/的写权限
28080为默认的web客户端口，确认未被占用 netstat -aptn| grep 28080
8899为RPC端口，确认未被占用：netstat -aptn| grep 8899
确认依赖包apr-util已被安装：rpm -q apr-util
unzip greenplum-cc-web-6.5.0-gp6-rhel7-x86_64.zip
cd /home/gpadmin/greenplum-cc-web-6.5.0-gp6-rhel7-x86_64
gpccinstall -W
vi .bashrc
source /usr/local/greenplum-cc-6.5.0/gpcc_path.sh
source /usr/local/greenplum-text-3.7.0/greenplum-text_path.sh
vi .pgpass
*:5432:gpperfmon:gpmon:123456
gpcc status
gpcc start
vi /data1/master/gpseg-1/pg_hba.conf
添加
host all all 0.0.0.0/0 trust
gpstop
gpstart
