Home
In this mini-project I will be migrating a MySQL on-premises schema to a AWS MySQL instance and automate the process to make it fast with little downtime.
There are a few options available:
-
Use the mysqldump utility to export your database to a SQL file, then import that file into your RDS instance using the MySQL command-line tool.
-
Use the AWS Database Migration Service (DMS) to migrate your data. DMS can handle complex migrations with minimal downtime.
-
Restoring our database using an S3 bucket, which is integrated with RDS.
-
When having small databases, you can simply create a new RDS instance and manually import your data using the MySQL command-line tool.
-
Similar to the mysqldump utility, the Dump & Load utilities from MySQL shell can be used, especially for loading databases of large sizes as this tool was built thinking on performance speed and ease of use.
Here I will focus on using the Dump & Load utilities from MySQL Shell.