One million queries per second with MySQL
Sep 1, 2022Jonah Berquist

Summary
This post demonstrates PlanetScale's ability to achieve over one million queries per second using a Vitess-based MySQL cluster. It details benchmarking with a TPC-C sysbench workload, showing how horizontal sharding (doubling shards from 16 to 32 and then to 40) directly correlates with increased throughput (QPS). The post also illustrates diminishing returns and increased latency as individual shards reach their resource limits, highlighting the need for more shards to scale throughput. It confirms that 40 shards achieved the target of over 1M QPS.