Export an AWS Aurora Serverless MySQL database with mysqldump

1
votes

Is it possible to export an AWS Aurora Serverless MySQL database with mysqldump without using an EC2 instance?

2
mysqlamazon-web-servicesaws-aurora-serverless
Fargate can be the best option as lambda has max execution time which can break the functionally for large database. – Adiii

2 Answers

2
votes

At this time you cannot gain public access to Aurora, or use a site to site VPN connection to connect to it.

Whichever resource you use will need to reside within the VPC of the Aurora Serverless cluster. Possible solutions to bypass the requirement for EC2 would be either running a Fargate container to run your command or looking at Lambda to execute the command.

0
votes

I finally decided to emulate mysqldump using Python and the AWS Data API.

To emulate mysqldump, I followed:

How can I dump a MySQL database without using mysqldump in Python