Export Amazon RDS for MySQL and MariaDB databases to Amazon S3 using a custom API

This article explains how to export databases from Amazon RDS for MySQL and MariaDB to Amazon S3 using a custom API. It provides a serverless solution that allows users to invoke an API to initiate database backups, which are then stored in S3.

Specifically, the article covers:

• Solution overview and architecture
• Prerequisites (AWS account, CLI, CDK, Docker)
• Creating database credentials and storing them in Secrets Manager
• Deploying the solution using AWS CDK
• Granting ECS access to database security groups
• Retrieving API Gateway information
• Invoking a backup via the API
• Troubleshooting backup failures using CloudWatch and ECS logs
• Scaling up ECS tasks for larger databases
• Best practices and lessons learned
• Cleaning up resources