This project demonstrates the migration of an on-premise MySQL database to a MySQL database instance in AWS, then from this cloud database instance to another cloud database instance using AWS Database Migration Service.
The migration process involved...
Identifying the on-premise database workload to be migrated.
Identifying the cloud equivalent that would be compatible for the rehosting.
Exporting the on-premise databse into a sql file.
Creating a cloud databse instance(sourcedb-instance) with the appropriate engine or engine of choice, in this case, MySQL.
Creating another databse instance (targetdb-instance) to serve as the target for the cloud-to-cloud databse migration.
Importing the on-premise database into the sourcedb-instance through the command line.
Using the Database Migration Service via the management console, 3 services are then created to enable cloud-to-cloud migration of the database i.e from sourcedb-instance to targetdb-instance. These services are: Replication instance, Endpoints and Database Migration Task.
With these, the database is successfully migrated fron sourcedb-instance to targetdb-instance.