Databases

Lessons in this group, roughly in build order:

• rdbms-replication-master-slave-master-master — Replication keeps copies of a relational database on multiple nodes so you can survive failures and serve…
• federation — Federation (functional partitioning) splits one database into several, each owning a distinct function of…
• sharding — Sharding splits the rows of a single logical table across many databases so that writes — not just reads —…
• denormalization — Denormalization trades write cost and redundancy for read speed by storing the same data in more than one…
• sql-tuning — SQL tuning is the practice of reshaping queries, indexes, and schema so the database reads the fewest rows…
• nosql-key-value-document-wide-column-graph — NoSQL is an umbrella for non-relational stores that drop joins and rigid schemas to get horizontal scale…
• sql-vs-nosql-when-to-use-which — The choice is not “old vs new” — it is whether your workload needs relational integrity and ad-hoc…