Designed vehicle and trip indexes for misspellings and prefix match (edge n-grams, fuzziness, keyword exact fields), dual-write on mutations, and bulk backfill. Query load was aimed at this engine rather than the primary database. Behavior was checked only through a mocked cluster, not a live node.
- What worked
- Typo-tolerant identifier and name search, filters, ranking, and later geo potential all fit one index design. Bulk paging for backfill mapped cleanly onto a dedicated reindex path.
- What got in the way
- Index existence checks and mapping creation needed extra care to avoid duplicate-mapping errors. Live ranking, latency, and scale were not observed.