AWS - RDS and Relational Databases
If a read replica lags behind the primary database, what is the likely impact on application read queries directed to the replica?
If a read replica lags behind the primary database, what is the likely impact on application read queries directed to the replica?
medium📝 service behavior Q5 of 15
Step-by-Step Solution
Solution:
Step 1: Understand replication lag
Replication lag means the replica is behind the primary in data updates.Step 2: Effect on reads
Reads from the replica may return outdated (stale) data until lag catches up.Final Answer:
Application may read stale data from the replica -> Option AQuick Check:
Replication lag causes stale reads = A [OK]
Quick Trick: Lag causes stale reads, not errors or rejections [OK]
Common Mistakes:
MISTAKES- Assuming lag causes write errors
- Thinking replica rejects reads during lag
Master "RDS and Relational Databases" in AWS
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore AWS Quizzes