News for hackers. Stuff that matters.
Re:A bit on scaling chess.com's database by tutfbhuf on Tuesday January 12, 2021 @02:48AM (#25743618)
There are "new generation" databases, some of them MySQL 5.6 compatible (e.g. Vitess) with the ability to massively scale in terms of read/write QPS (queries per second).

In database related podcasts you will hear that QPS is considered to be a solved problem nowadays.

Re:A bit on scaling chess.com's database by ikonic89 on Tuesday January 12, 2021 @03:24AM (#25743862)
We did test Vitess couple of years ago, just decided not to go with it. There were a lot of reasons for that, maybe a topic for another post.
Re:A bit on scaling chess.com's database by tutfbhuf on Tuesday January 12, 2021 @03:32AM (#25743916)
Vitess is just one example, there are others. And it depends, some teams might be able to do some work to get along with MySQL, like chess.com. As in most cases, there is no silver bullet here.