Seasoned Java and mobile developer with years of experience, specializing in mini‑programs, public accounts, and full‑stack front‑end development. In the AI era, I continuously learn to broaden my knowledge and evolve. I revived a public account I started a decade ago during a dessert‑startup venture, using code as a vessel and knowledge as a companion. I share personal projects, technical articles, programming tips, and growth insights—let’s improve together and set sail.
The article explains why Redis must be highly available and walks through three progressive architectures—master‑slave replication, Sentinel automatic failover, and Redis Cluster—detailing their mechanisms, advantages, drawbacks, and when to choose each for small, medium, or large‑scale production systems.
This article breaks down MySQL’s locking mechanisms—table, row, and gap locks—explaining their principles, performance trade‑offs, when they are triggered, how they relate to index usage, and provides practical deadlock avoidance techniques and a concise cheat‑sheet for common concurrency problems.
This article explains why database transactions are a core backend skill, breaks down the four ACID properties, clarifies dirty read, non‑repeatable read and phantom read, compares the four isolation levels, and offers practical guidelines for choosing the right level in production.
This guide walks through the new MCP 2026 update—showing how to build a stateless FastAPI server and a TypeScript client, run curl calls, and highlights benefits such as session‑free requests, cacheable tool lists, easy load‑balancing, and optional OAuth2 protection.
The article clarifies the often‑confused concepts of synchronous, asynchronous, blocking, and non‑blocking operations by introducing two independent dimensions, illustrating each with real‑world analogies, mapping them to BIO/NIO/AIO models, and offering practical guidance for choosing the right approach in different scenarios.
The article explains the fundamental purpose of caching—placing frequently accessed data in faster storage—to dramatically reduce database load, compares local memory caches with distributed solutions like Redis, outlines their pros, cons, suitable scenarios, and presents a two‑level cache pattern plus common pitfalls such as cache penetration, breakdown, and avalanche.
This article breaks down the four core concepts of blocking vs non‑blocking and synchronous vs asynchronous, explains BIO, NIO, and AIO with everyday analogies, lists each model's mechanisms, pros and cons, and provides a concise cheat‑sheet for interview preparation.
The article explains what SQL Server 2012 stored procedures are, outlines their core advantages, provides a reusable syntax template, walks through three practical examples (no‑parameter, parameterized, and default‑parameter procedures), and covers how to alter, drop, appropriate use cases, and common beginner mistakes.
This article demystifies processes and threads with everyday analogies, outlines their core differences, explains why multithreading speeds up programs, and highlights common pitfalls such as thread‑safety issues, excessive threads, and crashes, providing interview‑ready knowledge for developers.
The article explains why network speed can be inconsistent by breaking down TCP's two core mechanisms—sliding window for flow control and congestion control for traffic management—using simple scenarios, step‑by‑step workflows, and interview‑ready summaries.
