欧美一级特黄大片做受成人-亚洲成人一区二区电影-激情熟女一区二区三区-日韩专区欧美专区国产专区

greenplum集群安裝配置(生產(chǎn)環(huán)境)

集群系統(tǒng)初始化信息:

https://blog.51cto.com/michaelkang/2167195

10年積累的網(wǎng)站建設、做網(wǎng)站經(jīng)驗,可以快速應對客戶對網(wǎng)站的新想法和需求。提供各種問題對應的解決方案。讓選擇我們的客戶得到更好、更有力的網(wǎng)絡服務。我雖然不認識你,你也不認識我。但先網(wǎng)站設計后付款的網(wǎng)站建設流程,更有邛崍免費網(wǎng)站建設讓你可以放心的選擇與我們合作。

本文對敏感信息進行了替換!?。?!

下載軟件包:

cd /workspace/gpdb/

wget dl.#kjh#.com/greenplum-db-5.10.2-rhel7-x86_64.rpm

RPM方式,

默認安裝到 /usr/local/greenplum-db/ (以root在master執(zhí)行)
rpm -Uvh greenplum-db-5.10.2-rhel7-x86_64.rpm

建立節(jié)點信任關系
打通master到各節(jié)點的免密碼登錄 (以root在master執(zhí)行)
source /usr/local/greenplum-db/greenplum_path.sh

gpssh-exkeys -f /workspace/gpdb/gp-all.txt
安裝各個節(jié)點,并建立gpadmin用戶(以root在master執(zhí)行)
gpseginstall -f /workspace/gpdb/gp-all.txt -u gpadmin -p gpadmin
安裝后檢查
source /usr/local/greenplum-db/greenplum_path.sh

gpcheck -f /workspace/gpdb/gp-all.txt -m gpnode615.kjh.com  gpnode616.kjh.com \
-s gpnode611.kjh.com gpnode612.kjh.com  gpnode613.kjh.com gpnode614.kjh.com
創(chuàng)建服務安裝文件夾 (root用戶master節(jié)點執(zhí)行)

#gpssh工具可以同時在多個機器上執(zhí)行相同命令,和ansible功能類似

/usr/local/gpdata :master 數(shù)據(jù)數(shù)據(jù)目錄
/data/gpdata :sg 數(shù)據(jù)數(shù)據(jù)目錄
/data01/gpdata :sg 數(shù)據(jù)數(shù)據(jù)目錄

gpssh -f /workspace/gpdb/gp-all.txt
=>

groupadd -g 1888 gpadmin
useradd -g 1888 -u 1888 -m -d /home/gpadmin -s /bin/bash gpadmin
chown -R gpadmin.gpadmin /home/gpadmin
echo "gpadmin" | passwd --stdin gpadmin

mkdir -p /usr/local/gpdata/gpmaster
mkdir -p /data/gpdata/primary
mkdir -p /data01/gpdata/primary

mkdir /data/gpdata/mirror
mkdir /data01/gpdata/mirror

chown -R gpadmin:gpadmin /usr/local/gpdata
chown -R gpadmin:gpadmin /data/gpdata
chown -R gpadmin:gpadmin /data01/gpdata
驗證
=> df -h|grep data
[gpnode611.kjh.com] /dev/sdb        894G   33M  894G    1% /data01
[gpnode611.kjh.com] /dev/sda        894G   33M  894G    1% /data
[gpnode612.kjh.com] /dev/sda        932G   33M  932G    1% /data01
[gpnode612.kjh.com] /dev/sdb        894G   33M  894G    1% /data
[gpnode614.kjh.com] /dev/sda        932G   33M  932G    1% /data01
[gpnode614.kjh.com] /dev/sdb        932G   33M  932G    1% /data
[gpnode613.kjh.com] /dev/sdb        932G   33M  932G    1% /data
[gpnode613.kjh.com] /dev/sda        932G   33M  932G    1% /data01
設置gpadmin賬戶的環(huán)境(gpadmin賬戶操作,master節(jié)點配置)
修改.bashrc
su - gpadmin 
cat >>/home/gpadmin/.bashrc<<-EOF
source /usr/local/greenplum-db/greenplum_path.sh 
export MASTER_DATA_DIRECTORY=/usr/local/gpdata/gpmaster/gpseg-1 
export PGPORT=5432
EOF
修改.bash_profile
su - gpadmin 
cat >>/home/gpadmin/.bash_profile<<-EOF
source /usr/local/greenplum-db/greenplum_path.sh
export MASTER_DATA_DIRECTORY=/usr/local/gpdata/gpmaster/gpseg-1
export PGPORT=5432
EOF
使之生效
source ~/.bashrc
source ~/.bash_profile
segment 節(jié)點 (/etc/hosts文件中的hostname或alias一致)
cat >/usr/local/greenplum-db/all_segment<<-EOF
gpnode611.kjh.com 
gpnode612.kjh.com 
gpnode613.kjh.com 
gpnode614.kjh.com
EOF
驗證
more  /usr/local/greenplum-db/all_segment     
gpnode611.kjh.com 
gpnode612.kjh.com 
gpnode613.kjh.com 
gpnode614.kjh.com
初始化數(shù)據(jù)集群,(gpadmin賬戶操作,master節(jié)點配置)
增加gpinitsystem_config文件為模板

cp $GPHOME/docs/cli_help/gpconfigs/gpinitsystem_config /usr/local/greenplum-db/gpinit_config

配置gpinit_config
vi /usr/local/greenplum-db/gpinit_config

ARRAY_NAME="PT Greenplum Data Platform"
SEG_PREFIX=gpseg
PORT_BASE=40000
declare -a DATA_DIRECTORY=(/data/gpdata/primary /data/gpdata/primary /data01/gpdata/primary /data01/gpdata/primary )
MASTER_HOSTNAME=gpnode615.kjh.com
MASTER_DIRECTORY=/usr/local/gpdata/gpmaster
MASTER_PORT=5432
MIRROR_PORT_BASE=50000
REPLICATION_PORT_BASE=41000
MIRROR_REPLICATION_PORT_BASE=51000
TRUSTED_SHELL=ssh
CHECK_POINT_SEGMENTS=8
ENCODING=UNICODE
DATABASE_NAME=testgpdb
MACHINE_LIST_FILE=/usr/local/greenplum-db/all_segment
declare -a MIRROR_DATA_DIRECTORY=(/data/gpdata/mirror /data/gpdata/mirror /data01/gpdata/mirror /data01/gpdata/mirror)
執(zhí)行初始化,(master節(jié)點 gpadmin 用戶執(zhí)行)

gpinitsystem -c gpinit_config -h hostfile_segments

gpinitsystem命令參數(shù)解釋:
-c:指定初始化文件。
-h:指定segment主機文件。
-s:指定standby主機,創(chuàng)建standby節(jié)點。

su - gpadmin

gpinitsystem -c /usr/local/greenplum-db/gpinit_config -h /usr/local/greenplum-db/all_segment -s gpnode616.kjh.com
初始化過程:
輸出集群初始化配置:
=>[INFO]:-Greenplum Database Creation Parameters
=>[INFO]:---------------------------------------
=>[INFO]:-Master Configuration
=>[INFO]:---------------------------------------
=>[INFO]:-Master instance name       = PT Greenplum Data Platform
=>[INFO]:-Master hostname            = gpnode615.kjh.com
=>[INFO]:-Master port                = 5432
=>[INFO]:-Master instance dir        = /usr/local/gpdata/gpmaster/gpseg-1
=>[INFO]:-Master LOCALE              = en_US.utf8
................
=>[INFO]:-Master IP address [4]      = 172.20.6.15
=>[INFO]:-Master IP address [5]      = 172.20.6.221
................
=>[INFO]:-Standby Master             = gpnode616.kjh.com
=>[INFO]:-Primary segment #          = 4
=>[INFO]:-Standby IP address         = ::1
=>[INFO]:-Standby IP address         = 172.20.6.16
=>[INFO]:-Standby IP address         = 172.20.6.220
....................
=>[INFO]:----------------------------------------
=>[INFO]:-Greenplum Primary Segment Configuration
=>[INFO]:----------------------------------------
=>[INFO]:-gpnode611.kjh.com    /data/gpdata/primary/gpseg0   40000   2       0       41000
=>[INFO]:-gpnode611.kjh.com    /data/gpdata/primary/gpseg1   40001   3       1       41001
=>[INFO]:-gpnode611.kjh.com    /data01/gpdata/primary/gpseg2         40002   4       2       41002
.........................
=>[INFO]:-gpnode614.kjh.com    /data01/gpdata/primary/gpseg14        40002   16      14      41002
=>[INFO]:-gpnode614.kjh.com    /data01/gpdata/primary/gpseg15        40003   17      15      41003
=>[INFO]:---------------------------------------
=>[INFO]:-Greenplum Mirror Segment Configuration
=>[INFO]:---------------------------------------
=>[INFO]:-gpnode612.kjh.com    /data/gpdata/mirror/gpseg0    50000   18      0       51000
=>[INFO]:-gpnode612.kjh.com    /data/gpdata/mirror/gpseg1    50001   19      1       51001
.........................
=>[INFO]:-gpnode611.kjh.com    /data01/gpdata/mirror/gpseg14         50002   32      14      51002
=>[INFO]:-gpnode611.kjh.com    /data01/gpdata/mirror/gpseg15         50003   33      15      51003
查看配置正確,確認是否執(zhí)行?

Continue with Greenplum creation Yy|Nn (default=N):

Y

輸出初始化完成概要信息:
=>
=>[INFO]:------------------------------------------------
=>[INFO]:-Parallel process exit status
=>[INFO]:------------------------------------------------
=>[INFO]:-Total processes marked as completed           = 16
=>[INFO]:-Total processes marked as killed              = 0
=>[INFO]:-Total processes marked as failed              = 0
=>[INFO]:------------------------------------------------
=>[INFO]:-Commencing parallel build of mirror segment instances
............................
=>
=>[INFO]:------------------------------------------------
=>[INFO]:-Parallel process exit status
=>[INFO]:------------------------------------------------
=>[INFO]:-Total processes marked as completed           = 16
=>[INFO]:-Total processes marked as killed              = 0
=>[INFO]:-Total processes marked as failed              = 0
=>[INFO]:------------------------------------------------

.....................略
=>
=>]:-Process results...
=>]:-   Successful segment starts                                            = 32
=>]:-   Failed segment starts                                                = 0
=>]:-   Skipped segment starts (segments are marked down in configuration)   = 0
=>]:-----------------------------------------------------
=>]:-Successfully started 32 of 32 segment instances 
=>]:-----------------------------------------------------
.
=>]:------------------------------------------------------
=>]:-Greenplum standby master initialization parameters
=>]:------------------------------------------------------
=>]:-Greenplum master hostname               = gpnode615.kjh.com
=>]:-Greenplum master data directory         = /usr/local/gpdata/gpmaster/gpseg-1
=>]:-Greenplum master port                   = 5432
=>]:-Greenplum standby master hostname       = gpnode616.kjh.com
=>]:-Greenplum standby master port           = 5432
=>]:-Greenplum standby master data directory = /usr/local/gpdata/gpmaster/gpseg-1
=>]:-Greenplum update system catalog         = On
集群初始化成功輸出信息如下:
=>:-Greenplum Database instance successfully created
=>]:-------------------------------------------------------
=>]:-To complete the environment configuration, please 
=>]:-update gpadmin .bashrc file with the following
=>]:-1. Ensure that the greenplum_path.sh file is sourced
=>]:-2. Add "export MASTER_DATA_DIRECTORY=/usr/local/gpdata/gpmaster/gpseg-1"
=>]:-   to access the Greenplum scripts for this instance:
=>]:-   or, use -d /usr/local/gpdata/gpmaster/gpseg-1 option for the Greenplum scripts
=>]:-   Example gpstate -d /usr/local/gpdata/gpmaster/gpseg-1
=>]:-Script log file = /home/gpadmin/gpAdminLogs/gpinitsystem_20180903.log
=>]:-To remove instance, run gpdeletesystem utility
=>]:-Standby Master gpnode616.kjh.com has been configured
=>]:-To activate the Standby Master Segment in the event of Master
=>]:-failure review options for gpactivatestandby
=>]:-------------------------------------------------------
=>]:-The Master /usr/local/gpdata/gpmaster/gpseg-1/pg_hba.conf post gpinitsystem
=>]:-has been configured to allow all hosts within this new
=>]:-array to intercommunicate. Any hosts external to this
=>]:-new array must be explicitly added to this file
=>]:-Refer to the Greenplum Admin support guide which is
=>]:-located in the /usr/local/greenplum-db/./docs directory
=>]:-------------------------------------------------------
系統(tǒng)登錄初始化設置:
psql修改數(shù)據(jù)庫密碼:
psql -d testgpdb
    gpdb=# alter user gpadmin with password 'gpadmin';
    gpdb=# \q

#### 遠程登陸

psql -p 5432 -d testgpdb 

# 查詢當前版本
select * from version();
設置監(jiān)聽IP和Port
vi ${MASTER_DATA_DIRECTORY}/postgresql.conf

# 設置監(jiān)聽IP (* 生產(chǎn)環(huán)境慎用)
listen_addresses = '${ host ip address } '
port = 5432

#### 設置數(shù)據(jù)庫白名單
vi ${MASTER_DATA_DIRECTORY}/pg_hba.conf

# 增加如下一條記錄,允許用戶密碼模式和可以登陸的IP地址范圍;
#TYPE  DATABASE  USER   CIDR-ADDRESS     METHOD
host    all     gpadmin     0.0.0.0/0        md5

# 測試登陸

psql -p 5432 -h 172.20.6.15 -U gpadmin -d testgpdb 
至此集群配置完成.

可以使用這篇文章的命令查看集群狀態(tài):
https://blog.51cto.com/michaelkang/2169857

參考信息:

https://gpdb.docs.pivotal.io/43170/install_guide/init_gpdb.html
https://gp-docs-cn.github.io/docs/utility_guide/admin_utilities/gprecoverseg.html

新聞名稱:greenplum集群安裝配置(生產(chǎn)環(huán)境)
文章位置:http://aaarwkj.com/article48/peishp.html

成都網(wǎng)站建設公司_創(chuàng)新互聯(lián),為您提供ChatGPT、定制網(wǎng)站微信小程序、標簽優(yōu)化、App開發(fā)、全網(wǎng)營銷推廣

廣告

聲明:本網(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)站建設
青青草原三区在线播放| 中文欧美一区二区精品| 女同伦理视频在线观看| 国产日韩欧在线视频| 国产黄片a三级久久久久久| 在线国产偷拍自拍视频| 国产成人精品无人区一区| 男女生做刺激性视频网站| 欧美日韩在线一区二区精品| 国产亚洲精品第一综合| 国产毛毛片一区二区三区| 日日激情综合久久一区| 蜜桃午夜精品一区二区三区| 粉嫩国产av一区二区三区| 日韩电影在线一本二本三本| 日韩一区二区三区无吗电影| av剧情在线观看免费| 中文字幕日韩欧美一区| 国产成人色污在线观看| 黄色av在线免费观看| 91欧美日韩国产在线观看| 亚洲日本欧洲二区精品| 九九久久精品久久久精品| 亚洲国产精品综合久久久| 东京成人热av男人的天堂| 一区二区先锋深夜中文字幕| 免费国产成人在线视频| 天堂av免费资源在线观看| 亚洲av毛片免费在线观看| 中文欧美一区二区精品| 亚洲第一毛片免费在线观看| 欧美中文字幕内射合集| 国产精精精精品欧美日韩| 国产一区二区三区精品久| 亚洲综合实力最强的国家| 色哟哟视频在线免费观看| 久久精品人妻一区二区| 亚洲综合一区二区精品久久| 成人午夜激情四射av| 日韩欧美第一页在线观看| 欧美高清精品在线视频|