News for hackers. Stuff that matters.

A comment on The myth of “joins don't scale”. Parent comment

Re:The myth of “joins don't scale” by nine_k on Wednesday July 08, 2020 @07:48PM (#23775533)
A single DB server is a SPOF. You normally need a hot standby if you care about availability. You can also replicate transactions to read-only copies to alleviate the read load.

What most companies can do well with is a single master DB which handles updates.

(Some companies can't, though; e.g. GrubHub switched to Cassandra because no monolithic RDBMS could handle the write load.)

[ Parent | on HN ]
Re:The myth of “joins don't scale” by ConnorLeet on Wednesday July 08, 2020 @08:22PM (#23775749)
How many op/s was that? Bytes/s? Just curious because I was involved in migrating a write-heavy service off of C* to SQL Server. Our writes have higher latency now, but using managed SQL is worth it. (much cheaper too)
[ Parent | on HN ]