docker-wordpress.yaml

version: '3.3'
services:
   wordpress:
    depends_on:
       - db
    image: wordpress:latest
    volumes:
       - wordpress_files:/var/www/html
    networks:
       - wordpress
    ports:
       - "80:80"
    environment:
      WORDPRESS_DB_HOST: db:3306
      WORDPRESS_DB_USER: wordpress
      WORDPRESS_DB_PASSWORD: /run/secrets/my_wordpress_db_password
   db:
    image: mysql:5.7
    secrets:
      - db_root_password
      - db_dba_password
      - my_wordpress_db_password
    deploy:
      replicas: 1
      placement:
        constraints: [node.role == manager]
      resources:
        reservations:
          memory: 128M
        limits:
          memory: 256M
    ports:
      - "3306:3306"
    environment:
       MYSQL_ROOT_PASSWORD: /run/secrets/db_root_password
       MYSQL_DATABASE: wordpress
       MYSQL_USER: wordpress
       MYSQL_PASSWORD: /run/secrets/my_wordpress_db_password
    networks:
      - wordpress
    volumes:
      - /var/run/docker.sock:/var/run/docker.sock
      - type: bind
        source: /opt/docker/volumes/mysql
        target: /var/lib/mysql
secrets:
 db_root_password:
  external: true
 db_dba_password:
  external: true
 my_wordpress_db_password:
  external: true
volumes:
    wordpress_files:
    db_data:

networks:
  wordpress:
    external: true