2-GPCC-安装.pdf - 墨天轮文档

2-GPCC-安装.pdf

布衣

253

5页

0次

2024-01-04

10墨值下载

一、数据库创建用户

创建gpmon角色，以及设置了密码，这个用户可以登录到数据库里面，也可用于登录页面。

1 [root@master ~]# su - gpadmin

2 [gpadmin@master ~]$ gpperfmon_install --enable --password oracle123 --port 5432

3 20231213:01:02:25:017773 gpperfmon_install:master:gpadmin-[INFO]:-createdb gpperfmon >& /

4 20231213:01:02:26:017773 gpperfmon_install:master:gpadmin-[INFO]:-PGPORT=5432 psql -f /us

5 20231213:01:02:27:017773 gpperfmon_install:master:gpadmin-[INFO]:-PGPORT=5432 psql templa

6 20231213:01:02:27:017773 gpperfmon_install:master:gpadmin-[INFO]:-PGPORT=5432 psql templa

7 20231213:01:02:27:017773 gpperfmon_install:master:gpadmin-[INFO]:-echo "local gpperfmo

8 20231213:01:02:27:017773 gpperfmon_install:master:gpadmin-[INFO]:-echo "host all

9 20231213:01:02:27:017773 gpperfmon_install:master:gpadmin-[INFO]:-echo "host all

10 20231213:01:02:27:017773 gpperfmon_install:master:gpadmin-[INFO]:-touch /home/gpadmin/.pg

11 20231213:01:02:27:017773 gpperfmon_install:master:gpadmin-[INFO]:-mv -f /home/gpadmin/.pg

12 20231213:01:02:27:017773 gpperfmon_install:master:gpadmin-[INFO]:-echo "*:5432:gpperfmon

13 20231213:01:02:27:017773 gpperfmon_install:master:gpadmin-[INFO]:-cat /home/gpadmin/.pgpa

14 20231213:01:02:27:017773 gpperfmon_install:master:gpadmin-[INFO]:-chmod 0600 /home/gpadmi

15 20231213:01:02:27:017773 gpperfmon_install:master:gpadmin-[INFO]:-PGPORT=5432 gpconfig -c

16 20231213:01:02:28:017773 gpperfmon_install:master:gpadmin-[INFO]:-PGPORT=5432 gpconfig -c

17 20231213:01:02:30:017773 gpperfmon_install:master:gpadmin-[INFO]:-PGPORT=5432 gpconfig -c

18 20231213:01:02:30:017773 gpperfmon_install:master:gpadmin-[INFO]:-PGPORT=5432 gpconfig -c

19 20231213:01:02:32:017773 gpperfmon_install:master:gpadmin-[INFO]:-gpperfmon will be enabl

修改用户密码

1 SQL> alter role gpmon with ENCRYPTED password 'KhhQk#wY5JeP%vxr';

重启greenplum

1 [gpadmin@master ~]$ gpstop -r

查看gpmon进程

1 [gpadmin@master ~]$ ps -ef | grep gpmmon |grep -v grep

2 gpadmin 18986 18955 0 01:12 ? 00:00:00 /usr/local/greenplum-db-6.20.5/bin/gpmmon

查看数据收集进程是否正常

1 [gpadmin@master ~]$ psql gpperfmon -c 'SELECT* FROM system_now;'

二、配置Greenplum Standby节点：

1) 将master的参数文件：pg_hba.conf 同步至standby 节点

1 [gpadmin@master ~]$ scp $MASTER_DATA_DIRECTORY/pg_hba.conf gpadmin@standby:$MASTER_DATA_D

2 pg_hba.conf 100% 5154 4.5MB/s 00:00

2) 将master 的pgpass同步至standby，并且文件权限修改为0600

1 [gpadmin@master ~]$ scp ~/.pgpass gpadmin@standby:~/.pgpass

2 .pgpass 100% 33 36.4KB/s 00:00

3 [gpadmin@master ~]$ ssh gpadmin@standby -C "chmod 0600 ~/.pgpass"

三、开始正式安装Greenplum Command Center Console

以下操作都在master节点操作：

1）.下载适合自己机器的greenplum-cc-web安装程序

greenplum-cc-web-6.1.0-gp6-rhel6-x86_64.zip

2）.上传到master节点的gpadmin用户家目录下面并完成解压操作

1 [root@master ~]# chown gpadmin. /home/gpadmin/greenplum-cc-web-6.1.0-gp6-rhel7-x86_64.zip

2 [root@master ~]# su - gpadmin

3 [gpadmin@master ~]$ unzip greenplum-cc-web-6.1.0-gp6-rhel7-x86_64.zip

3）.检查端口是否占用：

1 [root@master ~]#gpssh -f all_host -e netstat -nulp| grep -E '28080|8899'

2 或

3 [root@master ~]# netstat -nulp| grep -E '28080|8899'

4 [root@master ~]#

4）.创建gpcc 安装目录：

1 [gpadmin@master gpconfigs]$ gpssh -f hostlist -e 'mkdir /home/gpadmin/gpcc'

2 [segment1] mkdir /home/gpadmin/gpcc

3 [ standby] mkdir /home/gpadmin/gpcc

4 [ master] mkdir /home/gpadmin/gpcc

5 [segment2] mkdir /home/gpadmin/gpcc

5）.安装