Dedicated to sharing programmer-architect skills—Java backend, system, microservice, and distributed architectures—to help you become a senior architect.
This article explains why a naïve full‑table UPDATE on massive MySQL tables can cripple replication, explores deep‑pagination and IN‑clause inefficiencies, and presents a batch‑processing strategy using NO_CACHE, FORCE INDEX, and rate‑controlled scripts to perform safe, high‑performance updates.
This article systematically introduces ten widely used authentication methods—including HTTP Basic Auth, Session‑Cookie, Token, JWT, Single Sign‑On, OAuth 2.0, federated login, unique‑device login, QR‑code login, and one‑click mobile login—explaining their principles, workflows, advantages, drawbacks, and typical implementation libraries.
This comprehensive guide walks you through Git fundamentals, core concepts, installation, configuration, common commands, branching, merging, rebasing, tagging, remote repository handling, GUI tools, undoing changes, stash, and cherry‑pick techniques, providing clear examples and code snippets for effective version control.
When a MySQL table's auto‑increment primary key approaches its maximum value, you can avoid failures by converting the column to BIGINT, switching to UUIDs, using segmented ID generators, composite keys, adjusting the increment step, or applying database sharding.
This guide explains how to use Spring Boot 2.3's layered image feature and Dockerfile optimizations to reduce image size, avoid duplicate layers, and accelerate pushes by only updating changed layers, with detailed commands and analysis.
The article traces the evolution from monolithic Java apps to RPC services, explains why sharding and database partitioning cannot alone achieve limitless scaling due to connection limits, and introduces unitization—assigning each application to a specific database shard—to overcome the bottleneck.
This article introduces JetCache, an open‑source distributed cache built on Spring and Redis, explains its core features and typical use cases, details the main API and annotation support, and provides a step‑by‑step SpringBoot integration guide with full code examples.
This article explains how to handle massive Excel import/export tasks in Java by comparing POI workbook implementations, selecting the appropriate class based on data size, and using EasyExcel with batch processing, JDBC transactions, and pagination to achieve fast, low‑memory operations for hundreds of millions of rows.
This article examines three practical approaches—microservice isolation, Redis‑based whitelist, and gateway‑plus‑AOP—to prevent external exposure of internal APIs, compares their trade‑offs, and provides a complete SpringBoot implementation of the gateway‑AOP solution with code samples.
This article explains the Linux kernel limits that determine how many files and TCP connections a server can handle, shows how to adjust fs.file-max, soft/hard nofile and fs.nr_open parameters, calculates realistic connection counts based on memory, and discusses client‑side port constraints and practical scaling scenarios.
