Articles

Deep dives on .NET, React, cloud and everything in between.

Clear
Database System Design / General

Point-in-Time Recovery — Database Scaling

Point-in-Time Recovery (PITR) means restoring a database to a specific moment in time, usually just before an accidental deletion, corruption, or other unwanted change.

27 Sep 2026 · 23 views

Database System Design / General

Database Backup — Database Scaling

Database Backup means creating a recoverable copy of database data so it can be restored after accidental deletion, corruption, hardware failure, security incidents, or other disasters.

27 Sep 2026 · 22 views

Database System Design / General

Multi-Region Database — Database Scaling

Multi-Region Database means maintaining database infrastructure across multiple geographic regions so the system can continue operating even if an entire region becomes unavailable.

27 Sep 2026 · 24 views

Database System Design / General

Multi-AZ Database — Database Scaling

Multi-AZ (Availability Zone) means running database infrastructure across multiple isolated Availability Zones within the same cloud region so that a failure in one zone does not take down the database service.

26 Sep 2026 · 30 views

Database System Design / General

Database Failover — Database Scaling

Database Failover is the process of switching database operations from a failed or unhealthy primary database to a healthy secondary database.

26 Sep 2026 · 34 views

Database System Design / General

Consistent Hashing — Database Scaling

Consistent Hashing is a technique used to distribute keys across multiple nodes while minimizing data movement when nodes are added or removed.

26 Sep 2026 · 27 views

Database System Design / General

Shard Key — Database Scaling

A Shard Key is the column or combination of columns used to decide which shard should store a particular row.

26 Sep 2026 · 52 views

Database System Design / General

Sharding — Database Scaling

Sharding means distributing data across multiple independent database instances or servers. When a single database becomes too large or receives too much traffic, we can split the data across multiple databases called shards.

26 Sep 2026 · 30 views

Database System Design / General

Horizontal Partitioning — Database Scaling

Horizontal Partitioning means splitting a large table by rows while keeping the same table structure.

26 Sep 2026 · 26 views

1 2 3 4 5 6 7 8

Never miss a new post 📬

Get an email whenever a new article, project, cheatsheet or video drops.

✅

ℹ️