db-migration
README.md

db-migration

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...

  1. Identifying the on-premise database workload to be migrated.

  2. Identifying the cloud equivalent that would be compatible for the rehosting.

  3. Exporting the on-premise databse into a sql file.

  4. Creating a cloud databse instance(sourcedb-instance) with the appropriate engine or engine of choice, in this case, MySQL.

  5. Creating another databse instance (targetdb-instance) to serve as the target for the cloud-to-cloud databse migration.

  6. Importing the on-premise database into the sourcedb-instance through the command line.

  7. 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.

  8. With these, the database is successfully migrated fron sourcedb-instance to targetdb-instance.