Software Engineering
Architecture Evolution
A comprehensive guide to system architecture evolution covering reverse proxy load balancing caching database separation distributed systems microservices and cloud migration strategies for scalable enterprise applications.
January 27, 2026
Concurrency Control and Locking
Learn about database concurrency control mechanisms including pessimistic locking optimistic concurrency control and multi version concurrency control with practical SQL examples and implementation strategies
January 27, 2026
Deep Dive into InfluxDB - Storage Engine
Explore the internal architecture and working principles of InfluxDB storage engine including WAL TSM files Cache Compactor and data consistency mechanisms with detailed code examples and diagrams.
January 27, 2026
Deep Dive into InfluxDB - Write Operations
Explore the complete write operation process in InfluxDB from client requests to data persistence including HTTP handlers, shard mapping, WAL implementation and memory management strategies.
January 27, 2026
Distributed UUID Generation
Learn how to generate unique IDs using distributed systems with Twitter SnowFlake algorithm for short URL creation. This guide covers 64-bit ID generation with timestamp, data center, machine identifiers and sequence numbers, plus base-62 encoding for compact representation.
January 27, 2026
InfluxDB Deep Dive - From Index to Data Blocks
Explore how InfluxDB indexes data on disk and executes queries through cursors and iterators. Learn about LSM trees, memory-mapped files, and the query execution process from measurement selection to final result aggregation.
January 27, 2026
MySQL Database Architecture and Performance Optimization
Comprehensive guide to MySQL database architecture covering basic structure concurrency control transaction isolation levels storage engines indexing strategies and performance optimization techniques for database administrators and developers.
January 27, 2026
MySQL Technical Internals Reading Notes
Comprehensive notes on MySQL internal architecture covering storage engines, indexing, locking mechanisms, transactions, and backup strategies. Key topics include InnoDB engine architecture, B+ tree indexes, row-level locking, ACID properties, and checkpoint mechanisms for database performance optimization.
January 27, 2026
Protobuf
Protobuf is a data description language and compact binary message format designed for efficient data transmission and storage. This technical overview explains message length handling, type management, and the advantages of using Protobuf over JSON encoding for performance-critical applications.
January 27, 2026
Redis Data Structures and Persistence Mechanisms
Explore Redis data structures including string SDS implementation hash tables dictionary rehashing skip lists and compressed ziplists. Learn about expiration mechanisms and two key persistence methods RDB snapshots and AOF logging with performance optimization strategies for multiinstance deployments.
January 27, 2026