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.

System Architecturedatabase shardingflash sale

0 likes · 34 min read

Architect

Nov 2, 2015 · Backend Development

Handling Overselling in High‑Concurrency Scenarios: Pessimistic, FIFO, and Optimistic Lock Strategies

The article explains why overselling occurs in flash‑sale systems under high concurrency, analyzes the drawbacks of pessimistic locking and FIFO queues, and presents optimistic locking with version control as a more efficient solution for ensuring thread‑safe inventory updates.

BackendFIFO queueoptimistic lock

0 likes · 5 min read

Handling Overselling in High‑Concurrency Scenarios: Pessimistic, FIFO, and Optimistic Lock Strategies

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 Keydatabasesoptimistic lock

0 likes · 6 min read

Using Physical Primary Keys as Foreign Keys and Implementing Optimistic Locks

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.

backend optimizationflash salehigh concurrency

0 likes · 16 min read

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

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