在Docker中快速体验GreenPlum 7.0.0

由 小麦苗 · 2023年7月21日  

0    171    1

Tags： Dockerdocker环境GreenPlum快速体验

👉 本文共约515个字，系统预计阅读时间或需2分钟。

本页目录 隐藏

环境配置

GreenPlum使用

总结

相关文章

环境配置

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

docker rm -f gpdb7 docker run -itd --name gpdb7 -h gpdb7 \ -p 5436:5432 -p 28086:28080 \ -v /sys/fs/cgroup:/sys/fs/cgroup \ --privileged=true lhrbest/greenplum:7.0.0 \ /usr/sbin/init docker exec -it gpdb7 bash su - gpadmin gpstart -a gpcc start gpcc status gpstate

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

docker rm -f gpdb7 docker run -itd --name gpdb7 -h gpdb7 \   -p 5436:5432 -p 28086:28080  \   -v /sys/fs/cgroup:/sys/fs/cgroup \   --privileged=true lhrbest/greenplum:7.0.0 \   /usr/sbin/init   docker exec -it gpdb7 bash su - gpadmin gpstart -a gpcc start   gpcc status gpstate

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

示例：

[root@gpdb7 /]# su - gpadmin Last login: Fri Jul 21 16:42:55 CST 2023 on pts/1 [gpadmin@gpdb7 ~]$ [gpadmin@gpdb7 ~]$ [gpadmin@gpdb7 ~]$ gpstart -a 20230721:16:45:00:001025 gpstart:gpdb7:gpadmin-[INFO]:-Starting gpstart with args: -a 20230721:16:45:00:001025 gpstart:gpdb7:gpadmin-[INFO]:-Gathering information and validating the environment... 20230721:16:45:00:001025 gpstart:gpdb7:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 7.0.0-beta.4 build commit:f3782c6dd89c9b6565a84518174ed4dd448f3293 Open Source' 20230721:16:45:00:001025 gpstart:gpdb7:gpadmin-[INFO]:-Greenplum Catalog Version: '302306121' 20230721:16:45:00:001025 gpstart:gpdb7:gpadmin-[INFO]:-Starting Coordinator instance in admin mode 20230721: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 20230721:16:45:00:001025 gpstart:gpdb7:gpadmin-[INFO]:-Obtaining Greenplum Coordinator catalog information 20230721:16:45:00:001025 gpstart:gpdb7:gpadmin-[INFO]:-Obtaining Segment details from coordinator... 20230721:16:45:01:001025 gpstart:gpdb7:gpadmin-[INFO]:-Setting new coordinator era 20230721:16:45:01:001025 gpstart:gpdb7:gpadmin-[INFO]:-Coordinator Started... 20230721:16:45:02:001025 gpstart:gpdb7:gpadmin-[INFO]:-Shutting down coordinator 20230721:16:45:05:001025 gpstart:gpdb7:gpadmin-[INFO]:-Commencing parallel primary and mirror segment instance startup, please wait... 20230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:-Process results... 20230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:- 20230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:----------------------------------------------------- 20230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:- Successful segment starts = 4 20230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:- Failed segment starts = 0 20230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0 20230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:----------------------------------------------------- 20230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:-Successfully started 4 of 4 segment instances 20230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:----------------------------------------------------- 20230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:-Starting Coordinator instance gpdb7 directory /opt/greenplum/data/master/gpseg-1 20230721: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 20230721:16:45:10:001025 gpstart:gpdb7:gpadmin-[INFO]:-Command pg_ctl reports Coordinator gpdb7 instance active 20230721:16:45:10:001025 gpstart:gpdb7:gpadmin-[INFO]:-Connecting to db template1 on host localhost 20230721:16:45:10:001025 gpstart:gpdb7:gpadmin-[INFO]:-Starting standby coordinator 20230721: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 20230721: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 20230721:16:45:12:001025 gpstart:gpdb7:gpadmin-[INFO]:-Database successfully started [gpadmin@gpdb7 ~]$ gpstate -e 20230721:16:55:56:005067 gpstate:gpdb7:gpadmin-[INFO]:-Starting gpstate with args: -e 20230721:16:55:56:005067 gpstate:gpdb7:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 7.0.0-beta.4 build commit:f3782c6dd89c9b6565a84518174ed4dd448f3293 Open Source' 20230721: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.' 20230721:16:55:56:005067 gpstate:gpdb7:gpadmin-[INFO]:-Obtaining Segment details from coordinator... 20230721:16:55:56:005067 gpstate:gpdb7:gpadmin-[INFO]:-Gathering data from segments... 20230721:16:55:56:005067 gpstate:gpdb7:gpadmin-[INFO]:----------------------------------------------------- 20230721:16:55:56:005067 gpstate:gpdb7:gpadmin-[INFO]:-Segment Mirroring Status Report 20230721:16:55:57:005067 gpstate:gpdb7:gpadmin-[INFO]:----------------------------------------------------- 20230721:16:55:57:005067 gpstate:gpdb7:gpadmin-[INFO]:-All segments are running normally [gpadmin@gpdb7 ~]$

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47

[root@gpdb7 /]# su - gpadmin Last login: Fri Jul 21 16:42:55 CST 2023 on pts/1 [gpadmin@gpdb7 ~]$ [gpadmin@gpdb7 ~]$ [gpadmin@gpdb7 ~]$ gpstart -a 20230721:16:45:00:001025 gpstart:gpdb7:gpadmin-[INFO]:-Starting gpstart with args: -a 20230721:16:45:00:001025 gpstart:gpdb7:gpadmin-[INFO]:-Gathering information and validating the environment... 20230721:16:45:00:001025 gpstart:gpdb7:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 7.0.0-beta.4 build commit:f3782c6dd89c9b6565a84518174ed4dd448f3293 Open Source' 20230721:16:45:00:001025 gpstart:gpdb7:gpadmin-[INFO]:-Greenplum Catalog Version: '302306121' 20230721:16:45:00:001025 gpstart:gpdb7:gpadmin-[INFO]:-Starting Coordinator instance in admin mode 20230721: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 20230721:16:45:00:001025 gpstart:gpdb7:gpadmin-[INFO]:-Obtaining Greenplum Coordinator catalog information 20230721:16:45:00:001025 gpstart:gpdb7:gpadmin-[INFO]:-Obtaining Segment details from coordinator... 20230721:16:45:01:001025 gpstart:gpdb7:gpadmin-[INFO]:-Setting new coordinator era 20230721:16:45:01:001025 gpstart:gpdb7:gpadmin-[INFO]:-Coordinator Started... 20230721:16:45:02:001025 gpstart:gpdb7:gpadmin-[INFO]:-Shutting down coordinator 20230721:16:45:05:001025 gpstart:gpdb7:gpadmin-[INFO]:-Commencing parallel primary and mirror segment instance startup, please wait... 20230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:-Process results... 20230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:- 20230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:----------------------------------------------------- 20230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:-   Successful segment starts                                            = 4 20230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:-   Failed segment starts                                                = 0 20230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:-   Skipped segment starts (segments are marked down in configuration)   = 0 20230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:----------------------------------------------------- 20230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:-Successfully started 4 of 4 segment instances 20230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:----------------------------------------------------- 20230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:-Starting Coordinator instance gpdb7 directory /opt/greenplum/data/master/gpseg-1 20230721: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 20230721:16:45:10:001025 gpstart:gpdb7:gpadmin-[INFO]:-Command pg_ctl reports Coordinator gpdb7 instance active 20230721:16:45:10:001025 gpstart:gpdb7:gpadmin-[INFO]:-Connecting to db template1 on host localhost 20230721:16:45:10:001025 gpstart:gpdb7:gpadmin-[INFO]:-Starting standby coordinator 20230721: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 20230721: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 20230721:16:45:12:001025 gpstart:gpdb7:gpadmin-[INFO]:-Database successfully started   [gpadmin@gpdb7 ~]$ gpstate -e 20230721:16:55:56:005067 gpstate:gpdb7:gpadmin-[INFO]:-Starting gpstate with args: -e 20230721:16:55:56:005067 gpstate:gpdb7:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 7.0.0-beta.4 build commit:f3782c6dd89c9b6565a84518174ed4dd448f3293 Open Source' 20230721: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.' 20230721:16:55:56:005067 gpstate:gpdb7:gpadmin-[INFO]:-Obtaining Segment details from coordinator... 20230721:16:55:56:005067 gpstate:gpdb7:gpadmin-[INFO]:-Gathering data from segments... 20230721:16:55:56:005067 gpstate:gpdb7:gpadmin-[INFO]:----------------------------------------------------- 20230721:16:55:56:005067 gpstate:gpdb7:gpadmin-[INFO]:-Segment Mirroring Status Report 20230721:16:55:57:005067 gpstate:gpdb7:gpadmin-[INFO]:----------------------------------------------------- 20230721:16:55:57:005067 gpstate:gpdb7:gpadmin-[INFO]:-All segments are running normally [gpadmin@gpdb7 ~]$

GreenPlum使用

[gpadmin@gpdb7 ~]$ psql psql (12.12) Type "help" for help. postgres=# select * from gp_segment_configuration order by 1,3 ; dbid | content | role | preferred_role | mode | status | port | hostname | address | datadir ------+---------+------+----------------+------+--------+------+----------+---------+-------------------------------------------- 1 | -1 | p | p | n | u | 5432 | gpdb7 | gpdb7 | /opt/greenplum/data/master/gpseg-1 2 | 0 | p | p | s | u | 6000 | gpdb7 | gpdb7 | /opt/greenplum/data/primary/gpseg0 3 | 1 | p | p | s | u | 6001 | gpdb7 | gpdb7 | /opt/greenplum/data/primary/gpseg1 4 | 0 | m | m | s | u | 7000 | gpdb7 | gpdb7 | /opt/greenplum/data/mirror/gpseg0 5 | 1 | m | m | s | u | 7001 | gpdb7 | gpdb7 | /opt/greenplum/data/mirror/gpseg1 6 | -1 | m | m | s | u | 5433 | gpdb7 | gpdb7 | /opt/greenplum/data/master_standby/gpseg-1 (6 rows) postgres=# select version(); 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. (1 row) postgres=# \q

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

[gpadmin@gpdb7 ~]$ psql psql (12.12) Type "help" for help.   postgres=# select * from gp_segment_configuration order by 1,3 ; dbid | content | role | preferred_role | mode | status | port | hostname | address |                  datadir                   ------+---------+------+----------------+------+--------+------+----------+---------+--------------------------------------------     1 |      -1 | p    | p              | n    | u      | 5432 | gpdb7    | gpdb7   | /opt/greenplum/data/master/gpseg-1     2 |       0 | p    | p              | s    | u      | 6000 | gpdb7    | gpdb7   | /opt/greenplum/data/primary/gpseg0     3 |       1 | p    | p              | s    | u      | 6001 | gpdb7    | gpdb7   | /opt/greenplum/data/primary/gpseg1     4 |       0 | m    | m              | s    | u      | 7000 | gpdb7    | gpdb7   | /opt/greenplum/data/mirror/gpseg0     5 |       1 | m    | m              | s    | u      | 7001 | gpdb7    | gpdb7   | /opt/greenplum/data/mirror/gpseg1     6 |      -1 | m    | m              | s    | u      | 5433 | gpdb7    | gpdb7   | /opt/greenplum/data/master_standby/gpseg-1 (6 rows)   postgres=# select version();                                                                                                                           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. (1 row)   postgres=# \q

总结

1、需要rhel8

本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信db_bao，谢谢！

后续精彩内容已被小麦苗无情隐藏，请输入验证码解锁本站所有文章

验证码：

请关注本站微信公众号，回复“小麦苗博客”，获取验证码。在微信里搜索“DB宝”或者“www_xmmup_com”或者微信扫描右侧二维码都可以关注本站微信公众号。

相关文章

• 在Docker中快速体验GreenPlum 6.23.1和gpcc监控工具
• 一条命令快速启动Greenplum 5和GreenPlum 6版本的单机环境
• Oracle同步数据到GreenPlum
• 小麦苗GreenPlum DBA课程
• Greenplum中的进程优先级（PR、NI）
• GreenPlum查询报错failed to initialize zstd stream: Allocation error : not enough memory
• 如何在ARM架构服务器上编译Greenplum
• GreenPlum适配国产化操作系统的情况
• Greenplum中的外部表（gpfdist和gpload）
• 利用嵌套docker在单个容器中安装GreenPlum多主机环境
• GreenPlum7单机安装
• Greenplum广播与重分布原理
• GreenPlum中的FTS故障检测原理
• GreenPlum在何时会发生自动故障切换及如何查询（OOM）
• GreenPlum性能优化系列
• GreenPlum性能调优之数据倾斜
• GreenPlum中的灾备（数据实时同步）
• GreenPlum如何快速修复配置错误的参数
• GreenPlum空间满不能启动的处理办法
• GreenPlum新建实例后需要做哪些基本优化操作

打赏赞(1)分享

标签： Dockerdocker环境GreenPlum快速体验

小麦苗

学习或考证，均可联系麦老师，请加微信db_bao或QQ646634621

• 下一篇 Navicat的常用快捷键和修改快捷键方式
• 上一篇 GreenPlum7单机安装

您可能还喜欢...

• 0

  Greenplum 数据库数据类型

  2023年1月3日

   由 小麦苗

   由 小麦苗 · Published 2023年1月3日 · Last modified 2023年3月23日

  · 已更新 2023年3月23日  

  0    40    2
• 0

  Greenplum中的gpperfmon数据库

  2023年1月6日

   由 小麦苗

   由 小麦苗 · Published 2023年1月6日 · Last modified 2023年4月24日

  · 已更新 2023年4月24日  

  0    94    2
• 0

  GreenPlum中的FTS故障检测原理

  2023年7月18日

   由 小麦苗

   由 小麦苗 · Published 2023年7月18日

   

  0    53    1