Hacker News Reader

MySQL gets a bad rap because of it's casual wrangling of data types and query formats.

Performance wise it's one of the toughest battle tested system you can imagine.

But is it Web Scale?

Adding the reference [1] in case it is obscure for some.

[1] - https://www.youtube.com/watch?v=b2F-DItXtZs [video][language]

It works if you rig it to work well at that scale. Google used a modified version of MySQL to host AdWords for a long time. A very large database with massive qps:

https://insidebigdata.com/2013/09/18/googles-f1-database-mea...

Why not? MySQL can be extremely performant at scale. I’ve seen tiny MySQL databases serve in ver 50k req/sec.

Facebook uses it for user data

MySQL can back 50,000+ QPS services!

1. Sharding.

2. Different DBs for different microservices. Purpose-specific. Ship analytics data out for BI.

3. Redis layer for high QPS services with repetitive queries (eg. session stores)

MySQL scales incredibly well

We have billions of MySQL tables at work. It scales well.

Billions (plural, which implies at least two) of tables? I doubt that.

I would believe millions of tables. Or billions of rows.

Unless you host about 80million Wordpress blogs, or 8 million WHMCS installs