Blogs

Advancements

Sep 03, 2024 : SQL Has Problems. We Can Fix Them: Pipe Syntax In SQL

Concepts - Single-node Databases

Jul 19, 2021 : Understanding Durability in ACID
Jul 07, 2021 : Understanding Isolation in ACID
Jul 02, 2021 : Understanding Atomicity in ACID
Jul 02, 2021 : Understanding Consistency in ACID
May 31, 2020 : The RUM Conjecture
May 03, 2020 : What is copy-on-write and why it matters?

Concepts - Distributed Databases

Feb 07, 2022 : How indexes work on partitioned and sharded data?
Jan 31, 2022 : Data partitioning strategies for distributed databases
Jan 24, 2022 : What is Data Partitioning and why it matters at scale
Jan 16, 2022 : What is leaderless replication and how it works?
Jan 03, 2022 : How to resolve conflicts in multi-master setup
Nov 28, 2021 : How to detect conflicts in a multi-master setup
Nov 03, 2021 : What is multi-master replication and why do we need it?
Oct 03, 2021 : What are monotonic reads, and why do we need them?
Sep 22, 2021 : Read-your-write consistency
Aug 15, 2021 : Understanding replication formats in a master-replica setup
Aug 10, 2021 : Two ways to replicate data across database cluster
Aug 07, 2021 : What is a master-replica setup and why it matters?

Datastore Deepdives

Jul 19, 2020 : Bitcask - A Log-Structured fast KV store

Benchmarks and Prototypes

Mar 24, 2017 : I benchmarked different pagination strategies in MongoDB
Mar 23, 2017 : Why MongoDB's cursor.skip() is slow?
Mar 22, 2017 : How to paginate faster with consistent performance?

Productionization

Sep 07, 2021 : How to handle database outages?
Aug 23, 2021 : What happens when we add a new replica?

Algorithms

Nov 29, 2020 : 2Q-cache algorithm for disk-backed databases
Nov 22, 2020 : Israeli Queues
Aug 23, 2020 : Constant time implementation of the LFU cache eviction algorithm
Apr 26, 2020 : A midpoint insertion caching strategy to avoid cache bust

Writings and Learnings

Courses

System Design Masterclass

System Design for Beginners

Redis Internals

Legal and Contact

Terms and Conditions

Everything Else

Collaborate with me

The Smarter Chimp

Arpit's Newsletter read by 100,000 engineers

Weekly essays on real-world system design, distributed systems, or a deep dive into some super-clever algorithm.

Subscribe on LinkedIn Subscribe on Substack

LinkedIn (180k)

© Arpit Bhayani, 2024