PlanetScale

One million queries per second with MySQL

Sep 1, 2022Jonah Berquist
One million queries per second with MySQL
SummaryAI, from the source post

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.

More from the Vitess-based MySQL replacement trail