CS-310 Lecture 09 - SQL Database Scaling

Outline:
0:07 Recap: Storage and Relational Databases
2:15 Memory vs disk access in databases
5:17 Databases are performance bottlenecks
10:46 Relational Database performance optimizations
16:40 Read replicas
20:37 What limits the number of read replicas?
24:31 Multi-level replication can extend read-scalability
29:33 How to use read-replicas?
32:58 Replication shortcomings?
34:27 Primary-primary failover for robustness
35:07 Why not allow writes to multiple primarys?
36:14 How to scale writes and storage capacity?
39:27 Sharding (data partitioning) relational databases
41:01 Sharding example
42:39 Sharding example 2
45:44 Sharding conclusions
48:06 Some Simple Scaling math
51:46 Summary
These lectures were delivered by Professor Steve Tarzia in Winter 2021 for his CS-310 Scalable Software Architectures course at Northwestern University. This class was formerly numbered CS-396. Course materials and slides can be downloaded from stevetarzia.com/teaching