This article explains multiple database schema designs for hierarchical comment threads, compares their query performance, and shows how Redis can be used to sort hot comments and handle high‑concurrency likes, providing practical solutions for large‑scale comment systems.
Bilibili’s ticketing platform evolved from a single‑transaction, synchronous design to an asynchronous batch system and finally to a Redis‑cached inventory layer, adding DB isolation changes, sharding, bloom‑filter protection and adaptive rate limiting, which together enabled handling up to 930 k requests per second and stable high‑concurrency ticket sales.
This article explains how ZuanZuan designs and implements a high‑performance delivery‑promise (fulfilment timing) system, covering the definition of delivery promise, the order‑OMS‑WMS‑TMS workflow, estimated‑arrival calculations, high‑QPS handling with caching and Redis, and the logic behind next‑day and same‑day delivery filters.
The article proposes a high‑performance, strictly incremental distributed ID generation scheme that combines MySQL segment tables, Redis caching, and Nacos‑controlled switching, achieving sub‑millisecond latency and 7‑10× speedup over pure database methods while preserving fault tolerance, availability, and global uniqueness.
This article details a comprehensive performance‑testing case study of an inventory‑reservation system, describing the test scenarios, bottleneck analysis, Redis‑based cache redesign, re‑testing results, cache‑preheat strategies, invalid‑call reduction, and operational best practices that together increased TPS by over twenty‑three‑fold while keeping latency under 500 ms.
JD-hotkey is a high‑performance backend framework that detects billions of hot keys daily, captures crawlers and hot items, and pushes them to service memory within milliseconds, dramatically reducing data‑layer load and boosting application performance.
The Promotion Platform 2.0 upgrade replaces the fragmented 1.0 system with a unified promotion model, low‑code DSL‑driven workflow, and QLExpress rule engine, enabling rapid creation of diverse promotional tools, consistent pricing calculations, and high‑performance caching while preserving stability for the ACG e‑commerce ecosystem.
The article explains 58.com’s service‑oriented architecture that combines dual‑master MySQL replication, a standby database, and Redis caching to provide high‑availability read/write operations, outlines their scaling process, and details a four‑step cache‑consistency strategy.
