xiaofucode.com – a programmer learning guide driven by the pursuit of profit
When a core MySQL order table reaches tens of millions of rows, adding a new column can lock the table and disrupt services, so the article walks through master‑slave switching, online DDL tools, log‑based workarounds, extension tables, JSON fields, and a final redundant‑field trick to achieve the change safely.
This article explains the Chain of Responsibility pattern, shows how to use it for multi‑stage validation and workflow scenarios, walks through a product‑creation example with concrete handlers, configuration via JSON, Spring bean injection, recursive chain assembly, and a reimbursement‑approval workflow, complete with runnable test cases.
The article compares token bucket and leaky bucket rate‑limiting algorithms, explains their core principles, advantages, and suitable scenarios, and provides complete Java implementations with test code and interview tips for choosing the right approach.
This article presents a comprehensive, step‑by‑step analysis of a high‑throughput, asynchronous OCR pipeline built with Spring Boot and Tesseract, covering system architecture, thread‑pool tuning, custom invoice‑specific model training, multi‑engine fusion, structured data extraction, performance optimizations, GPU acceleration, Kubernetes deployment, monitoring, security compliance, chaos testing, and future evolution plans.
This article walks through building a distributed image captcha login for Spring Boot applications, contrasting traditional session‑based approaches with a front‑end/back‑end separated design that stores captcha codes in Redis, generates images via Kaptcha, and returns tokens to the client.
The article examines the challenges of achieving distributed consistency when a business operation writes to MySQL and external systems, analyzes failure scenarios, and presents a step‑by‑step solution that splits the large transaction into small, retryable tasks with Spring afterCommit optimization.
The article explains the concepts of cache penetration, avalanche, and breakdown, outlines their typical causes such as invalid requests, synchronized expirations, and hotspot spikes, and presents practical mitigation techniques including request validation, caching null values, Bloom filters, staggered expirations, high‑availability Redis setups, mutex locks, and random TTLs.
The article analyzes the repetitive maintenance of common fields like createTime and updateUser in SpringBoot CRUD services, presents six production‑tested strategies—including MyBatis‑Plus meta‑object handling, AOP with custom annotations, multi‑data‑source adaptation, distributed ID generation, caching, batch optimization, and audit logging—detailing implementations, pitfalls, and best‑practice recommendations that can cut code by 90% and boost development efficiency.
This article explains how to implement a plug‑and‑play development model in Spring Boot using Java SPI, custom configuration, and Spring Factories, providing step‑by‑step code examples, a multi‑module microservice case study, and practical guidance for creating extensible, decoupled applications.
This article walks through the challenges of synchronizing 50 million rows between disparate MySQL databases, explains why traditional mysqldump or file‑based methods fail, and then details how the open‑source DataX tool—its 3.0 framework, installation steps, job architecture, and JSON‑based configurations—enables fast full and incremental data transfers with concrete performance metrics.
