- Read replica or in-memory cache increases read scalability, but it often creates some irritating due to data inconsistency or replication lag.
| Read Replica | In-Memory Cache | |
|---|---|---|
| Dynamic Query Patterns | ✅ Preferred | ❌ Not-Preferred |
| Replica Lag | Yes | 🚀 No |
| Data Consistency Bugs | ✅ Less | More |