Hello! I use MySQL as my primary datastore and use Elasticsearch to further index the documents. My problem is keeping the data in ES in sync with MySQL.
Currently I have two methods in mind: 1. whenever add or update an entry in MySQL, do the action together in ES. 2. Do some cron jobs that periodically keep ES in sync with the data in MySQL. For method 2 I wonder how can I check if an entry is already indexed in Elasticsearch. And would it be efficient at all if I have to check every entry to see if it is updated? I am new to the technology and I am afraid I had missed some really obvious and established solutions here. Or otherwise the "normal" way this situation is handled? -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/55d842e5-277f-4d24-b5a9-8be5b5544dbc%40googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
