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

user_58394 0
Viewed 56840

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 query: say "SELECT id, text_to_index FROM documents;"
  • Must be free software and must run on Linux with MySQL as the database
  • Must be fast (rules out MySQL's internal full-text search)

The alternatives I've found that have these properties are:

  • Solr (based on Lucene)
  • ElasticSearch (also based on Lucene)
  • Sphinx

My questions:

  • How do they compare?
  • Have I missed any alternatives?
  • I know that each use case is different, but are there certain cases where I would definitely not want to use a certain package?
sphinx solr lucene full-text-search mysql
5 Answers

Lucene / Solr appears to be more featured and with longer years in business and a much stronger user community. imho if you can get past the initial setup issues as some seems to have faced (not we) then I would say Lucene / Solr is your best bet.

user_5394460
Related