How Solr Manages Connected Database Updates

[Sumit Arora <su...@gmail.com>]

Hey All,

I am new to Solr Area, and just started exploring it and done basic stuff,
now I am stuck with logic :

How Solr Manages Connected Database Updates

Scenario :

-- Wrote one Indexing Program which runs on Tomcat , and by running this
program, it reads  data from connected MySql Database and then perform
Indexing.

Use Case - Database is not fixed, Its a data base for a web application,
from where user keep on inserting data, so database have frequent updates.
almost every minute.

How automatically solr should grab those changes and perform Index updation
?


Do I need to Write a Cron Job kind of stuff ? Or Use Data Import Handler ?
(Several ways could be ?)

Is there any one who can provide his comments or share his experience If
some one gone though from similar situation ?

Thanks,
-Sumit

Re: How Solr Manages Connected Database Updates

[Lance Norskog <go...@gmail.com>]

The DataImportHandler has a tool for fetching recent updates in the
database and indexing only those new&changed records.  It has no
scheduler. You would set up the DIH configuration and then write a
cron job to run it at regular intervals.

Lance

On Wed, Jun 9, 2010 at 7:51 AM, Sumit Arora <su...@gmail.com> wrote:
> Hey All,
>
> I am new to Solr Area, and just started exploring it and done basic stuff,
> now I am stuck with logic :
>
> How Solr Manages Connected Database Updates
>
> Scenario :
>
> -- Wrote one Indexing Program which runs on Tomcat , and by running this
> program, it reads  data from connected MySql Database and then perform
> Indexing.
>
> Use Case - Database is not fixed, Its a data base for a web application,
> from where user keep on inserting data, so database have frequent updates.
> almost every minute.
>
> How automatically solr should grab those changes and perform Index updation
> ?
>
>
> Do I need to Write a Cron Job kind of stuff ? Or Use Data Import Handler ?
> (Several ways could be ?)
>
> Is there any one who can provide his comments or share his experience If
> some one gone though from similar situation ?
>
> Thanks,
> -Sumit
>



-- 
Lance Norskog
goksron@gmail.com