Using Solr with MySQL

mysql solr faceted-search
RS71 picture RS71 · Jan 5, 2011 · Viewed 8k times · Source

I was browsing some questions here concerning MySQL and faceted searches and I saw one response that suggested the use of Solr.

In my MySQL database, I have many tables for products, suppliers, messages, users, etc - all interconnected. How would I use Solr to do faceted searches for products? From what I understand, I'd have to keep feeding Solr product data from MySQL - but how do I deal with indexing the data? Do index right after adding a new product? Do I batch index? How do I deal with Solr accurately representing data that is found in my MySQL database? (inserts, deletes, etc)

Thanks in advance.

Answer

jarekrozanski picture jarekrozanski · Jan 5, 2011

Take a look at data import handler. Apart from batch update you can also trigger update by calling update request handler. You would have to call it from your application but you can also create your own custom update request handler that would fit your needs.

Related questions

Choosing a stand-alone full-text search server: Sphinx or SOLR?

I'm looking for a stand-alone full-text search server with the following properties: Must operate as a stand-alone server that can serve search requests from multiple clients Must be able to do "bulk indexing" by indexing the result of an SQL …

Read More
my nodejs script is not exiting on its own after successful execution

I have written a script to update my db table after reading data from db tables and solr. I am using asyn.waterfall module. The problem is that the script is not getting exited after successful completion of all operations. …

Read More
Using Solr search index as a database - is this "wrong"?

My team is working with a third party CMS that uses Solr as a search index. I've noticed that it seems like the authors are using Solr as a database of sorts in that each document returned contains two fields: …

Read More