---
answer: direct
beat: system-design
source: 1 article · updated: November 14, 2026
---

What is the difference between a shared and an exclusive lock?

A shared lock lets many transactions read a resource at once but blocks writers. An exclusive lock lets one transaction read and modify it and blocks every other lock, shared or exclusive. Readers coexist with readers, but a writer needs the resource to itself.

Answered in

Database Locks Explained: Shared, Exclusive, Update, Key-Range and Granularity

What each lock mode allows, why update locks exist, how key-range locks stop phantoms, and when row, page or table locks cost you concurrency.

Crashtech Editorial November 14, 2026 System Design & Architecture

Read the full analysis

Other questions this article answers

More system design & architecture questions

Every answer on Crashtech is written by the editor of the article it comes from — never auto-summarised. Browse all answers or the System Design & Architecture beat.