I use the MS Sync Framework to sync my SQL Server instance with a local SQL CE file to make it possible working offline with my Windows app. I use GUIDs as keys. On my table I have a unique index on 2 columns: user_id and setting_id: Now I do the following: I create a new record in this table
Tag: synchronization
How to keep SQL data and Elasticsearch in-sync, and which to search from?
I’ve seen two solutions mentioned, and was wondering what most people do. Use logstash Code your application to make writes to Elasticsearch alongside SQL. For example, Another question is how to handle actually searching the entity? Do you ONLY use Elasticsearch? If not, I would assume you fetch from Elasticsearch based on keywords and use the IDs returned to filter