AWS RDS CLI Contd..
- In the last session we have create a multi az mysql db with AWS CLI
aws rds create-db-instance --db-instance-identifier 'qtrdsfromclimulti' `
--db-instance-class 'db.t2.micro' --engine 'mysql' `
--master-username 'root' --master-user-password 'rootroot' `
--publicly-accessible --db-name 'qtecommerce' `
--db-subnet-group-name 'qtsubnetgroup' --allocated-storage 20 `
--multi-az --vpc-security-group-ids 'sg-0c8eee8f2fbefd89e'
- Lets try to create a read replica for this multi az db instance
- For the command Refer Here
- Refer Here for the changeset containing read replica Exercise: # Waiting for you to complete the commands by 9:50 AM
- Create a db snapshot of the main database
- Delete the db snapshot
- Promote the read replica
- Delete the read replica that is promoted
- Creating a read replica in a different region
- Delete the read replica created
- Delete the multi az db
- Refer Here for the changeset containing all the changes for the above exercise.
