Course contentsShow
← System Design
Lesson 1388 of 1,91934. Data Replication StrategiesFree lesson

Conflict Avoidance Through Design

Architectural patterns to minimize conflicts: routing users to specific replicas or using immutable data.

Conflict Avoidance Through Design

What you'll learn: How to design systems that prevent replication conflicts before they happen, rather than resolving them after the fact.

The Best Conflict Is No Conflict

Up to this point, we've explored various conflict resolution techniques—LWW, version vectors, CRDTs, merge functions. But the smartest approach is often to architect your system so conflicts never arise in the first place. Think of it like city planning: you could install traffic lights everywhere to handle collisions, or you could design streets so cars never meet at intersections.

Architectural Patterns for Conflict Avoidance

User-to-Replica Routing (Sticky Sessions)

Route each user consistently to the same replica for writes. If Alice always writes to Replica A and Bob always writes to Replica B, their updates won't conflict even in multi-leader setups. This works best when data naturally partitions by user (personal documents, shopping carts, user profiles).

Trade-off: You lose some availability if a user's designated replica goes down, though you can implement fallback routing.

Immutable Data Patterns

Design your data model around append-only, immutable records instead of updates. Rather than modifying user.balance = 100, you append transaction events: {type: "deposit", amount: 50}. Since nothing ever changes, there's nothing to conflict.

This is the foundation of event sourcing and works beautifully with distributed systems—events can arrive in any order at different replicas without conflicts.

Single Writer per Data Item

Partition your data so each piece has exactly one writer. Use consistent hashing or partition keys to ensure only one replica handles writes for user:12345. Other replicas remain read-only for that data.

Key Takeaway: The most elegant solution to replication conflicts is designing your system—through routing, immutability, or partitioning—so conflicting writes simply cannot occur. Prevention beats resolution.