Re:What's the big deal about embedded key-value databases?
by lcnPylGDnU4H9OF on Tuesday August 23, 2022 @03:04PM
(#32569684)
Actually, this helps a lot. I'd never heard of RocksDB and I'm barely familiar with InnoDB and hopefully I am not wrong to compare the two.
Re:What's the big deal about embedded key-value databases?
by lacker on Wednesday August 24, 2022 @12:04PM
(#32581297)
Yes, that's right, InnoDB is the default MySQL storage engine and you can replace InnoDB with RocksDB. To summarize in one sentence, InnoDB is better at reads and RocksDB is better at writes, but if you were making an actual decision you should look at more detailed information than my one-sentence summary, such as:
https://minervadb.com/index.php/2018/06/06/a-friendly-compar...
Re:What's the big deal about embedded key-value databases?
by tomhallett on Tuesday August 23, 2022 @02:12PM
(#32568840)
100% agreed. TIL that mysql uses RocksDB under the hood.
Here's another example of a realtime database which uses RocksDB under the hood: https://rockset.com/blog/how-we-use-rocksdb-at-rockset/
Re:What's the big deal about embedded key-value databases?
by eatonphil on Tuesday August 23, 2022 @02:35PM
(#32569177)
As far as I'm aware, MySQL does not use RocksDB under the hood by default. MyRocks is a distribution of MySQL that uses RocksDB.
Re:What's the big deal about embedded key-value databases?
by moralestapia on Tuesday August 23, 2022 @02:58PM
(#32569591)
Yeah, weird comment from GP. By the time RocksDB was born, MySQL was already going to prom.
Re:What's the big deal about embedded key-value databases?
by ruw1090 on Tuesday August 23, 2022 @03:44PM
(#32570373)
Close, but in database years it was actually already in its mid life crisis.
Application
|
MySQL
|
RocksDB
|
Filesystem
In general the MySQL layer is doing all the convenient stuff for application developers like supporting different queries and datatypes. The RocksDB layer is optimizing for performance metrics like throughput and reliability and just treats data as sequences of bytes.