怎么快速搭建gp集群

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

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

2.解壓

3 修改gpadmin的環境變量

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

2. # .bash_profile
   

3. 
   

4. # Get the aliases and functions
   

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

6.         . ~/.bashrc
   

7. fi
   

8. 
   

9. # User specific environment and startup programs
   

10. 
    

11. PATH=$PATH:$HOME/bin
    

12. 
    

13. export PATH
    

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

15. export MASTER_DATA_DIRECTORY=/data/gpdb/gpdata2/gpmaster/gpseg-1  --數據目錄
    

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   ---修改對應的數據目錄 /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建立對應的節點目錄

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集群”的內容就介紹到這里了，感謝大家的閱讀。如果想了解更多行業相關的知識可以關注億速云網站，小編將為大家輸出更多高質量的實用文章！