CentOS 安装Greenplum
官方安装文档
节点规划
master 主节点
node1 segment 节点
node2 segment 节点
环境配置
配置主机名与host映射(此步省略)
关闭防火墙(此步省略)
依次修改三个节点 /etc/sysctl.conf
kernel.shmall = 4000000000
kernel.shmmax = 500000000
kernel.shmmni = 4096
vm.overcommit_memory = 2
vm.overcommit_ratio = 95
net.ipv4.ip_local_port_range = 10000 65535
kernel.sem = 500 2048000 200 40960
kernel.sysrq = 1
kernel.core_uses_pid = 1
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.msgmni = 2048
net.ipv4.tcp_syncookies = 1
net.ipv4.conf.default.accept_source_route = 0
net.ipv4.tcp_max_syn_backlog = 4096
net.ipv4.conf.all.arp_filter = 1
net.core.netdev_max_backlog = 10000
net.core.rmem_max = 2097152
net.core.wmem_max = 2097152
vm.swappiness = 10
vm.zone_reclaim_mode = 0
vm.dirty_expire_centisecs = 500
vm.dirty_writeback_centisecs = 100
vm.dirty_background_ratio = 0
vm.dirty_ratio = 0
vm.dirty_background_bytes = 1610612736
vm.dirty_bytes = 4294967296
sysctl -p
安装
下载安装包
curl https://github.com/greenplum-db/gpdb/releases/download/6.0.1/greenplum-db-6.0.1-rhel6-x86_64.rpm
安装RPM包
rpm -ivh greenplum-db-6.0.1-rhel6-x86_64.rpm
配置环境变量
vim /etc/profile
GPHOME=/usr/local/greenplum-db
EXPORT path="$GPHOME/bin:$PATH"
source /etc/profile
vim /usr/local/greenplum-db/greenplum_path.sh
GPHOME=$GPHOME
配置节点文件
cd /usr/local/greenplum-db
vi hostfile_exkeys
master
node1
node2
vi hostfile_segments
node1
node2
Master节点添加gpadmin账户
groupadd gpadmin
useradd gpadmin -r -m -g gpadmin
passwd gpadmin
chown -R gpadmin:gpadmin /usr/local/greenplum-db-6.0.1
chown -R gpadmin:gpadmin /usr/local/greenplum-db
打通各节点 用户 gpadmin SSH登录
source /usr/local/greenplum-db/greenplum_path.sh
gpssh-exkeys -f hostfile_exkeys
安装后检查
gpssh -f hostfile_exkeys -v -e 'ntpd'
配置数据库
su - gpadmin
cp $GPHOME/docs/cli_help/gpconfigs/gpinitsystem_config ./gpinit_config
vi gpinit_config
declare -a DATA_DIRECTORY=(/data/gpdata/primary)
MASTER_DIRECTORY=/data/gpdata/gpmaster
ENCODING=UTF8
gpinitsystem -c gpinit_config -h hostfile_segments
查看集群状态
gpstate -d /data/gpdata/gpmaster/gpseg-1
登录
本地登录
psql -d postgres
\l
CREATE USER test1 WITH PASSWORD 'test1' NOSUPERUSER;
远程登录
cd /data/gpdata/gpmaster/gpseg-1
vim pg_hba.config
host all test1 all md5
pg_ctl reload -D /data/gpdata/gpmaster/gpseg-1
psql -U userName -h hostName dbName