services:
  db:
    image: mysql:latest
    container_name: mysql-container-2
    restart: always
    environment:
      MYSQL_ROOT_PASSWORD: qwerty-1
      MYSQL_DATABASE: OrdersDB
    ports:
      - "3306:3306"
    volumes:
      - sqladvanced_mysql_data:/var/lib/mysql

  backup-service:
    build: ./backup
    container_name: mysql-backup-runner
    environment:
      MYSQL_ROOT_PASSWORD: qwerty-1
      SFTP_HOST: "192.168.3.142"
      SFTP_USER: "vitaliilitvinchuk"
      EMAIL_TO: "vitalii.litvinchuk@oa.edu.ua"
    volumes:
      - ~/.ssh/id_rsa_docker:/root/.ssh/id_rsa:ro

volumes:
  sqladvanced_mysql_data:
    external: true