tl;dr:“Large databases often have a small number of very large tables that makes scaling difficult. How can you scale with these while keeping your database performant? This article covers vertical scaling, vertical sharding and horizontal sharding.”
tl;dr:“By the time you finish this article, you'll have learned how B-trees and B+trees work, why databases use them for indexes, and why using a UUID as your primary key might be a bad idea.”