Database Migrations

• Architecture
  
• 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

* 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
  
• Lets create the replication instance, fill the security group and create replication instance
  
  
  
• Lets create endpoints, source endpoint
  
  
  
  
  
  
• Lets create a target endpoint
  
  
• Now test the connections and verify if they are succesfull or not