AWS Classroomnotes 08/Jan/2022

Creating a Replication Instance

  • Now lets create a replication instance which will migrate the database from source to target.
    Preview
    Preview
    Preview
    Preview
  • Creation of this instance will take few minutes
    Preview
    Preview
  • After the Replication instance is created, we need to test the source and target endpoints
    Preview
    Preview
    Preview
    Preview
  • Migration Types
  • Migration existing data => one time migration
  • Migration existing data & Replicate On going changes => migration & Replication Setup
  • Replicate On going changes => replication
    Preview
  • Now lets create a replication task. For this activity we will be using one time migration
    Preview
    Preview
    Preview
    Preview
    Preview
    Preview
    Preview
  • Lets change the schema to be migrated as employees and start the replication.
    Preview
  • Now Lets wait for the task to be completed
    Preview
    Preview
  • 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
    Preview
  • Refer Here for the mysql docs on how to do this activity
  • Lets create a Replication task
    Preview
  • 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

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

About continuous learner

devops & cloud enthusiastic learner