Dedicated to sharing programmer-architect skills—Java backend, system, microservice, and distributed architectures—to help you become a senior architect.
This article examines Cloudflare's decision to abandon Nginx for its home‑grown Pingora proxy, detailing the architectural limits of Nginx, the design choices behind Pingora, performance gains, added features, and the broader implications for large‑scale HTTP traffic handling.
This article explains how MySQL handles auto‑increment primary keys, InnoDB internal row_id, Xid, trx_id, and thread_id when their numeric limits are reached, illustrating the resulting errors, data overwrites, and potential consistency bugs with practical SQL examples and verification steps.
The article explains that 7‑Zip is an open‑source compression program released under GNU LGPL (with AES under BSD and unRAR under dual licenses), highlights its key features, compares its compression ratios to WinRAR using Firefox and Google Earth files, and provides the GitHub repository link.
This step‑by‑step guide shows how to install the GeoIP2 library, compile NGINX 1.18 with the ngx_http_geoip2 module, download the latest MaxMind GeoLite2 database, configure geoip2 directives, and verify that foreign IP requests are blocked with a 404 response.
This article examines why distributed systems need globally unique, trend‑increasing IDs, outlines strict generation requirements and availability goals, compares common approaches such as UUID, database auto‑increment, Redis, and the Snowflake algorithm, and provides practical implementation details and trade‑offs.
This article breaks down Spring's bean lifecycle, explaining the minimal creation steps, the role of BeanFactoryPostProcessor and BeanPostProcessor, how Spring resolves bean references, handles circular dependencies with three‑level caches, and clarifies common misconceptions about proxy generation.
This article explains how to assess MySQL table size using table capacity, disk usage, and instance limits, reveals why large tables slow down due to B+‑tree overhead, and presents three practical solutions—partitioning, sharding, and hot‑cold archiving—to restore query performance.
This article experimentally compares MySQL JOIN and IN (separate queries) across small, medium, and large data sets, providing PHP benchmark code, performance results, and practical conclusions on when each approach is more efficient.
This guide explains how to integrate asyncTool into a Spring Boot project, configure custom thread pools, understand core interfaces like IWorker and ICallback, and implement serial, parallel, and mixed task flows with detailed code examples and best‑practice considerations.
This guide explains how to replace static custom‑annotation permission checks in Spring Boot with flexible SpEL expressions, covering annotation design, aspect definition, expression parsing, context setup, and practical usage examples for various access scenarios.
