docker-compose.yml

version: "3"

services:
  ghost:
    image: "ghost:5.74"
    environment:
      # see https://ghost.org/docs/config/#configuration-options
      database__client: mysql
      database__connection__host: ghost-db-master
      database__connection__user: ghost
      database__connection__password: ghostpassword
      database__connection__database: ghost
      # this url value is just an example, and is likely wrong for your environment!
      url: http://localhost:8080
      # 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: production
    depends_on:
      - ghost-db-master


  ghost-proxy:
    image: ghostcms-web
    build: nginx
    environment:
      NODE_ENV: production
    ports:
      - "8080:80"

  ghost-db-master:
    image: "ghost-mysql:8.2"
    build: mysql
    environment:
      MYSQL_ROOT_PASSWORD: rootpassword
      MYSQL_DATABASE: ghost
      MYSQL_USER: ghost
      MYSQL_PASSWORD: ghostpassword
      # The master node cannot be replicated.
      MYSQL_ROLE: master
    volumes:
      - ghost-db-master:/var/lib/mysql
      - ghost-temp-db:/tmp/mysql-backup

  ghost-db-slave:
    # We use the same custom image
    image: "ghost-mysql:8.2"
    build: mysql
    environment:
      MYSQL_ROOT_PASSWORD: rootpassword
#      MYSQL_DATABASE: ghost
#      MYSQL_USER: ghost
#      MYSQL_PASSWORD: ghostpassword
      # Role must be assiged to slave
      MYSQL_ROLE: slave
    volumes:
      - ghost-db-slave:/var/lib/mysql
      - ghost-temp-db:/tmp/mysql-backup
    depends_on:
      - ghost-db-master

volumes:
    ghost-db-master:
    ghost-db-slave:
    ghost-temp-db: