Articles
Deep dives on .NET, React, cloud and everything in between.
Database Partitioning — Database Scaling
Database Partitioning means splitting a very large table into smaller logical pieces called partitions, while applications continue to access the table as a single table.
26 Sep 2026 · 31 views
Synchronous vs Asynchronous Replication — Database Scaling
The most important replication decision is whether the primary should wait for the secondary before confirming a write.
26 Sep 2026 · 26 views
Replication — Database Scaling
Database replication means copying data from one database server to one or more other database servers.
26 Sep 2026 · 33 views
Primary / Secondary Database — Database Scaling
Primary/Secondary is a database architecture where one database node acts as the Primary for write operations and one or more Secondary nodes maintain copies of the data. The secondary nodes can be used for read scaling, high availability, reporting, and failover, depending on the database technology.
26 Sep 2026 · 23 views
Read Replica — Database Scaling
A Read Replica is a copy of the primary database that is mainly used to handle read traffic. It is one of the most common techniques for scaling a database when the application has significantly more reads than writes.
26 Sep 2026 · 29 views
Connection Pooling
Every time an application needs to communicate with a database or another service, creating a new connection has a cost.
26 Sep 2026 · 23 views
Optimistic vs Pessimistic Locking
When multiple users try to update the same database record at the same time, we need a way to prevent incorrect updates.
26 Sep 2026 · 22 views
Deadlocks
A deadlock occurs when two or more transactions are waiting for each other to release resources, and none of them can continue.
26 Sep 2026 · 21 views
Isolation Levels
When multiple users update the database at the same time, transactions can interfere with each other. Isolation Levels define how much one transaction is isolated from changes made by another transaction.
26 Sep 2026 · 24 views