How to index data in solr from database automatically?

I don't think there is a possibility in Solr which lets you index the data when any updates happens to DB But there could be possibilities like, with the help of Triggers there is a possibility to run an external application from triggers Write a CRON to trigger PHP script which does reading from the DB and indexing it in Solr Write a trigger (which calls this script) for CRUD operation and dump it into DB, so, whenever something happens to DB, this trigger will call the above script and indexing could happen Please see: Invoking a PHP script from a mysql trigger Automatic Scheduling: Please see this post How can I Schedule data imports in Solr for more information on scheduling. The second answer, explains how to import using Cron.

I don't think there is a possibility in Solr which lets you index the data when any updates happens to DB. But there could be possibilities like, with the help of Triggers - there is a possibility to run an external application from triggers. Write a CRON to trigger PHP script which does reading from the DB and indexing it in Solr.

Write a trigger (which calls this script) for CRUD operation and dump it into DB, so, whenever something happens to DB, this trigger will call the above script and indexing could happen. Please see: Invoking a PHP script from a mysql trigger Automatic Scheduling: Please see this post How can I Schedule data imports in Solr for more information on scheduling. The second answer, explains how to import using Cron.

Rakesh: How to write CRON to trigger a script which reads data from database and index its into solr – Romi Jun 27 at 6:39 @Romi please see the updated answer. – RakeshS Jun 27 at 7:51.

Since you used a DataImportHandler to initially load your data into Solr... You could create a Delta Import Handler that is executed using curl from a cron job to periodically add changes in the database to the index. Also, if you need more real time updates, as @Rakesh suggested, you could use a trigger in your database and have that kick off the curl call to the Delta DIH.

– Romi Jun 27 at 6:19 @Romi, if you look at the example in the link I provided, it talks about creating a delta query that can detect changes in your database via a lassttimestamp column (or something similar) in the database. Also, you can see this example of using a full DIH as a delta - wiki.apache.Org/solr/DataImportHandlerFaq#fullimportdelta Once you have this working, you can execute it via an http call using curl and schedule that curl call via cron. Hope this helps.

– Paige Cook Jun 28 at 14:04 in windows environment I need to execute this url:localhost:8983/solr/db/dataimport? Command=full-import, how can I do this using curl or any other command in windows – Romi Jun 30 at 11:28 You should go to the home page for Curl - curl.haxx. Se and check out the FAQ page.

That should point you in the right direction. – Paige Cook Jul 5 at 11:41.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.