MariaDB with S3 Backup - excelbd/Excel-ERP-Production-Setup GitHub Wiki

version: "3.7"
services:
  mariadb-master:
    image: bitnami/mariadb:10.6
    deploy:
      restart_policy:
        condition: on-failure
      placement:
        constraints:
          - node.labels.frappe-node.data == true   
    networks:
      - frappe-network
    environment:
      MARIADB_CHARACTER_SET: utf8mb4
      MARIADB_COLLATE: utf8mb4_unicode_ci
      MARIADB_ROOT_PASSWORD: ETLTestERP!Admin!786
      MARIADB_EXTRA_FLAGS: --skip-character-set-client-handshake --skip-innodb-read-only-compressed
    volumes:
      - mariadb-data:/bitnami/mariadb
  backup-s3:
    image: schickling/mysql-backup-s3:latest
    deploy:
      restart_policy:
        condition: on-failure
      placement:
        constraints:
          - node.labels.frappe-node.data == true 
    networks:
      - frappe-network
    environment:
      S3_ACCESS_KEY_ID: AKIAZYOAF7WBUPXRMFN6
      S3_SECRET_ACCESS_KEY: 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
      S3_BUCKET: erp-mysqldump-backup
      S3_PREFIX: backup
      MYSQL_USER: root
      MYSQL_PASSWORD: ETLTestERP!Admin!786
      MYSQL_HOST: mariadb-master
networks:
  frappe-network:
    name: frappe-network
    attachable: true

volumes:
  mariadb-data: