Develop a sharding strategy step by step. Current database: {{database_info}} Growth projections: {{growth_projections}} Query patterns: {{query_patterns}} Think through systematically: 1. SHARDING NECESSITY: Do we really need sharding? What are alternatives? 2. SHARD KEY SELECTION: What is the optimal shard key? Why? 3. SHARD DISTRIBUTION: How will data distribute? Hot spots? 4. CROSS-SHARD QUERIES: What queries will cross shards? How often? 5. SHARD SIZING: How many shards? How will this grow? 6. RESHARDING: How do we add shards later? 7. TRANSACTIONS: What happens to multi-row transactions? 8. JOINS: How do we handle joins across shards? 9. ROUTING: How does the application route to the right shard? 10. MIGRATION: How do we migrate to sharded architecture? 11. OPERATIONAL COMPLEXITY: What new operational challenges arise?
Database Sharding Strategy
Develop a database sharding strategy through systematic analysis.
69 copies0 forks
Share this prompt:
Details
Category
CodingUse Cases
Database scaling strategySharding architecture designData tier optimization
Works Best With
claude-opus-4.5gpt-5.2gemini-2.0-flash
Created Updated Shared