hetzner/cms/wordpress/nuudi/wordpress.yml

version: '3.4'

services:
  nuudi:
#    depends_on:
#      - node
    deploy:
      replicas: 1
      mode: replicated
      placement:
        constraints:
          - node.role == manager
          - node.hostname == hetzner
    image: wordpress
#    ports:
#      - 8090:80
    labels:
      - traefik.enable=true
      - traefik.docker.network=traefik-network
      - traefik.constraint-label=traefik-network
      - traefik.http.routers.wp-nuudi-http.middlewares=http-to-https
      - traefik.http.routers.wp-nuudi-https.rule=Host(`www.nuuditalu.ee`) || Host(`nuuditalu.ee`)
      - traefik.http.routers.wp-nuudi-https.entrypoints=websecure
      - traefik.http.routers.wp-nuudi-http.rule=Host(`www.nuuditalu.ee`) || Host(`nuuditalu.ee`)
      - traefik.http.routers.wp-nuudi-http.entrypoints=web
      - traefik.http.routers.wp-nuudi-https.tls.certresolver=mychallenge
      - traefik.http.services.wp-nuudi.loadbalancer.server.port=80
## https redirect to www
      - "traefik.http.routers.wp-nuudi-https.middlewares=https-to-www-redirect"
      - "traefik.http.middlewares.https-to-www-redirect.redirectregex.regex=^https://(?:www.)?nuuditalu.ee/(.*)"
      - "traefik.http.middlewares.https-to-www-redirect.redirectregex.replacement=https://www.nuuditalu.ee/$${1}"
## service point
#      - "traefik.http.routers.nginx-www-http.service=nginx-www"
#      - "traefik.http.routers.nginx-www-https.service=nginx-www"


    volumes:
      - wordpress:/var/www/html
      - /etc/localtime:/etc/localtime
#      - "/etc/timezone:/etc/timezone:ro"
#      - "/etc/localtime:/etc/localtime:ro"
      - backups:/srv/backups
    networks:
      - db-network
      - traefik-network
    environment:
      - WORDPRESS_DB_HOST=node:3306
      - WORDPRESS_DB_USER=wp_nuudi
      - WORDPRESS_DB_PASSWORD=OiS9lpzCynHKusjak97s6DgenDU
      - WORDPRESS_DB_NAME=wp_nuudi
  #    NODE_ADDRESS: ^10.0.*.*
      - TZ="Europe/Tallinn"

volumes:
  wordpress:
    name: '{{.Service.Name}}-{{.Task.Slot}}-data'
    driver: local
  backups:
    name: '{{.Service.Name}}-{{.Task.Slot}}-backups'
    driver: local


networks:
  db-network:
    external: true
  traefik-network:
    external: true


## ------------------- mysql käsud --------------------------
## 1. logi nod konteinerisse sisse
# SHOW GRANTS FOR 'user'@'%';
# GRANT ALL PRIVILEGES ON * . * TO 'user'@'%';