环境:centos7 ,Greenplum6
软件下载:
链接:https://pan.baidu.com/s/1T2SzxAkpL6ApedE4h0PBKw
提取码:qvka
复制这段内容后打开百度网盘手机App,操作更方便哦
1. Greenplum 6.1 下载
https://github.com/greenplum-db/gpdb/releases/tag/6.1.0
2. 安装环境准备
2.1 关闭SELINUX
• /etc/selinux/config
SELINUX=disabled
2.2关闭防火墙
systemctl stop firewalld.service
systemctl disable firewalld.service
3.安装单机版GP(1master4segment)
gp安装准备
3.1改机器名
#查机器名
unmame -a
#改名为bigdata
hostnamectl set-hostname bigdata
3.2创建gpaadmin用户和用户组
groupadd -g 3030 gpadmin
mkdir /home/gpdata
useradd -u 3030 gpadmin -g gpadmin -d /home/gpdata
passwd gpadmin
(密码bigdata2018)
#补充知识点:删除 groupdel gpadmin userdel gpadmin
3.3配置内核参数
vim /etc/sysctl.conf
以下面内容覆盖原有内容:
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.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 = 10000 65535
net.core.netdev_max_backlog = 10000
net.core.rmem_max = 2097152
net.core.wmem_max = 2097152
vm.overcommit_memory = 2
使生效
sysctl -p
3.4 vim /etc/security/limits.conf
以下面内容覆盖:
- soft nofile 65536
- hard nofile 65536
- soft nproc 131072
- hard nproc 131072
3.5CentOS7需要加入服务logind
echo "RemoveIPC=no" >> /etc/systemd/logind.conf
service systemd-logind restart
3.6重启服务器reboot
4.gp安装
4.1设置host
vim /etc/hosts
添加:172.16.250.106 bigdata
172.16.250.106 这里更改成你自己的ip地址
vim /etc/sysconfig/network
添加:hostname=bigdata
4.2 gp6安装包上传到root目录
yum -y install greenplum-db-6.1.0-rhel6-x86_64.rpm
#默认安装到/usr/local,授权给gpadmin
chown -R gpadmin /usr/local/greenplum*
chgrp -R gpadmin /usr/local/greenplum*
#设置环境变量
source /usr/local/greenplum-db/greenplum_path.sh
4.3创建instance需要的目录
mkdir -p /home/gpdata
mkdir -p /home/gpdata/master
mkdir -p /home/gpdata/gp1
mkdir -p /home/gpdata/gp2
mkdir -p /home/gpdata/gp3
mkdir -p /home/gpdata/gp4
#修改目录属主
chown -R gpadmin:gpadmin /home/gpdata
chown -R gpadmin:gpadmin /home/gpdata/master
chown -R gpadmin:gpadmin /home/gpdata/gp*
4.4切换用户gpadmin
su gpadmin
进入$开头的bash环境
cd
vim .bash_profile
添加以下:
source /usr/local/greenplum-db-6.1.0/greenplum_path.sh
export MASTER_DATA_DIRECTORY=/home/gpdata/master/gpseg-1
export PGPORT=2345
export PGUSER=gpadmin
export PGDATABASE=gpdb
vim .bashrc
添加上文同样内容
4.5设置子节点的host
vim all_hosts_file
添加一行bigdata(单机版只有一个host)
4.6权限互通
gpssh-exkeys -f all_hosts_file
4.7编辑gp初始化文件
vim initgp_config
写入:
SEG_PREFIX=gpseg
PORT_BASE=33000
declare -a DATA_DIRECTORY=(/home/gpdata/gp1 /home/gpdata/gp2 /home/gpdata/gp3 /home/gpdata/gp4)
MASTER_HOSTNAME=bigdata
MASTER_PORT=2345
MASTER_DIRECTORY=/home/gpdata/master
DATABASE_NAME=gpdb
4.8设置节点服务器
vim seg_hosts_file
写入:
bigdata
本例单机,只有bigdata这一台
4.9初始化GP
gpinitsystem -c initgp_config -h seg_hosts_file
5.连接GP
5.1psql登录修改密码
su gpadmin
psql -p 2345
修改数据库密码
alter role gpadmin with password 'bigdata2018';
退出: \q
5.2远程连接配置
vim /home/gpdata/master/gpseg-1/postgresql.conf
修改:
#listen_addresses = '*',去#注释
vim /home/gpdata/master/gpseg-1/pg_hba.conf
添加:
host all gpadmin 0.0.0.0/0 md5
5.3重新加载配置文件
gpstop -u
附录
其他启停命令
gpstart #正常启动
gpstop #正常关闭
gpstop -M fast #快速关闭
gpstop –r #重启
服务器重启后需要在 gpadmin用户下用 gpstart启动gp服务