Partitioning & Sharding

Partitioning & Sharding

Splitting the data without splitting the query
Free
5h · 5 lessons
Overview

Relational modelling, indexes, transactions, the NoSQL families and what each one is actually for, then replication and sharding. More interviews are lost on the storage layer than on any other part of the diagram.

This module is 02.6 of the 6 in Data Storage & Retrieval. It runs about 5 hours across 5 lessons, and closes with Skew — One partition is taking 80% of the traffic. Reshard it live, without dropping a write.

Lessons
1. Range, hash and directory partitioning

Concept · 40 minutes

2. Choosing a partition key, and living with it

Concept · 40 minutes

3. Hot partitions and skew

Concept · 30 minutes

4. Secondary indexes across partitions

Concept · 35 minutes

5. Rebalancing and online resharding

Concept · 40 minutes

Module information
Duration
5 hours
Lessons
5
Level
Beginner
Track
Data Storage & Retrieval
Drill
Skew
Price
Free

Related modules

Relational Modelling
5 hours
5 lessons
Beginner
Relational Modelling
Free
02.1
Indexes & Query Plans
5 hours
5 lessons
Beginner
Indexes & Query Plans
Free
02.2
Transactions & Isolation
5 hours
5 lessons
Beginner
Transactions & Isolation
Free
02.3
NoSQL & Choosing a Data Model
5 hours
6 lessons
Beginner
NoSQL & Choosing a Data Model
Free
02.4