Search Index Sync Engine

Real-time & bulk search indexing

Built a dual-mode search synchronization engine that keeps Azure Cognitive Search indices in sync with the primary database. Bulk mode uses Durable Functions to orchestrate full re-indexing of large datasets with retry and checkpoint logic. Real-time mode uses Service Bus to process incremental changes within seconds of the source update. The system handles schema evolution, field mapping transformations, and index versioning.

Real-time

incremental sync

Bulk

full re-indexing

Dual

sync modes

Auto

schema evolution

Architecture & Implementation

How it's built

01

Dual-mode sync: bulk via Durable Functions, real-time via Service Bus

02

Checkpoint and retry logic for large-scale re-indexing

03

Field mapping transformations between source and search schemas

04

Index versioning for zero-downtime schema updates

05

Configurable sync strategies per entity type

06

Monitoring and alerting for sync lag and failures