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ドル |
AWS and W3Schools offers free and paid Cloud Courses
Engage in a text and video based learning experience.
Free AWS training - Upskill today and reach for the Cloud.
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