4 ms·
Relational databases don't scale horizontally all that far because of the challenges in replicating writes. Either you do delayed replication and have inconsist
by Joeri 10y ago
Relational databases don't scale horizontally all that far because of the challenges in replicating writes. Either you do delayed replication and have inconsistent slaves, or you do sharding and have a complicated app layer.
The trick to scaling a sql db is to either shard it and treat it like nosql with worse tooling, or go vertical as far as you can before you go horizontal. Luckily, there aren't many workloads that require horizontal scaling. Stackoverflow can run on a single beefy db server.
- user5994461 10y agoThey can scale by normalizing and dropping transactions. Then that's really close to a NoSQL db, so might as well use a No SQL db.