~/talk

Reindexing in record time (...)

Talkat Berlin Buzzwords 2019 · 2019-06-16..06-18· [databases]
links:none on file
slides:none on file

Shopify moves mapping changes from MySQL into Elasticsearch by spawning coordinator jobs per pod that create worker jobs per shop, running up to 30,000–50,000 concurrent workers across pods to reindex 800,000 merchants into new index versions. Jobs emit denormalized documents into a System5 queue then into Kafka aggregate for cross‑region durability, with iteration API slices (120s) to avoid blocking Resque. Large shops get split later, current worst cases cause a small latency spike when swapping aliases during the reindex under 24 hours process.

AI-written summary · about

  1. 0:00Start
  2. 10:04Iteration Api
  3. 13:48Why We Use Kafka
  4. 15:38My Sequel Query Optimization
  5. 16:53Add Top Level Index Concurrency
~/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.