Amazon RDS - Relational Database Service
What is Amazon RDS?
Amazon RDS (Relational Database Service) is a managed service for relational databases that use SQL. RDS handles backups, patching, and hardware provisioning automatically.
Supported database engines: Amazon Aurora, PostgreSQL, MySQL, MariaDB, Oracle, SQL Server
Common use cases are: web applications, enterprise workloads, e-commerce platforms
Amazon RDS Video
W3schools.com collaborates with Amazon Web Services to deliver digital training content to our learners.
RDS Benefits
- Multi-AZ deployment: Replicates data to a standby instance for high availability
- Automated backups: Plus manual snapshots when needed
- Read replicas: Offload traffic for better performance
- Security: VPC isolation, encryption at rest and in transit
Relational Database Example
| ID | Product name | Price |
|---|---|---|
| 1 | T-shirt | $20 |
| 2 | Jeans | $35 |
| 3 | Shoes | $50 |
Amazon Aurora
Aurora is a high-performance database compatible with MySQL and PostgreSQL, delivering up to 5x MySQL throughput and 3x PostgreSQL throughput.
It creates six copies of data across three AZs, provides 99.99% availability, and automatically scales storage from 10 GB to 128 TB.
Aurora Benefits
- Distributed storage: Across multiple nodes for high performance
- Continuous backup: To S3 with point-in-time recovery
- Auto-failover: Redirects traffic to healthy replicas
Use cases: Gaming, media/content management, real-time analytics
