centos7.3下 greenplum-db 安装、配置文档

前端之家收集整理的这篇文章主要介绍了centos7.3下 greenplum-db 安装、配置文档前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

centos7.3下 greenplum-db 安装、配置文档

一.系统要求

  • 1.系统版本要求:
    根据官方文档: greenplumd-b支持以下几种linux系统:
  1. SUSE Linux Enterprise Server 64-bit 12 SP2 or SP3,with kernel 4.4.73-5.1 or newer
  2. SUSE Linux Enterprise Server 64-bit 11 SP4
  3.  
  4. CentOS 64-bit 6.x or 7.x
  5.  
  6. Red Hat Enterprise Linux (RHEL) 64-bit 6.x or 7.x
  • 2.文件系统要求:
    数据存储目录为 xfs文件系统

二. centos7.3下安装greenplum-db

  • gp服务器列表

    1. 144.131.252.198 mdw master 主节点
    2. 144.131.252.199 sdw1-1 数据节点1
    3. 144.131.252.144 sdw2-1 数据节点2
    4. 144.131.252.195 sdw3-1 主节点切换备用节点
  • 1.修改系统配置项

    1.1 关闭SELINUX
    vi /etc/selinux/config

    1. SELINUX=disabled

    1.2 关闭防火墙

    1. systemctl status firewalld
    2. systemctl stop firewalld.service
    3. systemctl disable firewalld.service
    4. iptable -L -n

    1.3
    修改内核配置参数,并执行 sysctl -p使之生效
    vi /etc/sysctl.conf

    1. kernel.shmmax = 500000000
    2. kernel.shmmni = 4096
    3. kernel.shmall = 4000000000
    4. kernel.sem = 2000 4096000 2000 2048
    5. kernel.sysrq = 1
    6. kernel.core_uses_pid = 1
    7. kernel.msgmnb = 65536
    8. kernel.msgmax = 65536
    9. kernel.msgmni = 2048
    10. net.ipv4.tcp_syncookies = 1
    11. net.ipv4.ip_forward = 0
    12. net.ipv4.conf.default.accept_source_route = 0
    13. net.ipv4.tcp_tw_recycle = 1
    14. net.ipv4.tcp_max_syn_backlog = 4096
    15. net.ipv4.conf.all.arp_filter = 1
    16. net.ipv4.ip_local_port_range = 1025 65535
    17. net.core.netdev_max_backlog = 10000
    18. net.core.rmem_max = 2097152
    19. net.core.wmem_max = 2097152
    20. vm.overcommit_memory = 2

    1.4
    vi /etc/security/limits.conf

    1. * soft nofile 65536
    2. * hard nofile 65536
    3. * soft nproc 131072
    4. * hard nproc 131072

    1.5
    配置集群中各节点hosts信息
    vi /etc/hosts

  1. 144.131.252.198 mdw # master node
  2. 144.131.252.199 sdw1-1 # segment node 1
  3. 144.131.252.144 sdw2-1 # segment node 2
  4. 144.131.252.195 sdw3-1 # segment node 3

2 安装greenplum-db

2.1 从https://network.pivotal.io/pr...
greenplum-db-5.4.0-rhel7-x86_64.rpm
greenplum-cc-web-3.3.1-LINUX-x86_64.zip
拷贝至mdw(144.131.252.198)主节点/opt目录下
执行

  1. tar -xzvf greenplum-cc-web-3.3.1-LINUX-x86_64.zip
  2. rpm -ivh greenplum-db-5.4.0-rhel7-x86_64.rpm
  3. unzip greenplum-db-5.4.0-rhel7-x86_64.zip
  4. ./greenplum-db-5.4.0-rhel7-x86_64.bin

2.2 按照提示输入安装目录

  1. /opt/greenplum-db

执行

  1. ./greenplum-cc-web-3.3.1-LINUX-x86_64.bin

按照提示输入安装目录

  1. /opt/greenplum-cc-web

解压完成后创建gpadmin用户和组,用来管理greenplum-db

  1. groupadd gpadmin # 创建分组
  2. useradd gpadmin -g gpadmin # 创建用户并分配组
  3. passwd gpadmin # 为gpadmin分配密码
  4. cd /opt/greenplum-db
  5. chown -R gpadmin:gpadmin greenplum-db/
  6. chown -R gpadmin:gpadmin greenplum-cc-web/

2.3 切换到gpadmin用户下:

  1. su - gpadmin
  2. mkdir -p /opt/greenplum-db/gpconfigs
  3. cd /opt/greenplum-db/gpconfigs

创建配置文件

  1. vim hostfile_exkeys
  1. mdw
  2. sdw1-1
  3. sdw2-1
  4. sdw3-1
  1. vi hostfile
  1. sdw1-1
  2. sdw2-1
  3. sdw3-1

2.4 在gpadmin用户添加环境变量

  1. vi ~/.bashrc
  1. #添加以下内容
  2. export LD_LIBRARY_PATH=$GPHOME/lib
  3. export MASTER_DATA_DIRECTORY=/home/gpadmin/gpdata/master/gpseg-1
  4. . /opt/greenplum-db/greenplum_path.sh
  5. . /opt/greenplum-cc-web/gpcc_path.sh
  1. source ~/.bashrc

切换到root用户下,导出环境变量

  1. su - root
  2. vi ~/.bashrc
  1. #添加以下内容
  2. export LD_LIBRARY_PATH=$GPHOME/lib
  3. export MASTER_DATA_DIRECTORY=/home/gpadmin/gpdata/master/gpseg-1
  4. . /opt/greenplum-db/greenplum_path.sh
  5. . /opt/greenplum-cc-web/gpcc_path.sh

执行

  1. source ~/.bashrc
  2. gpssh-exkeys -f hostfile_exkeys #拷贝mster节点公钥至各segment节点
  3. gpseginstall -f /opt/greenplum-db/gpconfigs/hostfile_exkeys -p gpadmin

注:

gpssh-exkeys -f hostfile_exkeys
将会在master节点生成公私钥,并拷贝至hostfile_exkeys各segment节点,实现后续无密钥登陆
gpseginstall -f /opt/greenplum-db/gpconfigs/hostfile_exkeys -p gpadmin
使用默认用户名(gpadmin) 、密码:gpadmin 在各segment节点安装Greenplum—Db

2.5 在master及各segment节点创建数据存储目录

  1. mkdir /home/gpadmin/gpdata/master
  2. cd /home/gpadmin/
  3. chown -R gpadmin:gpadmin gpdata/master
  4. gpssh -f /opt/greenplum-db/gpconfigs/hostfile -e "mkdir -p /home/gpadmin/gpdata/data1/primary;mkdir -p /home/gpadmin/gpdata/data2/primary”
  5. gpssh -f /opt/greenplum-db/gpconfigs/hostfile -e "mkdir -p /home/gpadmin/gpdata/data1/mirror;mkdir -p /home/gpadmin/gpdata/data2/mirror"
  6. gpssh -f /opt/greenplum-db/gpconfigs/hostfile -e "chown -R gpadmin:gpadmin /home/gpadmin/gpdata"
  7. gpssh -f /opt/greenplum-db/gpconfigs/hostfile_exkeys -v -e 'ntpd'

切换到gpadmin用户下,初始化数据库集群

  1. su - gpadmin
  2. cd /opt/greenplum-db/
  3. cp /opt/greenplum-db/docs/cli_help/gpconfigs/gpinitsystem_config /opt/greenplum-db/gpconfigs/gpinitsystem_config
  4. vi /opt/greenplum-db/gpconfigs/gpinitsystem_config
  1. ###修改以下内容
  2. MASTER_HOSTNAME=mdw
  3. PORT_BASE=40000
  4. declare -a DATA_DIRECTORY=(/home/gpadmin/gpdata/data1/primary /home/gpadmin/gpdata/data1/primary /home/gpadmin/gpdata/data2/primary /home/gpadmin/gpdata/data2/primary)
  5. MASTER_DIRECTORY=/home/gpadmin/gpdata/master
  6. MASTER_PORT=5432
  7. MIRROR_PORT_BASE=50000
  8. REPLICATION_PORT_BASE=41000
  9. MIRROR_REPLICATION_PORT_BASE=51000
  10. declare -a MIRROR_DATA_DIRECTORY=(/home/gpadmin/gpdata/data1/mirror /home/gpadmin/gpdata/data1/mirror /home/gpadmin/gpdata/data2/mirror /home/gpadmin/gpdata/data2/mirror)
  11. DATABASE_NAME=gpdb
  12. MACHINE_LIST_FILE=/opt/greenplum-db/gpconfigs/hostfile

2.6 配置修改完成之后,执行以下命令初始化数据库

  1. gpinitsystem -c gpconfigs/gpinitsystem_config -h gpconfigs/hostfile

按照提示输入相应信息,初始化完成后修改master节点:

  1. vi /home/gpadmin/gpdata/master/gpseg-/pg_hba.conf
  1. #添加以下内容(允许172.16网段通过密码登陆)
  2. host all gpadmin 172.16.1.1/16 md5

psql修改数据库密码:

  1. psql -d gpdb
  2. gpdb=# alter user gpadmin with password 'gpadmin'
  3. gpdb=# \q
  4. 重启greenplumdb集群
  1. gpstop -a
  2. gpstart -a

2.7 启动greenplum-db commond center(gpcc)

  1. gpperfmon_install --enable --port 5432 --password gpadmin

重启greenplumdb集群,加载gpperfmon_install采集数据

  1. gpstop -a
  2. gpstart -a

启动web控制台界面

  1. gpcmdr --setup

按照提示输入实例名、监听端口信息等

  1. #Please enter the instance name
  2. gpcc
  3. #Press ENTER to use instance name
  4. gpcc
  5. #Is the master host for the Greenplum Database remote? Yy/Nn (default=N)
  6. N
  7. #What port does the Greenplum Database use? (default=5432)
  8. 5432
  9. #Enable kerberos login for this instance? Yy/Nn (default=N)
  10. N
  11. #What port would you like the new web server to use for this instance? (default=28080)
  12. 28080

启动、停止

  1. gpcmdr --start #启动
  2. gpcmdr --stop #停止

猜你在找的CentOS相关文章