What is sharding?

Split data across servers.

What is sharding?

Sharding splits a large table across multiple nodes horizontally. Each shard holds a subset of the table. Replication copies data, sharding splits it.

CREATE TABLE orders (id INT, ...)
PARTITION BY HASH (customer_id);

Sharding splits data.

The table orders is created.

What is sharding? — details

Hash sharding places a row on a shard by hashing the key. Range sharding splits by interval (date, region). Each method distributes data differently.

Exercise What is sharding?

Shard the orders table with PARTITION BY HASH (customer_id).

Show example solution

CREATE TABLE orders (id INT, amount NUMERIC) PARTITION BY HASH (customer_id);

Test yourself

How does sharding split data?
- Horizontally
- Vertically
- By type
- By column
Show answer

Horizontally — Sharding splits data horizontally.

Partition method

CREATE TABLE orders (id INT, amount NUMERIC) PARTITION BY ____ (customer_id)

Show answer

CREATE TABLE orders (id INT, amount NUMERIC) PARTITION BY HASH (customer_id)

What is sharding: match the terms

sharding

sharding
shard

shard
hash

hash
range

range

Next lesson: Shard key

We Are Enhancing Your Experience

Cookie Preferences

Strictly Necessary Cookies

Analytical Cookies