RDS (Relational Database Service) is used to manage Relation Database Systems.
The following RDBMS that are supported by AWS RDS are:
1. Postgres
2. MySQL
3. MariaDB
4. Oracle
5. Microsoft SQL Server
6. IBM DB2
7. Aurora (AWS Proprietary database)
The Benefit using RDS over deploying your own database system:
1. Automatic provisioning of OS patching
2. Continuous backups and restore to specific timestamps.
3. Monitoring dashboards
4. Read replicas for improved read performance
5. Multi AZ setup for disaster recovery
6. Maintenance windows for upgrades
7. Scaling both vertical and horizontal
8. Storage backed by EBS
You cannot SSH into your RDS instances.
We should highlight the benefit of RDS Storage Auto Scaling feature which is one of the greatest benefits to managing an RDS. You simply enable the feature and set a Maximum Storage Threshold for the entire Database Storage and you achieve the following:
1. Dynamically increases storage on demand when.
a. Free space falls below 10%
b. Low storage level lasts for at least 5 minutes
c. 6 hours have passed since last increase.
2. RDS detects low storage levels automatically.
3. Avoids manual scaling your database storage.
4. Benefits application with unpredictable storage requirements.
Cons of using RDS
- No OS access
- Higher Cost compared to traditional dabase configuration
- Limited configuration options and not costumizable.
- Performance degradation of database.
- Limited on its scalability.
- Dependent on AWS with sever restrictions on administrative functions of customer.
- May require downtime controlled by AWS not customer.
- Zero transparency on database maintenance.
- Lacks many database features of standard installation and configuration.