Skip to content

README.md

Latest commit

 

History

History
36 lines (24 loc) · 1.28 KB

README.md

File metadata and controls

36 lines (24 loc) · 1.28 KB

mysqlbackup-lambda

tldr; Highly Scalable AWS Lambda self managed and simple solution 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. Image

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

Full Vide

Full Detailed Video

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.

Contributions Welcome

Please feel free to fork / raise PR for any feedback / changes.