mufassall

Data & storage / 10 / 11

Transactions

A wallet app moves money between two accounts. What breaks without a transaction, what breaks even with one when two servers write at once, and which isolation level or lock fixes each case.

  • 14 min
  • Intermediate
  • 12 steps
Wrong balances
0 /day
Transfer p95
20 ms
Retries
0 /min
Open in Lab
  • request
  • reply
  • redelivery
  • duplicate
  • lost

Numbers are a model scenario, not measurements

The real request

API 1 → Database

Request

UPDATE accounts SET balance = balance - 50000
WHERE id = 'acc_42';1
UPDATE accounts SET balance = balance + 50000
WHERE id = 'acc_77';2

Response

UPDATE 13
UPDATE 1
  1. acc_42 — The sender. The first statement takes the money here.
  2. acc_77 — The receiver. The second statement adds the money here.
  3. UPDATE 1 — One row changed. Each statement is already saved for good the moment it returns.
Course: 42 lessons
  1. 01 Foundations

    1. The life of a request
    2. Latency and throughput
    3. Napkin math
  2. 02 Scaling

    1. Scaling up vs scaling out
    2. Load balancing
    3. Stateless servers
    4. Caching
    5. CDN and edge caching
  3. 03 Data & storage

    1. SQL and NoSQL
    2. Database indexes
    3. Storage engines: B-tree and LSM
    4. Database replication
    5. Sharding
    6. Consistent hashing
    7. Unique IDs
    8. CAP: when the link breaks
    9. Consensus and leader election
    10. Transactions
    11. File uploads
  4. 04 Communication

    1. API styles
    2. Message queues
    3. Pub/sub and event logs
    4. Real-time updates
    5. Reliable callbacks
  5. 05 Reliability

    1. Redundancy and failover
    2. Rate limiting
    3. Timeouts and retries
    4. Observability
  6. 06 Architecture

    1. Microservices
    2. Service discovery
    3. Sagas and the outbox
    4. Batch vs stream
  7. 07 Security

    1. Authentication
    2. Authorization
    3. Encryption and secrets
  8. 08 Shipping

    1. Testing
    2. CI/CD: from commit to production
  9. 09 Whole systems

    1. From requirements to design
    2. Design a URL shortener
    3. Design a news feed
    4. Design a chat
  10. 10 Business processes

    1. Payment gateway