怎么快速搭建gp集群-創(chuàng)新互聯(lián)

本篇內(nèi)容介紹了“怎么快速搭建gp集群”的有關(guān)知識，在實際案例的操作過程中，不少人都會遇到這樣的困境，接下來就讓小編帶領(lǐng)大家學(xué)習(xí)一下如何處理這些情況吧！希望大家仔細(xì)閱讀，能夠?qū)W有所成！

成都創(chuàng)新互聯(lián)成都網(wǎng)站建設(shè)按需網(wǎng)站設(shè)計，是成都網(wǎng)站開發(fā)公司,為搬家公司提供網(wǎng)站建設(shè)服務(wù),有成熟的網(wǎng)站定制合作流程，提供網(wǎng)站定制設(shè)計服務(wù)：原型圖制作、網(wǎng)站創(chuàng)意設(shè)計、前端HTML5制作、后臺程序開發(fā)等。成都網(wǎng)站制作熱線：18982081108

1上傳已編譯完的包至/data/目錄

2.解壓

3 修改gpadmin的環(huán)境變量

  1. [gpadmin@DB-01 ~]$ more .bash_profile

  2. # .bash_profile

  4. # Get the aliases and functions

  5. if [ -f ~/.bashrc ]; then

  6.         . ~/.bashrc

  7. fi

  9. # User specific environment and startup programs

  11. PATH=$PATH:$HOME/bin

  13. export PATH

  14. source /data/gpdb/greenplum_path.sh    ---bin目錄

  15. export MASTER_DATA_DIRECTORY=/data/gpdb/gpdata2/gpmaster/gpseg-1  --數(shù)據(jù)目錄

  16. export PGPORT=5432

  17. export PGDATABASE=ecejdatainfo


4 修改初始化配置文件

  1. [gpadmin@DB-01 conf]$  pwd
    /home/gpadmin/conf

  2. [gpadmin@DB-01 conf]$ ll

  3. total 16

  4. -rw-rw-r-- 1 gpadmin gpadmin 2910 May 26 14:04 gpinitsystem_config

  5. -rw-rw-r-- 1 gpadmin gpadmin 2703 Jul  6 20:58 gpinitsystem_config2

  6. -rw-rw-r-- 1 gpadmin gpadmin   62 May 26 10:17 hostlist

  7. -rw-rw-r-- 1 gpadmin gpadmin   51 May 26 10:17 seg_hosts

  8. [gpadmin@DB-01 conf]$ more gpinitsystem_config2   ---修改對應(yīng)的數(shù)據(jù)目錄 /data/gpdb/gpdata2
    # 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=(/data/gpdb/gpdata2/gpdatap1 /data/gpdb/gpdata2/gpdatap2 /data/gpdb/gpdata2/gpdatap3 /data/gpdb/gpdata2/gpdatap4)


    #### 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=/data/gpdb/gpdata2/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=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=(/data/gpdb/gpdata2/gpdatam1 /data/gpdb/gpdata2/gpdatam2 /data/gpdb/gpdata2/gpdatam3 /data/gpdb/gpdata2/gpdatam4)


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


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


    #### Specify the location of the host address file here instead of
    #### with the the -h option of gpinitsystem.
    MACHINE_LIST_FILE=/home/gpadmin/conf/seg_hosts

5 每個segment建立對應(yīng)的節(jié)點目錄

  1. [gpadmin@DB-01 conf]$ cd /data/gpdb/gpdata2/

  2. [gpadmin@DB-01 gpdata2]$ ll

  3. total 36

  4. drwxrwxr-x 2 gpadmin gpadmin 4096 Jul  6 20:57 gpdatam1

  5. drwxrwxr-x 2 gpadmin gpadmin 4096 Jul  6 20:57 gpdatam2

  6. drwxrwxr-x 2 gpadmin gpadmin 4096 Jul  6 20:57 gpdatam3

  7. drwxrwxr-x 2 gpadmin gpadmin 4096 Jul  6 20:57 gpdatam4

  8. drwxrwxr-x 2 gpadmin gpadmin 4096 Jul  6 20:57 gpdatap1

  9. drwxrwxr-x 2 gpadmin gpadmin 4096 Jul  6 20:57 gpdatap2

  10. drwxrwxr-x 2 gpadmin gpadmin 4096 Jul  6 20:57 gpdatap3

  11. drwxrwxr-x 2 gpadmin gpadmin 4096 Jul  6 20:57 gpdatap4

  12. drwxrwxr-x 3 gpadmin gpadmin 4096 Jul  6 20:59 gpmaster


6 初始化

  1. gpinitsystem -c /home/gpadmin/conf/gpinitsystem_config2 -s mdw-s

“怎么快速搭建gp集群”的內(nèi)容就介紹到這里了，感謝大家的閱讀。如果想了解更多行業(yè)相關(guān)的知識可以關(guān)注創(chuàng)新互聯(lián)-成都網(wǎng)站建設(shè)公司網(wǎng)站，小編將為大家輸出更多高質(zhì)量的實用文章！

網(wǎng)站欄目：怎么快速搭建gp集群-創(chuàng)新互聯(lián)
網(wǎng)站鏈接：http://www.muchs.cn/article28/epdcp.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供手機(jī)網(wǎng)站建設(shè)、網(wǎng)站策劃、軟件開發(fā)、品牌網(wǎng)站制作、關(guān)鍵詞優(yōu)化、網(wǎng)站內(nèi)鏈

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時需注明來源： 創(chuàng)新互聯(lián)

成都定制網(wǎng)站建設(shè)