media-server-docker-compose/sites/gamesclub/docker-compose.yml

services:

  ghost:
    image: ghost:5
    restart: always
    ports:
      - 2369:2368
    expose:
      - 2369
    environment:
      # see https://ghost.org/docs/config/#configuration-options
      database__client: mysql
      database__connection__host: gamesclub-db-1
      database__connection__user: root
      database__connection__password: ${DBPASS}
      database__connection__database: ghost
      VIRTUAL_HOST: "${DOMAIN}, www.${DOMAIN}"
      VIRTUAL_PORT: 2369
      LETSENCRYPT_HOST: "${DOMAIN}, www.${DOMAIN}"
      LETSENCRYPT_EMAIL: ${EMAIL}
      # url: http://0.0.0.0:2369 #Dev
      url: "https://${DOMAIN}" #Prod
      # contrary to the default mentioned in the linked documentation, this image defaults to NODE_ENV=production (so development mode needs to be explicitly specified if desired)
      # NODE_ENV: development
    volumes:
      - ./content:/var/lib/ghost/content
      # - ./themes:/var/lib/ghost/current/content/themes:rw
  db:
    image: mysql:8.0
    restart: always
    environment:
      MYSQL_DATABASE: ghost
      MYSQL_ROOT_PASSWORD: ${DBPASS}
    volumes:
      - db:/var/lib/mysql
volumes:
  db:
networks:
  default:
    name: nginx-proxy
    external: true