Transactions Motivation

Case Study: Taylor Swift Concert Sales on Ticketmaster

The Scale of the Problem

52
Show Dates
3.5M
Fans Pre-registered
2M
Tickets Sold
in a single day
3.5B
System Requests
in a few hours

What Went Wrong?

Concurrent Requests Broke the Site

  • Cancelled tickets, reset to later in the day
  • 5 hour wait times
  • Bots took over the system
  • Massive system failures under load

Why Study Taylor Swift Concert Sales?

Putting Scale in Perspective

Ticketmaster

3.5B

System requests in a few hours

4x their previous record

Peak transactions/second (TPS): Not reported

VISA Network

110M

Transactions/day average

100K transactions/second at peak

Global payment processing

Amazon Prime Day

105M

DynamoDB requests/second

Sub-10ms response times

288B total transactions/day

On Complexity

Taylor Swift Tickets

Same seats, millions want them

  • Limited inventory (same seats)
  • Extreme contention
  • Everyone wants exact same thing at same time
  • Concentrated time/geography
8/10
Complexity Level

VISA Network

Global payments, strict consistency

  • Financial regulations (zero tolerance)
  • Cross-border coordination
  • Real-time fraud detection
  • 24/7 uptime requirements
7/10
Complexity Level

Amazon Prime Day

Different products

  • Millions of unique items
  • Low contention per item
  • Distributed load naturally
  • Predictable scaling patterns
6/10
Complexity Level

Why Study This?

More fun than payment processing, and more challenging than e-commerce.


Why Study Transactions

The 100x Scale

Classic Era (1990s-2000s)

Banks, Walmart, Oracle

  • Key Problems: Nightly batch processing, Regional scale
  • Products: ATM networks, ERP systems
1,000s
Concurrent Users (per sec)

My Era (2000s-2020s)

Gmail, Facebook, Instagram, Roblox

  • Key Problems: Real-time updates, Global distribution
  • Products: Social networks, Cloud services, Online gaming
10M
Concurrent Users (per sec)

Your Era (2030s+)

AI Agents, Serverless, Agent Networks

  • Key Problems: Agent coordination, Serverless multi-tenant workloads
  • Products: Global agent networks, Extreme multi-tenant apps
Millions
Concurrent Agents (per sec)

Hardware Revolution

2000s Hardware

HDDs, Single cores, MB RAM

5ms
HDD Access
1-4
CPU Cores
1GB
Total RAM

Limited what you could build

2020s Hardware

SSDs, Many cores, TB RAM

0.1ms
SSD Access
128+
CPU/GPU Cores
1TB
Total RAM

Enables anything my gen imagined!

2030s Hardware

Cloud-Native, AI Accelerators, CXL Memory

0.01ms
NVMe/CXL Access
10K+
GPU/AI Cores
1PB
Distributed Memory

Enables new architectures!

Data Structure Evolution Unlocks Scale

2000s: B-Trees

Oracle, DB2, SQL Server

  • Key Problems: Disk-optimized reads, ACID guarantees
  • Trade-offs: Slow writes, complex updates
10K
Writes/sec

2020s: LSM Trees

Spanner, DynamoDB, RocksDB, Cassandra

  • Key Problems: Write amplification, SSD optimization
  • Trade-offs: Fast writes, eventual consistency
1M+
Writes/sec

2030s: Learned Indexes

AI-Native DBs, Vector databases, Learned structures

  • Key Problems: Hardware-accelerated data structures, High-dimensional search
  • Trade-offs: Training overhead vs index size
??
Writes/sec

You're Building the Future

You're entering the field at the perfect time!

Transaction processing is where the innovation and investment is heading. Master this now, lead the future.

Instant
No waiting, ever
Global
Every human, every device, every agent
Bulletproof
Never fails, never loses data

‍♂ Extreme Concurrency

Handling massive, unpredictable traffic spikes gracefully

Perfect Consistency

Zero conflicts, zero data loss, zero compromises

Instant Recovery

Self-healing systems that minimize downtime

Global Distribution

Geographically dispersed multi-region systems


What We'll Learn

Real-World Transaction Challenges

1⃣ Concurrency

Millions of users trying to buy the same ticket

2⃣ Consistency

Ensuring no double-bookings or lost sales

3⃣ Availability

Keeping the system running under extreme load

4⃣ Scalability

Handling 100x normal traffic spikes

Technical Deep Dive

ACID Properties - The formal guarantees every system needs
Isolation Levels - Trading consistency for performance
Concurrency Control - Locks, timestamps, and conflict resolution
Recovery - Getting back online after failures
Distributed Transactions - Coordinating across multiple systems