database-sharding
Horizontal database sharding, partition keys, distributed transactions, and rebalancing strategies.
SKILL.mdskills/database-sharding/SKILL.md
GitHubDatabase Sharding Protocol
- Select a high-cardinality shard key that aligns with standard query boundaries (e.g. tenant_id).
- Avoid cross-shard joins and distributed two-phase commit transactions.
- Plan for consistent hashing to minimize data movement during cluster rebalancing.