EON mode support

[fatih-celonis]

Is it possible to support EON mode with single-node-ce edition on Docker? I've done it by changing the script but official support for EON mode on Docker would be amazing.

[NerdLogic]

Would you like to contribute your script changes?

[fatih-celonis]

Hey @NerdLogic

• Added a docker-compose file that contains Minio, MC and Vertica.
• Modified the docker entrypoint.

Here is the docker-compose file.

services:
  minio:
    image: minio/minio
    hostname: minio
    ports:
      - "9000:9000"
      - "9001:9001"
    volumes:
      - <FOLDER_PATH_FOR_MINIO>:/data
    environment:
      - "MINIO_ROOT_USER=minio"
      - "MINIO_ROOT_PASSWORD=password"
    command: server /data --console-address ":9001"

  createbuckets:
    image: minio/mc
    depends_on:
      - minio
    entrypoint: >
      /bin/sh -c "
      /usr/bin/mc alias set myminio http://minio:9000 minio password;
      /usr/bin/mc mb --ignore-existing myminio/vertica-eon-bucket;
      /usr/bin/mc policy set public myminio/vertica-eon-bucket;
      exit 0;
      "

  vertica-eon:
    image: THE_IMAGE_THAT_WE_BUILT
    hostname: vertica-eon
    depends_on:
      - minio
    ports:
      - "5433:5433"
      - "5444:5444"
    environment:
      - "MINIO_ROOT_USERNAME=minio"
      - "MINIO_ROOT_PASSWORD=password"
      - "MINIO_URL=minio"
      - "MINIO_PORT=9000"
      - "BUCKET_NAME=vertica-eon-bucket"
      - "VERTICA_MEMDEBUG=2"
    volumes:
      - type: bind
        source: <FOLDER_PATH>
        target: <FOLDER_PATH>

And add below code snippets to the entrypoint file. Note that as the default Vertica 11 CE docker image doesn't support EON mode(or I couldn't make it work), we are downloading normal version of Vertica 11 and adds as the Vertica package.

cat << EOF > /home/dbadmin/auth_params.conf
awsauth = ${MINIO_ROOT_USERNAME}:${MINIO_ROOT_PASSWORD}
awsendpoint = ${MINIO_URL}:${MINIO_PORT}
awsenablehttps = 0
EOF

${ADMINTOOLS} -t create_db \
              --skip-fs-checks \
              -s localhost \
              --database=$VERTICA_DB_NAME \
              --catalog_path=${VERTICA_DATA_DIR} \
              --data_path=${VERTICA_DATA_DIR} \
              --communal-storage-location=s3://${BUCKET_NAME} \
              --depot-path=/home/dbadmin/depot \
              --force-cleanup-on-failure \
              -x /home/dbadmin/auth_params.conf \
              --shard-count=3