Relation between SOLR and DB

[sanraj25 <sa...@gmail.com>]

Hi
       I want to know about any relation between SOLR and DB. Because we
want to use solr
and Innodb.If we change our table structure (Innodb or Mysam) any difference
is there.

and all data adding only solr db.Then why we worry about table structure in
database.I want some clear information.
So if i want to add more data,then memory in solr db only enough? or we need
to do any otherthing?

Thanks in advance


regards,
Santhanaraj R  
-- 
View this message in context: http://www.nabble.com/Relation-between-SOLR-and-DB-tp18632430p18632430.html
Sent from the Solr - User mailing list archive at Nabble.com.

Re: Relation between SOLR and DB

[Shalin Shekhar Mangar <sh...@gmail.com>]

On Thu, Jul 24, 2008 at 7:24 PM, sanraj25 <sa...@gmail.com> wrote:

>
> Hi
>       I want to know about any relation between SOLR and DB. Because we
> want to use solr
> and Innodb.If we change our table structure (Innodb or Mysam) any
> difference
> is there.
>
> and all data adding only solr db.Then why we worry about table structure in
> database.I want some clear information.
> So if i want to add more data,then memory in solr db only enough? or we
> need
> to do any otherthing?
>
> Thanks in advance
>
>
> regards,
> Santhanaraj R
> --
> View this message in context:
> http://www.nabble.com/Relation-between-SOLR-and-DB-tp18632430p18632430.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>
>
Firstly, Solr is not a database. It is a search server. Traditionally you
add data in the form of XML documents over an HTTP interface and search
through HTTP GET requests to get XML documents back. It is a war file which
you deploy in a application server such as Tomcat or Jetty. Therefore it
requires you to allocate enough memory (as per size of your data and search
needs)

Solr does not care about Innodb or MyISAM. Take a look at DataImportHandler
(http://wiki.apache.org/solr/DataImportHandler) to index data from DBs to
Solr.

-- 
Regards,
Shalin Shekhar Mangar.