3 ms·
If you run at web scale and serve ~10 million customers, you'll need a lot of servers to keep running. Most sites aren't anywhere near that.
by theandrewbailey 2y ago
If you run at web scale and serve ~10 million customers, you'll need a lot of servers to keep running. Most sites aren't anywhere near that.
- superconduct123 2y agoYa but say I'm a small business and only have 6 servers for my website Why do I need to take all 6 offline to do maintenance?
- theandrewbailey 2y agoBecause you (accidentally or otherwise) built your infrastructure to need to. It's possible to build it so you don't have to, but most don't.
- TylerE 2y agoBecause likely there is one master, authoritative data source and that has to go down at some point.
- superconduct123 2y agoIf you need to change something in your DB wouldn't you just have a job running in the background doing the migration and have your application code handle both cases when reading the DB (migrated/unmigrated)?
- TylerE 2y agoYou say "just" like you think that sort of thing is easy. Nothing could be farther from the truth. For one thing in many DBs certain (often nessesary) schema changes require a global write lock. It's much much easier to just show down for 15 minutes or less than spend hundreds of hours of engineering effort.
- djhn 2y ago10 million isn’t web scale though. Quite a few cities, many states and a bunch of smaller EU countries would have most of their b2c businesses, local government services and heck, even local newspapers serve 10 million people. That’s not web scale, that could be SQLite on one machine.