AWS RDS
Operations 1: Backups
- In AWS RDS we can
- create manual backups (Snapshot)
- configure Automated Backups:
- Number of Days
- Point in time restore
Operations 2: Maintenance
- Configure Maintenace window: Time when your database is least used and ok to be slow (low performing)
Operations 3: Database Proxy
- Refer Here for official notes
Operations 4: Database Caching
- We can cache the results in Datbase Caches to improve query performance
Pricing
- Refer Here for aws pricing calculator
- RDS Pricing Models
- On Demand
- Reservations
- Rough hourly pricing
db.m7g.8xlarge
ondemand : $2.696
Reserved (1 year):
No upfront: $2.076
Partial Upfront: $2.022
All upfront: $1.968
Reserved ( 3 years)
Partial Upfront: $1.483
All upfront: $1.429
Amazon Aurora
- Aurora offers Posgresql and mysql where db engines are rewritten by AWS to enhance db query performance
-
Architecture
- Aurora also offers serverless database
