> For their largest clusters they are able to support more than a million writes/sec and ~100k reads/sec.
Why is read 10x more expensive than writes?
Why is read 10x more expensive than writes?
I've seen some databases work in "append only" mode. They write new data to the end of the file. They never erase existing data.
It's generally a very efficient write patterns (even on good old spinning drives) and it allows to always write in batch.
On the opposite, read are expensive, they require to "find" stuff from various places and read it and verify it and [if configured] repeat on multi nodes to compare the values.
I think newer data and tombstones would stay for a while in sstables, not in the log.