The Backend Engineering Show with Hussein Nasser

How Shopify’s engineering improved writes by 50% with ULID | The Backend Engineering Show

Dec 23, 2022

32:10

Creator website

Highlights

AI Chapters

Episode notes

Idempotent Is a Critical Concept, Right?

02:49

Idempotency Keys - What You Need to Know

02:43

Using UUIDs to Generate Unique IDs

02:27

Introduction

3min

Idempotent Is a Critical Concept, Right?

3min

Idempotency Keys - What You Need to Know

3min

UUIDs Are Very Powerful

3min

Clustered Indexes Work

3min

Clustered Indexes - Clustering MySQL Databases

3min

Using UUIDs to Generate Unique IDs

2min

How to Generate a Request in Shopify?

2min

How Fast Are Reads?

3min

10.

SQL MySQL

3min

11.

How to Generate a Short URL Using UUIDs

2min

12.

Why Is MySQL Clustering a Good Idea?

4min

Fundamentals of Database Engineering udemy course (link redirects to udemy with coupon)

https://database.husseinnasser.com

Shopify posted a blog on tips to for scalable payment system, one tip peeked my interest related to switching from UUID to ULID. I explore the reasoning behind this in this video.

https://shopify.engineering/building-resilient-payment-systems

0:00 Intro

1:30 idempotency

6:30 UUID vs ULID

9:50 Clustered Index

13:30 Why UUID4 Inserts are slow

17:15 How ULID helps Shopify

22:00 Problem with tail pages

25:00 Does ULID help in all cases?

Fundamentals of Backend Engineering Design patterns udemy course (link redirects to udemy with coupon)

https://backend.husseinnasser.com

Remember Everything You Learn from Podcasts

Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.