~/talk

How to lose 50 Million Records in 5 minutes

Talkat RubyConf 2019 · 2019-11-18..11-20· [databases]
name:Jon Druse
links:none on file
slides:none on file

A production ETL called FORGE stores roughly 60 million records in Elasticsearch but two config worlds (YAML vs dynamic mappings) let timestamp-like JSON field names proliferate under Elasticsearch’s dynamic mapping, bloating cluster state. An attempted ES upgrade and earlier manual index deletions triggers recreation with exploding schemas and the loss of about 50 million records; recovery happens by restoring backups and rebuilding FORGE 2.0 with local raw storage and reindex tools.

AI-written summary · about

  1. 0:00Intro
  2. 1:38Real Estate
  3. 5:27extraction
  4. 6:45transformation
  5. 11:08status quo
  6. 12:19path to ruin
  7. 19:47how to handle catastrophe
  8. 21:02how to avoid catastrophe
  9. 22:53FORGE
  10. 24:37final thoughts
~/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.