This article walks through a complete e‑commerce request path, illustrating how an API gateway, load balancer, service registry, Redis cache, Kafka queue and the database cooperate, and explains where CAP/BASE, distributed transaction patterns and service‑governance mechanisms fit in the overall diagram.
This article details how a photo‑contest backend migrated from MySQL to Elasticsearch and, through three iterative optimizations—segment pre‑warming, recent‑anchor positioning with Redis ZSet, and a large‑region‑plus‑small‑page cache—reduced arbitrary deep‑page response time on 500 k records from ten minutes to under one second.
Easy‑Trans is a SpringBoot starter that eliminates repetitive ID‑to‑name, dictionary code‑to‑text, and cross‑service field translation code by using a single @Trans annotation, offering five translation modes, Maven integration, YAML configuration, and optional Redis caching to boost performance and reduce boilerplate.
This article explains how to efficiently verify whether a user nickname is already registered on high‑traffic websites by combining Bloom filters with Redis caching, reducing database load and improving concurrency handling.
This article explores strategies for efficiently verifying username uniqueness at massive scale, comparing direct database queries, Redis caching, and memory‑efficient Bloom filter techniques, complete with Java code examples and analysis of performance, load, scalability, and memory trade‑offs.
This article explains why MySQL count(*) can become a performance bottleneck on InnoDB tables, compares different count() variants, and presents practical optimization techniques such as Redis caching, second‑level caches, parallel execution, reducing joins, and offloading analytics to ClickHouse.
