使用Docker搭建Greenplum

约定不等于承诺〃 2023-07-11 05:46 2阅读 0赞

## 准备工作 ##

*  Docker环境
 *  Greenplum安装包  
    [greenplum-db-6.4.0-rhel7-x86\_64.rpm][greenplum-db-6.4.0-rhel7-x86_64.rpm] 密码:sv4p

## 安装 ##

*  Dockerfile文件  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L00yODM1OTIzMzg_size_16_color_FFFFFF_t_70]

FROM lyasper/gphost
    COPY greenplum-db-6.4.0-rhel7-x86_64.rpm /home/gpadmin/greenplum-db.rpm
    RUN rpm -i /home/gpadmin/greenplum-db.rpm --nodeps --force
    RUN chown -R gpadmin /usr/local/greenplum-db*
    RUN rm -f /home/gpadmin/greenplum-db.rpm

*  docker-compose.yaml文件  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L00yODM1OTIzMzg_size_16_color_FFFFFF_t_70 1]

version: '3'
    services:
      mdw:
        hostname: mdw
        image: "mygreenplum"
        ports:
          - "2222:22"
          - "5432:5432"
      sdw1:
        hostname: sdw1
        image: "mygreenplum"
      sdw2:
        hostname: sdw2
        image: "mygreenplum"
      etl:
        hostname: etl
        image: "mygreenplum"

*  执行Dockerfile

docker build . -t mygreenplum

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L00yODM1OTIzMzg_size_16_color_FFFFFF_t_70 2]

*  执行docker-compose

docker-compose up -d # 在docker-compose.yaml所在目录执行

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L00yODM1OTIzMzg_size_16_color_FFFFFF_t_70 3]

## 集群配置 ##

目前Docker容器已经启动，但是greenplum的配置还没有更改

*  登陆至greenplum主节点

ssh -p 2222 gpadmin@127.0.0.1
    # 密码 changeme

*  先刷新下配置文件

source /usr/local/greenplum-db/greenplum_path.sh

*  初始化配置

./artifact/prepare.sh -s 2 -n 2
    # -s 表示 segment 机器（容器）的个数
    # -n 表示每个容器里 primary segment 的个数

*  初始化集群

source env.sh
    gpinitsystem -a -c gpinitsystem_config

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L00yODM1OTIzMzg_size_16_color_FFFFFF_t_70 4]  
至此安装成功

[greenplum-db-6.4.0-rhel7-x86_64.rpm]: https://pan.baidu.com/s/1Sq0MqyCqHbQcVBNuQJcmjQ
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L00yODM1OTIzMzg_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/202003041045262.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L00yODM1OTIzMzg=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L00yODM1OTIzMzg_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200304104628512.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L00yODM1OTIzMzg=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L00yODM1OTIzMzg_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20200304105914890.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L00yODM1OTIzMzg=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L00yODM1OTIzMzg_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20200304110343367.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L00yODM1OTIzMzg=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L00yODM1OTIzMzg_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20200304183332817.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L00yODM1OTIzMzg=,size_16,color_FFFFFF,t_70