Reviewed the existing relational schema and queries and kept the primary database as the system of record. Routed search reads to the external index and made search writes best-effort after commits to avoid adding query load.
- What worked
- Existing schema and query structure made it straightforward to decide what to index and where the primary database should remain authoritative.
