在Docker中快速体验GreenPlum 7.0.0
  ETWZF7L1nsXD 2023年11月02日 44 0

环境配置

地址:https://hub.docker.com/r/lhrbest/greenplum/tags

1docker rm -f gpdb7
 2docker run -itd --name gpdb7 -h gpdb7 \
 3  -p 5436:5432 -p 28086:28080  \
 4  -v /sys/fs/cgroup:/sys/fs/cgroup \
 5  --privileged=true lhrbest/greenplum:7.0.0 \
 6  /usr/sbin/init
 7
 8
 9docker exec -it gpdb7 bash
10su - gpadmin
11gpstart -a
12gpcc start
13
14gpcc status
15gpstate

此docker包括1个master,1个standby master,2个segment,2个mirror实例。

示例:

1[root@gpdb7 /]# su - gpadmin
 2Last login: Fri Jul 21 16:42:55 CST 2023 on pts/1
 3[gpadmin@gpdb7 ~]$ 
 4[gpadmin@gpdb7 ~]$ 
 5[gpadmin@gpdb7 ~]$ gpstart -a
 620230721:16:45:00:001025 gpstart:gpdb7:gpadmin-[INFO]:-Starting gpstart with args: -a
 720230721:16:45:00:001025 gpstart:gpdb7:gpadmin-[INFO]:-Gathering information and validating the environment...
 820230721:16:45:00:001025 gpstart:gpdb7:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 7.0.0-beta.4 build commit:f3782c6dd89c9b6565a84518174ed4dd448f3293 Open Source'
 920230721:16:45:00:001025 gpstart:gpdb7:gpadmin-[INFO]:-Greenplum Catalog Version: '302306121'
1020230721:16:45:00:001025 gpstart:gpdb7:gpadmin-[INFO]:-Starting Coordinator instance in admin mode
1120230721:16:45:00:001025 gpstart:gpdb7:gpadmin-[INFO]:-CoordinatorStart pg_ctl cmd is env GPSESSID=0000000000 GPERA=None $GPHOME/bin/pg_ctl -D /opt/greenplum/data/master/gpseg-1 -l /opt/greenplum/data/master/gpseg-1/log/startup.log -w -t 600 -o " -c gp_role=utility " start
1220230721:16:45:00:001025 gpstart:gpdb7:gpadmin-[INFO]:-Obtaining Greenplum Coordinator catalog information
1320230721:16:45:00:001025 gpstart:gpdb7:gpadmin-[INFO]:-Obtaining Segment details from coordinator...
1420230721:16:45:01:001025 gpstart:gpdb7:gpadmin-[INFO]:-Setting new coordinator era
1520230721:16:45:01:001025 gpstart:gpdb7:gpadmin-[INFO]:-Coordinator Started...
1620230721:16:45:02:001025 gpstart:gpdb7:gpadmin-[INFO]:-Shutting down coordinator
1720230721:16:45:05:001025 gpstart:gpdb7:gpadmin-[INFO]:-Commencing parallel primary and mirror segment instance startup, please wait...
1820230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:-Process results...
1920230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:-
2020230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:-----------------------------------------------------
2120230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:-   Successful segment starts                                            = 4
2220230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:-   Failed segment starts                                                = 0
2320230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:-   Skipped segment starts (segments are marked down in configuration)   = 0
2420230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:-----------------------------------------------------
2520230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:-Successfully started 4 of 4 segment instances 
2620230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:-----------------------------------------------------
2720230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:-Starting Coordinator instance gpdb7 directory /opt/greenplum/data/master/gpseg-1 
2820230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:-CoordinatorStart pg_ctl cmd is env GPSESSID=0000000000 GPERA=cbcbcc7d30fa4b35_230721164501 $GPHOME/bin/pg_ctl -D /opt/greenplum/data/master/gpseg-1 -l /opt/greenplum/data/master/gpseg-1/log/startup.log -w -t 600 -o " -c gp_role=dispatch " start
2920230721:16:45:10:001025 gpstart:gpdb7:gpadmin-[INFO]:-Command pg_ctl reports Coordinator gpdb7 instance active
3020230721:16:45:10:001025 gpstart:gpdb7:gpadmin-[INFO]:-Connecting to db template1 on host localhost
3120230721:16:45:10:001025 gpstart:gpdb7:gpadmin-[INFO]:-Starting standby coordinator
3220230721:16:45:10:001025 gpstart:gpdb7:gpadmin-[INFO]:-Checking if standby coordinator is running on host: gpdb7  in directory: /opt/greenplum/data/master_standby/gpseg-1
3320230721:16:45:10:001025 gpstart:gpdb7:gpadmin-[INFO]:-CoordinatorStart pg_ctl cmd is env GPSESSID=0000000000 GPERA=cbcbcc7d30fa4b35_230721164501 $GPHOME/bin/pg_ctl -D /opt/greenplum/data/master_standby/gpseg-1 -l /opt/greenplum/data/master_standby/gpseg-1/log/startup.log -t 600 -o " -c gp_role=dispatch " start
3420230721:16:45:12:001025 gpstart:gpdb7:gpadmin-[INFO]:-Database successfully started
35
36[gpadmin@gpdb7 ~]$ gpstate -e
3720230721:16:55:56:005067 gpstate:gpdb7:gpadmin-[INFO]:-Starting gpstate with args: -e
3820230721:16:55:56:005067 gpstate:gpdb7:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 7.0.0-beta.4 build commit:f3782c6dd89c9b6565a84518174ed4dd448f3293 Open Source'
3920230721:16:55:56:005067 gpstate:gpdb7:gpadmin-[INFO]:-coordinator Greenplum Version: 'PostgreSQL 12.12 (Greenplum Database 7.0.0-beta.4 build commit:f3782c6dd89c9b6565a84518174ed4dd448f3293 Open Source) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-18), 64-bit compiled on Jun 15 2023 01:11:10 Bhuvnesh C.'
4020230721:16:55:56:005067 gpstate:gpdb7:gpadmin-[INFO]:-Obtaining Segment details from coordinator...
4120230721:16:55:56:005067 gpstate:gpdb7:gpadmin-[INFO]:-Gathering data from segments...
4220230721:16:55:56:005067 gpstate:gpdb7:gpadmin-[INFO]:-----------------------------------------------------
4320230721:16:55:56:005067 gpstate:gpdb7:gpadmin-[INFO]:-Segment Mirroring Status Report
4420230721:16:55:57:005067 gpstate:gpdb7:gpadmin-[INFO]:-----------------------------------------------------
4520230721:16:55:57:005067 gpstate:gpdb7:gpadmin-[INFO]:-All segments are running normally
46[gpadmin@gpdb7 ~]$ 
47

GreenPlum使用

1[gpadmin@gpdb7 ~]$ psql
 2psql (12.12)
 3Type "help" for help.
 4
 5postgres=# select * from gp_segment_configuration order by 1,3 ;
 6 dbid | content | role | preferred_role | mode | status | port | hostname | address |                  datadir                   
 7------+---------+------+----------------+------+--------+------+----------+---------+--------------------------------------------
 8    1 |      -1 | p    | p              | n    | u      | 5432 | gpdb7    | gpdb7   | /opt/greenplum/data/master/gpseg-1
 9    2 |       0 | p    | p              | s    | u      | 6000 | gpdb7    | gpdb7   | /opt/greenplum/data/primary/gpseg0
10    3 |       1 | p    | p              | s    | u      | 6001 | gpdb7    | gpdb7   | /opt/greenplum/data/primary/gpseg1
11    4 |       0 | m    | m              | s    | u      | 7000 | gpdb7    | gpdb7   | /opt/greenplum/data/mirror/gpseg0
12    5 |       1 | m    | m              | s    | u      | 7001 | gpdb7    | gpdb7   | /opt/greenplum/data/mirror/gpseg1
13    6 |      -1 | m    | m              | s    | u      | 5433 | gpdb7    | gpdb7   | /opt/greenplum/data/master_standby/gpseg-1
14(6 rows)
15
16postgres=# select version();
17                                                                                                                          version                                                                                                                          
18-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
19 PostgreSQL 12.12 (Greenplum Database 7.0.0-beta.4 build commit:f3782c6dd89c9b6565a84518174ed4dd448f3293 Open Source) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-18), 64-bit compiled on Jun 15 2023 01:11:10 Bhuvnesh C.
20(1 row)
21
22postgres=# \q
23

总结

1、需要rhel8

2、需要python 3.9

3、gpcc 6.9版本不支持GP7

参考

https://www.xmmup.com/greenplum7danjianzhuang.html

https://www.xmmup.com/greenplum-6-danjianzhuang.html

https://www.xmmup.com/yitiaominglingkuaisuqidonggreenplum.html

https://www.xmmup.com/mppjiagouzhigreenplumdeanzhuangpeizhigaojiban.html

https://www.xmmup.com/greenplumguanfangjiankonggongjugpccjianjiejishiyong.html

https://www.xmmup.com/greenplumguanfangjiankonggongjugpcc-6deanzhuanghexiezai.html

【版权声明】本文内容来自摩杜云社区用户原创、第三方投稿、转载,内容版权归原作者所有。本网站的目的在于传递更多信息,不拥有版权,亦不承担相应法律责任。如果您发现本社区中有涉嫌抄袭的内容,欢迎发送邮件进行举报,并提供相关证据,一经查实,本社区将立刻删除涉嫌侵权内容,举报邮箱: cloudbbs@moduyun.com

  1. 分享:
最后一次编辑于 2023年11月08日 0

暂无评论

推荐阅读
  P3nxyT0LRuwj   2023年11月28日   26   0   0 nginxhtmlWeb
  38gcbVXUBcLA   2023年11月26日   25   0   0 服务器htmlHTTP
  pfl0iGEgXbv6   2023年11月19日   20   0   0 git用户名bc
  hs9CtFCuSvuL   2023年11月19日   29   0   0 DatabaseHCLjson
  48fXx4UfWSFg   2023年12月06日   58   0   0 bcIPbundle
  9JCEeX0Eg8g4   2023年11月27日   31   0   0 DatabaseSystemmongodb
ETWZF7L1nsXD