真正搭建部署greenplum

来源:互联网 发布:java四大特性简单概述 编辑:程序博客网 时间:2024/06/05 00:40

       因为工作的需要,最近一直在研究greenplum,网上看了大量的安装教程,没有一个是完整并且清晰的,我今天成功搭建了单机的greenplum的数据库,今天和大家分享一下。

一:下载greenplum软件,可以去官网下载,需要登录和注册。我这边下载的是greenplum-db-4.3.10.0-build-1-rhel5-x86_64.zip软件。

        二:创建gpadmin用户,因为greenplum默认的用户为gpadmin,所以最好是gpadmin的

useradd -d /home/gpadmin -m gpadmin

        三:解压greenplum的软件,直接运行greenplum这个软件

                1,

选择yes


默认的是/user/local/greenplum-db-4.3.10.0,我这边用的是


    2,将linux的hostname改成mdw,这个网上可以查看教程,通过hostname可以看到mdw就可以了。

    3,在安装文件greenplum中创建2个文件seg_hosts和hostlist,分别在上面写入mdw

   4, 在greenplum的目录下面执行以下命令 ./bin/gpssh-exkeys -f hostlist 

   5,新建数据目录

      

mkdir -p greenplum/gpdata/gpmaster

mkdir -p greenplum/gpdata/gpdatap1

mkdir -p greenplum/gpdata/gpdatap2

mkdir -p greenplum/gpdata/gpdatam1

mkdir -p greenplum/gpdata/gpdatam2

  6,greenplum/docs/cli_help/gpconfigs/gpinitsystem_config 复制到~/greenplum下面

  7,修改该文件

     # FILE NAME: gpinitsystem_config


# Configuration file needed by the gpinitsystem


################################################
#### REQUIRED PARAMETERS
################################################


#### Name of this Greenplum system enclosed in quotes.
ARRAY_NAME
="EMC Greenplum DW"


#### Naming convention for utility-generated data directories.
SEG_PREFIX
=gpseg


#### Base number by which primary segment port numbers 
#### are calculated.
PORT_BASE=40000


#### File system location(s) where primary segment data directories 
#### will be created. The number of locations in the list dictate
#### the number of primary segments that will get created per
#### physical host (if multiple addresses for a host are listed in 
#### the hostfile, the number of segments will be spread evenly across
#### the specified interface addresses).
declare -a DATA_DIRECTORY
=(/home/gpadmin/greenplum/gpdata/gpdatap1 /home/gpadmin/greenplum/gpdata/gpdatap2)


#### OS-configured hostname or IP address of the master host.
MASTER_HOSTNAME=mdw


#### File system location where the master data directory 
#### will be created.
MASTER_DIRECTORY
=/home/gpadmin/greenplum/gpdata/gpmaster


#### Port number for the master instance. 
MASTER_PORT=5432


#### Shell utility used to connect to remote hosts.
TRUSTED_SHELL=ssh


#### Maximum log file segments between automatic WAL checkpoints.
CHECK_POINT_SEGMENTS=8


#### Default server-side character set encoding.
ENCODING
=utf-8


################################################
#### OPTIONAL MIRROR PARAMETERS
################################################


#### Base number by which mirror segment port numbers 
#### are calculated.
#MIRROR_PORT_BASE=50000


#### Base number by which primary file replication port 
#### numbers are calculated.
#REPLICATION_PORT_BASE=41000


#### Base number by which mirror file replication port 
#### numbers are calculated. 
#MIRROR_REPLICATION_PORT_BASE=51000


#### File system location(s) where mirror segment data directories 
#### will be created. The number of mirror locations must equal the
#### number of primary locations as specified in the 
#### DATA_DIRECTORY parameter.
#
declare -a MIRROR_DATA_DIRECTORY=(/home/gpadmin/greenplum/gpdata/gpdatam1 /home/gpadmin/greenplum/gpdata/gpdatam2)




################################################
#### OTHER OPTIONAL PARAMETERS
################################################


#### Create a database of this name after initialization.
DATABASE_NAME=test


#### Specify the location of the host address file here instead of
#### with the the -h option of gpinitsystem.
MACHINE_LIST_FILE
=/home/gpadmin/greenplum/docs/cli_help/gpconfigs/hostfile_gpinitsystem

以上红色清仔细核对路径是否正确


四: 

bin/gpseginstall -f  hostlsit -u gpadmin -p 123123


五:

创建seg_hosts_ip,里面写服务器的真实IP

.bin/gpinitsystem -c gpinitsystem_config -h seg_hosts_ip

中间会有选择YES/NO 一直选择YES


原创粉丝点击