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
Dual-mode sync: bulk via Durable Functions, real-time via Service Bus
Checkpoint and retry logic for large-scale re-indexing
Field mapping transformations between source and search schemas
Index versioning for zero-downtime schema updates
Configurable sync strategies per entity type
Monitoring and alerting for sync lag and failures