BestHub
Sign in
Tagged articles

optimistic lock

114 articles · Page 2 of 2
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Aug 17, 2017 · Backend Development

Mastering High-Concurrency Flash Sale Systems: Architecture, Challenges, and Solutions

This article dissects the technical challenges of building a high‑concurrency flash‑sale (seckill) system—covering business analysis, traffic isolation, static page caching, CDN bandwidth, dynamic order URLs, request throttling, database sharding, optimistic locking, and anti‑cheat mechanisms—while presenting concrete architectural principles and code examples.

High concurrencySeckilldistributed systems
0 likes · 36 min read
Mastering High-Concurrency Flash Sale Systems: Architecture, Challenges, and Solutions
Qunar Tech Salon
Qunar Tech Salon
Jul 25, 2017 · Databases

Schemaless Document Model for Trading System Order Storage

The article explains how a schemaless JSON document model stored in a relational database can replace traditional relational tables for trading system orders, reducing schema change costs, improving flexibility, and ensuring consistency through version‑based optimistic locking and real‑time Elasticsearch indexing.

Database DesignDocument ModelElasticsearch
0 likes · 8 min read
Schemaless Document Model for Trading System Order Storage
Baidu Waimai Technology Team
Baidu Waimai Technology Team
Jul 11, 2017 · Backend Development

Handling Hotspot Accounts in Baidu Waimai Financial Accounting System: Challenges and Solutions

The article examines the upgrade to a balance‑based financial accounting system, defines hotspot accounts, explains why they pose concurrency challenges, and evaluates several technical solutions—including optimistic locking, asynchronous processing, and account splitting—to guide appropriate strategy selection for different business scenarios.

account splittingasynchronous processingbackend
0 likes · 9 min read
Handling Hotspot Accounts in Baidu Waimai Financial Accounting System: Challenges and Solutions
Architecture Digest
Architecture Digest
Jun 14, 2017 · Backend Development

Techniques for Achieving High Concurrency: Optimistic Lock, Read‑Write Splitting, CDN, Caching, and Load Balancing

The article explains how high‑concurrency systems can be built by decomposing workloads through optimistic locking, read‑write database splitting, resource separation with CDN acceleration, dynamic‑to‑static conversion, caching, and load‑balancing strategies, providing practical code examples for each technique.

CDNCachingHigh concurrency
0 likes · 6 min read
Techniques for Achieving High Concurrency: Optimistic Lock, Read‑Write Splitting, CDN, Caching, and Load Balancing
Efficient Ops
Efficient Ops
Mar 5, 2017 · Operations

Surviving Hundred‑Billion Transactions: Real Production Incident Stories

This article recounts a series of real‑world production incidents—including massive concurrency overloads, DDoS attacks, SQL injection breaches, and critical bugs—encountered by an internet finance platform, and shares the concrete technical fixes and lessons learned to improve system resilience.

DDoSHigh concurrencySQL Injection
0 likes · 22 min read
Surviving Hundred‑Billion Transactions: Real Production Incident Stories
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Dec 11, 2016 · Backend Development

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

This article analyzes the flash‑sale (seckill) business model, outlines its unique technical challenges such as impact on existing services, database load, bandwidth spikes, URL security, button activation, and order handling, and then presents a comprehensive backend architecture, design principles, code examples, database sharding, caching, and consistency strategies to reliably support massive concurrent purchases.

CachingFlash SaleHigh concurrency
0 likes · 32 min read
How to Build a High‑Concurrency Flash Sale System: Architecture, Challenges & Solutions
ITPUB
ITPUB
Oct 26, 2016 · Databases

Mastering Oracle Locks: Pessimistic, Optimistic, and Deadlock with Real‑World SQL demos

This guide explains Oracle's lock mechanisms—including shared, exclusive, row‑level, pessimistic, and optimistic locks—through step‑by‑step SQL sessions that illustrate update‑lost problems, lock contention, and deadlock detection, helping developers choose the right strategy for concurrency control.

OracleSQLoptimistic lock
0 likes · 10 min read
Mastering Oracle Locks: Pessimistic, Optimistic, and Deadlock with Real‑World SQL demos
Java Backend Technology
Java Backend Technology
Oct 25, 2016 · Databases

Why Locks Matter: Pessimistic vs Optimistic Concurrency Control Explained

This article explains why locks are needed in multi‑user environments, describes common conflict types such as lost updates and dirty reads, compares pessimistic and optimistic locking mechanisms, shows practical implementations with version numbers and SQL Server locks, and presents a classic financial‑system case study.

Transactionoptimistic lockpessimistic lock
0 likes · 8 min read
Why Locks Matter: Pessimistic vs Optimistic Concurrency Control Explained
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.

CachingFlash SaleHigh concurrency
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.

Flash SaleHigh concurrencydatabase 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.

DatabasesForeign KeyPrimary Key
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.

Flash SaleHigh concurrencyRedis
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 KeyPrimary Key
0 likes · 6 min read
Why Physical Primary Keys and Optimistic Locks Are Essential for Reliable DB Design