Relational Database Services
-
RDS Features
- Read Replication
- Multi-AZ Deployment
- Automatic Minor Version Upgrades
- Database shutdown
- Snapshots
-
DB Subnet Groups:
- Whenever RDS is created it needs atleast two subnet-ids
- DB Subnets help in selecting network and subnets (regions and AZs)
-
Reserved Instances:
- Give a longterm commitment to Amazon for 1 or 3 years for RDS usage can save costs upto 58%
Read Replication
- Promotion is giving write permissions to read replica.
Multi-AZ Deployment
- Database is created in multiple AZs
- Due to this failover is automatic
- Costs will be on the higher side.
Automatic Minor Version Upgrades
- User can enable this feature which upgrades minor releases but you have to suggest the time period when your database is used less (maintenance Window).
Database Shutdown
- Database can be stopped or rebooted.
- Database can be shutdown only for 1 day continuously.
Database Snapshots
- Backup of Database is called as snapshots
- Snapshots can be created manually or you can schedule them.
Exercise
- Create an RDS mysql instance with t2.micro (free tier)
- Ensure you select last 2 days bakcup.
- Create a Read Replica in other Region
- Promote Read Replica.
- Delete all the RDS instances and Snapshots