Skip to content

Latest commit

 

History

History
30 lines (16 loc) · 1016 Bytes

File metadata and controls

30 lines (16 loc) · 1016 Bytes

docker-mysqldump-to-s3

Docker container that dumps a single mysql db to an s3 bucket

Requirements

  1. Needs to be running with AWS credentials with write access to the s3 bucket (either mount the .aws dir to /root/.aws or seed them via ENV or use an IAM Role in ECS Task setup)

  2. Needs to have the DB details and S3 bucket location seeded via ENV vars

    DBHOST=<DB_SERVER_HOSTNAME>

    DBUSER=<DB_SERVER_USERNAME>

    DBPASS=<DB_SERVER_PASSWORD>

    PARAMS=<DB_DUMP_PARAMETERS> (Optional)

    DBNAME=<DATABASE_NAME>

    S3_BUCKET=<S3_BUCKET_NAME> (Destination bucket for the sql dump file)

    S3_PREFIX=<S3_PREFIX> (Folder path in the S3 bucket)

    SLACK_WEBHOOK=<SLACK_WEBHOOK_URL> (Optional: if used must also specify SLACK_CHANNEL)

    SLACK_CHANNEL=<SLACK_CHANNEL_NAME> (Optional: if used must also specify SLACK_WEBHOOK)

    SLACK_BOTNAME=<SLACK_BOTNAME> (Optional: defaults to "mysqldump-to-s3")

  3. Needs to have a docker storage volume that is mounted to /dumps