Why can a replica return stale data immediately after a successful write?
Interactive Practice Mode
Formulate your thoughts or take notes before revealing the model solution.
Saved automatically
Model Answer & Deep-Dive Explanation
Many replication designs apply changes to replicas asynchronously, so a committed primary write may not yet be visible there. A user who creates a record and immediately reads from a replica can see an older state. Possible policies include reading critical follow-up operations from the primary, tracking a replication position, or using an appropriate consistency guarantee supported by the system. Measure lag and define user-facing expectations. Replication improves particular availability or scaling properties, but does not automatically provide read-your-writes consistency or replace backups.
Related Questions in Database
DBA Interview Questions
Intermediate level • 792 views
MS-SQL Server developer interview questions
Advanced level • 311 views
MySQL management interview questions
Beginner level • 220 views
How would you verify that a database backup is usable?
Medium level • 56 views
How would you model a many-to-many relationship between students and courses?
Medium level • 53 views