You can use JDBC river plugin to fetch from database directly. https://github.com/jprante/elasticsearch-river-jdbc
On Monday, February 10, 2014 8:40:31 PM UTC+11, Vallabh Bothre wrote: > > Dear All, > > I am using elasticsearch in some of the my API. > I have created the index and document and have added data in elasticsearch > server from Mysql database. > > I am following 3 steps that is, > 1. Delete the index using > curl -X DELETE 'http://localhost:9200/adminvenue/?pretty=true' > > 2. Create the index using > curl -X PUT 'http://localhost:9200/adminvenue/?pretty=true' -d ' > {....... > > 3. Create the mapping using > curl -X PUT ' > http://localhost:9200/adminvenue/jos_content/_mapping?pretty=true' -d ' > {...... > > > I have set the cron which runs every half an hour. > Cron consist of 2 files named .sh file which is for > creating/deleting/mapping indexes and .php which is use for adding data > from mysql to elasticsearch. > > My mysql data is continuously updating that is some data get removed some > modified and some added because of this i have run cron for 1/2 hour. > > My concerns is that i have to first delete the indexes and then create the > indexes in every 1/2 hour. > Is there any way to update the indexes that is i just wanted to update the > data in elasticsearch which is added, deleted and modified in mysql ? > > Any suggestion is very much appreciated. > > Thanks, > Vallabh > > -- 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/05415e13-f76c-420e-bac8-15a754230296%40googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
