Db Replication Sharding
Replication and sharding workflow for scaling read/write throughput while managing consistency, failover, and data distribution risk. Use when single-node limits are reached or resilience requires topology changes; do not use for local query tuning only.
Install
$ agentstack add skill-kentoshimizu-sw-agent-skills-db-replication-sharding ✓ scanned · ✓ verified — works with Claude Code, Cursor, and more.
Security review
✓ PassedNo issues found. Passed automated security review. · v0.1.0 How review works →
- ✓ Prompt-injection patterns
- ✓ Secret / credential exfiltration
- ✓ Dangerous shell & filesystem operations
- ✓ Untrusted network calls
- ✓ Known-malicious package signatures
What it can access
- ✓ Network access No
- ✓ Filesystem access No
- ✓ Shell / process execution No
- ✓ Environment & secrets No
- ✓ Dynamic code execution No
From automated source analysis of v0.1.0. “Used” means the capability is present in the source — more access means more to trust, not that it’s unsafe.
About
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.
Practitioner Heuristics
- Choose shard keys by access locality and growth distribution, not by convenience.
- Read replicas are eventually consistent systems; classify which reads can tolerate lag.
- Cross-shard joins and transactions should be exceptions with explicit ownership.
- Topology decisions must include operational playbooks for failover and rebalancing.
Workflow
- Profile read/write distribution and growth projections.
- Select replication topology by availability and consistency needs.
- Evaluate shard key candidates and hotspot risk.
- Design routing, rebalancing, and failover behavior.
- Define application-level behaviors for lag, split-brain prevention, and retries.
- Document expansion path and de-risking milestones.
Common Failure Modes
- Shard key creates unbounded hotspots as tenants grow.
- Replica lag assumptions leak into business-critical reads.
- Rebalancing is planned as manual emergency work only.
Failure Conditions
- Stop when shard key cannot support projected growth distribution.
- Stop when consistency expectations contradict selected topology.
- Escalate when failover and rebalancing are operationally infeasible.
Source & license
This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.
- Author: KentoShimizu
- Source: KentoShimizu/sw-agent-skills
- License: Apache-2.0
Install and usage instructions live in the source repository linked above.
Reviews
No reviews yet — be the first.
Write a review
Versions
- v0.1.0 Imported from the upstream source.