Databases Store and Retrieve Data with B-Trees

I recently read the book "Database Internals: A Deep Dive into How Distributed Data Systems Work" by Alex Petrov and wrote a small blog post to summarise my learnings and provide some real world, MySQL-based examples that are missing in the book.