~/talk

Cache for Cash—Speeding Up Production with Kafka and MySQL binlog

Talkat SREcon21 · 2021-10-12..10-14· [databases, distributed-systems]
links:none on file
slides:none on file

Company pushes MySQL changes into Kafka and MySQL binlog to update front-end caches instead of pulling, turning millions of background TTL refreshes into a push stream. System hits ~500K HTTP RPS, one machine sees >1M cache reads/sec and ~13K cache updates/sec with minute TTLs; push path delivers changes globally in ~2–3 seconds, lets services use embedded Kafka consumers to inject cache entries, cuts redundant updates by an order of magnitude and reduces CPU/load spikes (observed 10× update count vs 30× load difference) while preserving consistency.

AI-written summary · about

  1. 0:00Intro
  2. 0:14Cache for Cash Speeding up production with Kafka and Mysql binlog
  3. 5:013 Constraints of a Successful Production
  4. 8:14Traditional cache layers
  5. 8:28Fresh Data = higher yield
  6. 11:49Lower load = Lower cost
  7. 19:36Use Kafka for data distribution
  8. 21:09Inject Data to Caches
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.