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

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?

5 Answers

Leave a Comment