AWS Classroomnotes 08/Jan/2022

Creating a Replication Instance

Now lets create a replication instance which will migrate the database from source to target.
Creation of this instance will take few minutes
After the Replication instance is created, we need to test the source and target endpoints
Migration Types
Migration existing data => one time migration
Migration existing data & Replicate On going changes => migration & Replication Setup
Replicate On going changes => replication
Now lets create a replication task. For this activity we will be using one time migration
Lets change the schema to be migrated as employees and start the replication.
Now Lets wait for the task to be completed
Now to verify if the all the records have been migrated or note we can do basic checks

use employees;
select count(*) from departments;
select count(*) from dept_emp;
select count(*) from dept_manager;
select count(*) from employees;
select count(*) from salaries;
select count(*) from titles;

If you want to replicate ongoing changes then aws displays the following message
Refer Here for the mysql docs on how to do this activity
Lets create a Replication task
As observed in the class if we replicate ongoing changes, the changes in the source db will automatically reach the target database
Exercise:
Try to setup a migration from postgreSQL running on t2.micro instance to AWS RDS with Postgresql
Refer Here for the steps to install postgresql