Automated DB Backup script

[robmorgan]

We need an automated DB backup script. It should run either via Lambda or on an available ECS cluster.

The script should invoke mysqldump, but prefer the slave database so the database is not locked exclusively.

[yuliyantsvetkov]

Hi @robmorgan

Is Python working for you as runtime engine for the Lambda function which will backup databases from the RDS slave ?

We want them then stored to S3, right ?

Thanks

[robmorgan]

@yuliyantsvetkov yeah that's correct. I'd prefer a simple Bash script if possible, but that's going to be hard on Lambda. For some other clients I've been using CloudWatch triggered tasks to execute one-off containers on an ECS cluster. Thinking, now it might be better to move them to Lambda, what are your thoughts?

[yuliyantsvetkov]

Hey @robmorgan
I prefer Lambda as its cheaper than creating a temp. container for backup, we can manage the deployment via Terraform, and the Lambda itself, and with Python we can extend the backup with whatever we want functionalities.

[robmorgan]

@yuliyantsvetkov okay let's run with that then.