Databases

Adding read replicas is expected to offload the primary database. In practice, coordination costs, consistency guarantees, and hidden coupling can prevent load from moving at all.

A common assumption is that adding an index will resolve query latency. In practice, indexes often fail to change execution behavior for less obvious reasons.