database locking

Lobster Programming

Aug 2, 2024 · Backend Development

Ensuring Idempotent Consumption in MQ: Strategies and Code Examples

To prevent duplicate processing when integrating message queues for rate limiting and decoupling, this article explains idempotency concepts, common pitfalls, and five practical solutions—including query checks, pessimistic and optimistic locking, deduplication tables, and non‑transactional approaches—complete with code snippets and diagrams.

Backend DevelopmentDistributed SystemsIdempotency

0 likes · 11 min read

Ensuring Idempotent Consumption in MQ: Strategies and Code Examples

Selected Java Interview Questions

Oct 30, 2023 · Databases

Understanding SELECT ... FOR UPDATE Locks in MySQL

This article explains how MySQL's SELECT ... FOR UPDATE statement applies different lock types—row, table, or none—depending on whether the WHERE clause uses primary keys, unique indexes, regular indexes, range queries, non‑indexed fields, or returns no rows, illustrated with practical transaction examples.

MySQLRow LockSELECT FOR UPDATE

0 likes · 9 min read

Understanding SELECT ... FOR UPDATE Locks in MySQL

Architect

Jul 4, 2023 · Databases

Designing Concurrency‑Safe Balance Updates: SQL, CAS, Optimistic Lock, and Distributed Locks

The article examines multiple techniques—including direct SQL updates, compare‑and‑swap, optimistic locking, Redis‑based distributed locks, and MySQL shared locks—to ensure correct and consistent account balance modifications and order status changes in high‑concurrency scenarios.

SQLconcurrencydatabase locking

0 likes · 7 min read

Designing Concurrency‑Safe Balance Updates: SQL, CAS, Optimistic Lock, and Distributed Locks

Architect

Feb 24, 2022 · Backend Development

Design and Analysis of Flash‑Sale (秒杀) Systems: Scenarios, Technical Characteristics, Request Chain, and Lock Strategies

This article examines flash‑sale systems by outlining typical business scenarios, analyzing read‑heavy and high‑concurrency technical traits, detailing the end‑to‑end request flow, and comparing optimistic, retry‑optimistic, and pessimistic locking mechanisms with practical SQL examples and performance tables.

backend architecturedatabase lockingflash sale

0 likes · 9 min read

Design and Analysis of Flash‑Sale (秒杀) Systems: Scenarios, Technical Characteristics, Request Chain, and Lock Strategies

Architecture Digest

Oct 20, 2017 · Backend Development

Design and Implementation of a Flash Sale (SecKill) System with Concurrency Control

This article presents a complete design and implementation of a flash‑sale (SecKill) system, detailing entity models, DAO methods, service and controller layers, a high‑concurrency test, and an improved solution using row‑level locking to prevent overselling under heavy load.

JPAJavaSpring

0 likes · 8 min read

Design and Implementation of a Flash Sale (SecKill) System with Concurrency Control