Sql

Relational DB vs NoSQL — Interview Answer Template (with QPS Details) 1. Throughput & Scalability A relational database like MySQL can handle moderate QPS well. Rough Numbers (rule of thumb, varies by setup): Single MySQL instance ~1K – 5K QPS (typical production range) With read replicas Reads can scale to 10K+ QPS With sharding Can scale to 100K+ QPS, depending on number of shards However, sharding introduces additional complexity: Choosing a good shard key Avoiding hotspot partitions Handling cross-shard queries Rebalancing data Example Tradeoffs: Shard by userId ...