Tagged articles
106 articles
Page 2 of 2
Qunar Tech Salon
Qunar Tech Salon
Jan 17, 2016 · Backend Development

Design and Technical Challenges of High‑Concurrency Flash Sale (Seckill) Systems

This article analyzes the characteristics and technical challenges of flash‑sale (seckill) systems, proposes isolation and static‑page strategies, outlines architecture principles, detailed front‑end and service‑layer designs, discusses database sharding, caching, concurrency control, overload protection, and anti‑cheat measures to ensure reliable high‑throughput order processing.

Backend ArchitectureCachingOptimistic Lock
0 likes · 31 min read
Design and Technical Challenges of High‑Concurrency Flash Sale (Seckill) Systems
21CTO
21CTO
Jan 7, 2016 · Backend Development

How to Build a High‑Performance Flash‑Sale System: Architecture, Challenges & Solutions

This article analyzes the complete flash‑sale workflow, identifies its unique characteristics and high‑concurrency technical challenges, and presents a layered architecture—including frontend static pages, request interception, queue design, database sharding, caching, optimistic locking, and anti‑cheating measures—to ensure reliability, scalability and data safety.

Optimistic LockSystem Architecturedatabase sharding
0 likes · 34 min read
How to Build a High‑Performance Flash‑Sale System: Architecture, Challenges & Solutions
21CTO
21CTO
Sep 27, 2015 · Databases

Using Physical Primary Keys as Foreign Keys and Implementing Optimistic Locks

This article explains two key relational database design techniques: using auto‑increment or UUID physical primary keys for foreign key relationships, and employing optimistic locking with a version column to safely handle concurrent updates, while also covering when locks can be omitted.

Foreign KeyOptimistic LockSQL
0 likes · 6 min read
Using Physical Primary Keys as Foreign Keys and Implementing Optimistic Locks
21CTO
21CTO
Sep 23, 2015 · Backend Development

How to Tackle 50k QPS Flash Sales: Backend Strategies for Extreme Concurrency

This article explores the challenges of handling tens of thousands of requests per second in flash‑sale systems, covering interface design, QPS calculations, overload protection, anti‑cheat measures, and data‑safety techniques such as pessimistic, optimistic, and queue‑based locking.

Optimistic LockRedisbackend optimization
0 likes · 16 min read
How to Tackle 50k QPS Flash Sales: Backend Strategies for Extreme Concurrency
21CTO
21CTO
Sep 16, 2015 · Databases

Why Physical Primary Keys and Optimistic Locks Are Essential for Reliable DB Design

This article explains why using a physical primary key for foreign‑key relationships, how to implement optimistic locking with a version column for concurrent updates, and when it’s safe to update records without any locking, providing practical SQL examples for reliable database design.

Database DesignForeign KeyOptimistic Lock
0 likes · 6 min read
Why Physical Primary Keys and Optimistic Locks Are Essential for Reliable DB Design