Implement horizontal scaling and high-performance sharding strategies for PostgreSQL and MySQL databases.
This skill equips Claude with production-ready patterns for horizontal database scaling, covering hash, range, and directory-based sharding strategies. It provides essential guidance on shard key selection, query optimization, and architectural best practices to avoid common pitfalls like hotspots and cross-shard transaction failures. Use this skill when your application needs to handle billions of records, improve multi-tenant isolation, or resolve performance bottlenecks in distributed database environments through structured routing and data locality.
Key Features
01Zero-downtime rebalancing strategies using consistent hashing and virtual shards
02Comprehensive shard key selection criteria to ensure even data distribution
03Multi-strategy routing templates including Hash, Range, and Directory-based sharding
04Detailed error catalog for preventing hotspots and cross-shard transaction issues
05Patterns for cross-shard operations like scatter-gather and global aggregation
0621 GitHub stars
Use Cases
01Managing high-volume time-series data with range-based partitioning for efficient archival
02Scaling a SaaS application using multi-tenant directory-based sharding for isolation
03Building global user databases with hash-based sharding to ensure even load distribution
