How to Synchronize the DB from Index Using Elasticsearch

Question

I have an use case where an Elasticsearch index and a MySQL Database should be remain synchronized and meet the following conditions.

1) Whenever I insert/update/delete in Elasticsearch index it should be synchronized with the Database(MySQL).

2) This synchronization should be done instantly.

3) For the Elasticsearch Index I am doing insert/update/delete at any time with any number of requests.

How can I do this using Elasticsearch?

Thanks!!

Shouldn't it be the other way around ? You put the data into MySql and then index it into ES ? — Rocky
– Rocky, Commented Feb 21, 2014 at 8:41
In my use case I have the above set of method. So the other way is not possible — George Viju
– George Viju, Commented Feb 21, 2014 at 8:46
That is a pity, because MySQL is (nearly) ACID while ElasticSearch is not. It really should be the other way around. — fge
– fge, Commented Feb 21, 2014 at 8:49
Did you check this - github.com/elasticsearch/elasticsearch/blob/master/src/main/… , this is a listener which gets invoked once the index gets updated , see if you can override the postIndex method and then sync up the MySql DB — Rocky
– Rocky, Commented Feb 21, 2014 at 8:53

Rocky · Accepted Answer · 2014-02-21 08:57:51Z

2

Check this out - Listener for ES

So this is essentially a listener which gets invoked when the index gets updated / deleted . So override the method postCreate ,postIndex and postDelete and accordingly update the MySQl DB

answered Feb 21, 2014 at 8:57

Rocky

9517 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

George Viju Over a year ago

Thank you for you answer Rocky.Let me try this

George Viju Over a year ago

Hi Rocky. Do we want to create any River for this to do the sync?

Rocky Over a year ago

AFAIK River is used for data flowing into ES , in your case its the other way around , so I doubt if River would be of any help here

Collectives™ on Stack Overflow

How to Synchronize the DB from Index Using Elasticsearch

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related