I am planning to use Solr to power search on the site. Our db is mysql and we need to index some tables in the schema into Solr. Based on my initial research it appears that I need to write a java program that will create xml documents (say mydocs.xml) with add command and then use this command to index it in Solr java -jar post.jar mydocs.xml.
Kindly let me know if this is fine or some other sophiscticated solution exist for mysql synching. -- Manish