• greenplum 5.7 + gpinitsystem_config


    os: centos 7.4
    gp: greenplum 5.7.0

    # FILE NAME: gpinitsystem_config
    
    # Configuration file needed by the gpinitsystem
    
    ################################################
    #### REQUIRED PARAMETERS
    ################################################
    
    #### Name of this Greenplum system enclosed in quotes.
    ARRAY_NAME="test Greenplum Data Platform"
    
    #### 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=(/u01/greenplum-data)
    
    #### OS-configured hostname or IP address of the master host.
    MASTER_HOSTNAME=node1
    
    #### File system location where the master data directory 
    #### will be created.
    MASTER_DIRECTORY=/u01/greenplum-data
    
    #### 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=UNICODE
    
    ################################################
    #### 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=(/data1/mirror /data1/mirror /data1/mirror /data2/mirror /data2/mirror /data2/mirror)
    
    
    ################################################
    #### OTHER OPTIONAL PARAMETERS
    ################################################
    
    #### Create a database of this name after initialization.
    DATABASE_NAME=peiybdb
    
    #### Specify the location of the host address file here instead of
    #### with the the -h option of gpinitsystem.
    MACHINE_LIST_FILE=/usr/local/greenplum-db/all_segment

    简单说明下
    ARRAY_NAME:设置阵列名称,默认EMC Greenplum DW。
    SEG_PREFIX:设置segment的前缀,默认gpseg。
    PORT_BASE:设置segment的起始端口,会从此端口往上增加,默认从40000开始。
    DATA_DIRECTORY:设置segment primary的数据存储目录,控制每个机器上segment实例个数。
    MASTER_HOSTNAME:设置master的主机名。
    MASTER_DIRECTORY:设置master的存储目录。
    MASTER_PORT:设置master的端口,默认5432。
    TRUSTED_SHELL:设置节点之间的信任方式,默认SSH。
    CHECK_POINT_SEGMENTS:预写日志文件(WAL)数量,默认为8,这意味着为主机上的每个Segment或Master实例分配1088MB的WAL空间。
    ENCODING=UNICODE:设置初始字符集,默认UNICODE(UTF-8)。
    MACHINE_LIST_FILE:仅包含segment主机地址
    注意,其中所有需要的目录都是在创建数据存储区域时做好的。

  • 相关阅读:
    stm32 复位后 引起引脚的变化,输出电平引起的问题
    利用jink的驱动软件j-flash 合并两个hex的方法,bootloader+app
    利用jink调试程序,时间不准的解决办法
    为什么你有10年经验,但成不了专家?
    第二章 信息的表示和处理
    Python人名独特性统计

    Python基本统计值计算
    VScode如何编译多个.C文件
    Python连续质数计算
  • 原文地址:https://www.cnblogs.com/ctypyb2002/p/9793005.html
Copyright © 2020-2023  润新知