mysqlbackup-lambda

tldr; AWS Lambda to backup mysql database to S3

Repo Pull:

Although, incase working with Lambda, you would need to publish this to Private ECR, in case needed, latest can be pulled from: public.ecr.aws/letsdocoding/mysqlbackup-lambda:latest.

High Level Overview

Following diagram illustrates the High Level Design of solution.

Setup

1. Publish to your private ECR Repo
2. Define the following ENV Variables to configure
   1. S3_BUCKET : Defines the target S3 Bucket
   2. DB_HOST : Defines the Database Host
   3. DB_NAME : Defines the database name
   4. DB_USER : Defines the database user
   5. DB_PASS : Defines the database password
3. Configure the triggers and good to go

Further probable optimizations

1. Use Secrets manager to store credentials
2. Iterate database to get all databases and dump all.
3. Use multiple source to trigger database backups.