Re:Scaling Relational SQL Databases (2020)
by evanelias on Wednesday June 16, 2021 @02:34PM
(#27531884)
Immutability makes it easier to scale writes in a relational DB, but comes at the expense of more complexity and difficulty scaling reads. It's also problematic with regulation like GDPR / "right to be forgotten".
Immutability is definitely not a requirement for scaling a database. In my direct experience, the vast majority of large tech companies use mutable relational databases, with a write workload mixing INSERTs, UPDATEs, and DELETEs.
If you want to scale database, all your write operations should be immutable and therefore you should rarely need UPDATE statements.