4 ms·
What do you mean by at scale? At what scale? In the past, I've supported a few million daily active users on a single MySQL database. Use cases obviously vary
by sbov 8y ago
What do you mean by at scale? At what scale?
In the past, I've supported a few million daily active users on a single MySQL database.
Use cases obviously vary, your numbers may not line up.
But I'm pretty sure there are lot of startups that would be fine starting with an architecture that can scale to 2 million users per day.
- jjirsa 8y agoA few million DAU is not at scale. A few million concurrent active users might be, but really, “at scale” has no meaning other than “we got to the point where shit gets hard”. And that point is different for every app. I remember watching a big xbox/ps3 game launch crash and burn when 16 of the biggest MySQL servers we could buy couldn’t keep up. That was two jobs ago and embarrassing (and probably expensive). That was “at scale” for us. Last job we started at about 60 m4 ex2 instanced and were well into the thousands when I left. I suspect they’re approaching 10k instances now. And they’re pre-IPO startup, and I think that was at scale. Current job measures in the hundreds of thousands of database instances, and I only count one specific database engine. Probably counts as at scale.
- ThePhysicist 8y agoReally curious what kind of problem requires 100.000s of DB servers, and what database system is actually capable of such massive horizontal scaling? Are you able to provide any specifics? I imagine that typically a single instance can serve at least 100-1000 concurrent users, meaning you have about 10 to 100.000.000 concurrent users on the system? Since you mentioned gaming I assume it's a massive multiplayer-game like Fortnite?
- jjirsa 8y agoGaming was two jobs ago. It’s apache Cassandra, and I work for a large tech company.