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