Alex Petrov, author of Database Internals explains the ins and outs of database storage engines. What are they? How do they differ? What problems do they solve? Host Adam Gordon Bell spoke with Alex about these questions as well as how information is stored on disk, different strategies for building indexes and the difference between log structured merge trees and B Trees. Alex also touches on the topic of solid state drives and how their strengths are more suited towards certain storage engine implementations and how a storage engine affects important characteristics of a database, like its strengths and weaknesses in write heavy or read heavy workloads.
Show Notes
Related Links
- Database Internals Book
- MySql Indexes
- Why uber switched to MySQL
- Rum Conjecture
- OpenLDAP
- WiredTiger
- RocksDB
- LSM Tree Paper
SE Radio theme music: “Broken Reality” by Kevin MacLeod (incompetech.com)
Licensed under Creative Commons: By Attribution 3.0
