Summary - Replication and sharding

Shard a users table by shard key.

Summary - Replication and sharding

Replication copies data (publication/subscription), sharding splits it (PARTITION BY HASH/RANGE). Master writes, slaves read. Synchronous is consistent, asynchronous is fast.

-- CREATE PUBLICATION -> CREATE SUBSCRIPTION
-- PARTITION BY HASH / RANGE

Replication copies, sharding splits.

Exercise Summary - Replication and sharding

Summary task: shard the users table with PARTITION BY HASH (user_id).

Show example solution

CREATE TABLE users (user_id INT, name TEXT) PARTITION BY HASH (user_id);

Test yourself

Replication publication

CREATE PUBLICATION pub_users FOR TABLE ____

Show answer

CREATE PUBLICATION pub_users FOR TABLE users

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

Horizontally — Sharding splits data horizontally.
Summary - Replication and sharding: match the terms

replication

copy
sharding

split
master

master
sync

sync

Next lesson: Distributed queries

We Are Enhancing Your Experience

Cookie Preferences

Strictly Necessary Cookies

Analytical Cookies