3 ms·
It's generally true for traditional DBs, a few new generation DBs have options to buffer writes in memory and achieve durability via in memory replication in ot
by vicaya 17y ago
It's generally true for traditional DBs, a few new generation DBs have options to buffer writes in memory and achieve durability via in memory replication in other nodes and only writes to disk sequentially in large chunks, which is better than simple logging as you'd have to sync to avoid data loss upon hardware failure.
- geuis 17y agoDo you have any recommendations for software I should use for a db? I like the idea of a db because doing queries on it will be easier.
- cperciva 17y agoIf you're going to consider a database which buffers writes in memory, you should also consider logging which buffers writes in memory.
- vicaya 17y agoMaybe my comment was not clear enough: buffering writes in memory on a single node alone has no durability to speak of. You need either a DFS or distributed DB that does replication of the buffers on different nodes to provide some reasonable durability.