7 Database Scaling Strategies
Seven database scaling strategies across replicas, sharding, caching, and partitioning.
Database and Storage
Databases, storage engines, and data access tradeoffs covering consistency, indexing, replication, durability, and system behaviour at scale.
ACID Transaction Guarantees
ACID transaction guarantees for atomicity, consistency, isolation, and durability.
Database Performance Cheat Sheet
Database performance through indexing, query shape, caching, and contention control.
Database Lock Types
Database locks compared by compatibility, granularity, and concurrency control.
Database Sharding Concepts
Database sharding through shard keys, fan-out queries, and rebalancing.
Types of Databases
Database types compared by data model, query pattern, and consistency needs.
Consistent Hashing
Consistent hashing for stable key placement as nodes join, leave, or fail.
CAP Theorem Misconceptions
CAP theorem under network partitions, and why pick-two thinking is misleading.
Message Queue Evolution: IBM MQ, RabbitMQ, Kafka, and Pulsar
Message queue evolution from brokered delivery to partitioned event logs.
Database Sharding Overview
Database sharding through partition keys, routing, rebalancing, and cross-shard tradeoffs.
Read Replica Pattern Implementation
Read replica routing through database middleware, lag control, and failover.
8 Data Structures Used in Databases
Eight database data structures for indexing, storage layout, caching, and query access.
iQIYI Database Selection Tree
Database selection through workload-driven choices across relational and NoSQL.
PostgreSQL as a General-Purpose Database
PostgreSQL adoption through transactional breadth, extensions, and consolidation.
PostgreSQL's Enduring Popularity
PostgreSQL combines reliable transactions, rich features, and room to grow.
Serverless Databases
Serverless databases scale managed compute and storage with demand.
SQL Statement Execution in a Database
SQL execution through parsing, optimisation, storage engines, and concurrency control.
6 Database Models
Database models for flat, hierarchical, network, relational, object, and document data.
4 Data Sharding Algorithms
Data sharding algorithms for key placement, hotspot control, and shard rebalancing.
Types of Memory
Memory hierarchy from registers to storage, with speed, size, and cost tradeoffs.
Cloud Database Cheat Sheet
Cloud database types mapped to workload shape, query model, and operations.
Database Type Selection
Database selection through workload shape, consistency needs, and access patterns.
B-Tree vs. LSM-Tree
B-tree and LSM-tree tradeoffs for reads, writes, compaction, and storage layout.
Eventual Consistency Patterns
Eventual consistency patterns for asynchronous propagation, sync, and replica convergence.
Six Object Storage Use Cases
Six common object storage workloads, from archives and backups to data lakes.
Storage Systems Overview
Block, file, and object storage compared through access model and system tradeoffs.
Kafka Message Loss Scenarios
Kafka message loss scenarios across producers, brokers, replication, and consumers.
Change Data Capture for Real-Time Data
Change Data Capture from database logs to downstream streams and derived systems.
Message Delivery Semantics
Delivery semantics across loss, duplication, retries, and processing guarantees.
Erasure Coding
Erasure coding for durable storage with parity fragments and repair trade-offs.
Event Sourcing System Design
Event sourcing as append-only state, replay, projections, and audit history.
Time-Series Database (TSDB) in 20 Lines
Time-series database structure for timestamped writes, tags, retention, and queries.
Four Queue Types
Four queue structures and the insertion and removal rules that define them.
Kafka Performance Architecture
Kafka stays fast through append-only logs, batching, partitions, and page cache.
Six Data Management Patterns
Data management patterns for caches, replicas, indexes, and analytical stores.
Database Isolation Levels
Isolation levels explained through read anomalies, locking, and concurrency tradeoffs.
Kafka Fundamentals
Kafka fundamentals for logs, brokers, partitions, producers, and consumers.
Data Migration with Avro
Apache Avro schema evolution for compatible data migration between systems.
Types of Message Queues
Message queue types compared by delivery model, retention, and broker behaviour.
Large File Uploads to S3
Large S3 uploads through multipart transfers, parallel parts, and retries.
Pessimistic vs. Optimistic Locking
Pessimistic and optimistic locking compared by contention, retries, and consistency.
Read Replica Pattern
Read replica architecture for scaling queries away from the primary database.