AWS Classroomnotes 16/Jul/2022

Database Migrations

  • Architecture
    Preview
  • Lets use some sample database Refer Here
  • On the source lets setup the employee database
  • Perform the following steps to have some source database
git clone https://github.com/datacharmer/test_db.git
cd test_db
mysql -u sammy -p < employees.sql

Preview
Preview
* Now the Source database is ready, Lets create the target database with the following settings
* Engine mysql
* username: sammy
* password: password
* size: db.t3.micro/db.t2.micro
* Automatic Backups for 7 days
* security group (3306 port opened => mysql security group)

  • After the target is ready, Lets configure the replication db instance
    Preview
  • Lets create the replication instance, fill the security group and create replication instance
    Preview
    Preview
    Preview
  • Lets create endpoints, source endpoint
    Preview
    Preview
    Preview
    Preview
    Preview
    Preview
  • Lets create a target endpoint
    Preview
    Preview
  • Now test the connections and verify if they are succesfull or not
    Preview
    Preview
    Preview
    Preview
    Preview

Leave a Reply

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

About continuous learner

devops & cloud enthusiastic learner