DB Replication Sharding

Overview

Use this skill to design data topology that scales safely without hiding consistency and operability costs.

Scope Boundaries

• Throughput, storage, or availability limits exceed single-instance capacity.
• Read/write scaling requires replication or partitioning.
• Regional or tenant growth pressures topology redesign.

Core Judgments

• Replication mode and consistency expectations for read paths.
• Shard key strategy and future rebalancing feasibility.
• Cross-shard query/transaction requirements.
• Failover behavior and recovery-time expectations.