</>Học Dev
Bài học

Tuần 6 - Ngày 2: RDS & Aurora Deep Dive

Tuần 6 – Ngày 2

Tuần 6 - Ngày 2: RDS & Aurora Deep Dive

1. RDS Multi-AZ

┌─────────────────────────────────────────────────────────┐│RDSMULTI-AZ││││┌─────────────────┐┌─────────────────┐│││AZ-a││AZ-b││││┌─────────┐││┌─────────┐│││││Primary│───┼────┼──►│Standby││││││(Active)││Sync││(Passive)│││││└─────────┘│Repl│└─────────┘│││└─────────────────┘└─────────────────┘││││Failovertriggers:││-Primaryinstancefailure││-AZfailure││-Instancetypechange││-Manualfailover(forpatching)││││Failovertime:60-120seconds│└─────────────────────────────────────────────────────────┘

2. RDS Read Replicas

Up to 15 read replicas (Aurora), 5 (other engines)

Cross-Region Read Replica:
- Async replication
- Different region for DR
- Can be promoted to standalone

Read Replica Use Cases:
1. Read scaling
2. Reporting/Analytics
3. DR (promote if needed)

3. RDS Proxy

┌─────────────────────────────────────────────────────────┐│RDSPROXY││││Problem:ManyLambdafunctions=Manyconnections││││┌──────────┐┌──────────┐┌──────────┐│││Lambda1││Lambda2││LambdaN│││└────┬─────┘└────┬─────┘└────┬─────┘│││││││└─────────────┼─────────────┘││▼││┌─────────────────┐│││RDSProxy│Connectionpooling│││(Managed)│Autofailover││└────────┬────────┘│││Limitedconnections││▼││┌─────────────────┐│││RDS/Aurora│││└─────────────────┘│└─────────────────────────────────────────────────────────┘

4. Aurora Features

Aurora Serverless v2

Scaling:
- Min: 0.5 ACU
- Max: 128 ACU
- Scale in seconds

Pricing:
- Per ACU-hour
- Storage separate

Use cases:
- Variable workloads
- Dev/Test
- Multi-tenant SaaS

Aurora Machine Learning

Integrate with ML services from SQL:
- SageMaker (custom models)
- Comprehend (sentiment)

SELECT
  review,
  aws_comprehend.detect_sentiment(review) as sentiment
FROM reviews;

5. Database Cloning

Aurora Cloning:
- Copy-on-write (instant)
- No storage copied initially
- Independent after creation

Use cases:
- Testing with production data
- Analytics without impacting prod
- Debugging

Tài liệu tham khảo chính thức

Ngày tiếp theo: DynamoDB Deep Dive