Re:One million queries per second with MySQL
by derekperkins on Friday September 02, 2022 @12:22AM
(#32686556)
That matches many, if not most most real world workloads. When hotspots happen, you just continue to shard, as they don't have to be equally sized, even if you shard a single warehouse id to a dedicated node and vertically scale it up.
[ Parent
| on HN ]
Re:One million queries per second with MySQL
by AdamProut on Friday September 02, 2022 @02:52AM
(#32687444)
Yep, lots of real world workloads shard very well. That wasn't my point. My point was that "most" distributed SQL Databases that do sharding will do very well on TPC-C. You can google search for equivalently impressive results for many distributed SQL databases. Each of them can keep adding more warehouses to the TPC-C workload along with more hosts and shards to the distributed SQL database to push the TPC-C TpmC results into the millions.