Is it possible to copy data directly from MySql Local to AWS RDS Cluster Aurora Serverless

3
votes

i have a database that i want to move to AWS RDS Amazon Aurora Serverless, i dont have an instance i only have a cluster that i have created which is MySQL Aurora serverless, so is it possible to do a dump from MySQL directly to the cluster instead of dumping to an instance then creating a snapshot to restore on the serverless cluster.

2
mysqlamazon-web-servicesamazon-rdsamazon-aurora
Try using the AWS migration tool, but make sure your firewall settings allow the connection – user8155123

2 Answers

2
votes

We have a service available from Amazon called "DMS" (database Migration Service), there all it needs is the endpoint, connection details of source and target database systems. Here your source is your local DB and target is AWS aurora MySQL DB that you created. It is the simple guide, and you can achieve DB migration by merely following their documentation: check out this link https://docs.aws.amazon.com/dms/latest/sbs/DMS-SBS-Welcome.html

It is almost of no cost for the first user because it offers an instance for free that you can use as a medium for migration.

1
votes

Connections to Aurora Server less clusters are only available from within the same VPC, they are not publicly accessible.