Can anybody suggest me of what is the best method to implement auto index
update on SOLR from mysql database.
As Hoss noted, there are a lot of different approaches.
You could search this email list archive for the discussion re using
Solr with Compass (subject "Does Solr support integration with the
Compass framework?").
Also Jira issue SOLR-20 talks about the steps Ryan is talking towards
providing a Compass-like mechanism for keeping a Solr index in sync
with a DB, via a HibernateEventListener.
-- Ken
--
Ken Krugler
Krugle, Inc.
+1 530-210-6378
"Find Code, Find Answers"