Search engine for a CMS

Question

I'm developing a search system for a CMS and we use INNODB. I'm still designing the system and at first i looked at FULLTEXT on mysql to develop the search feature but i just discovered it is supported by MyISAM only.

I've always ignored third party search engines like Lucene or Sphynx because i tought they couldn't adapt to a CMS because it had to be run externally from your webserver. I've never used one, that's why i'm asking a question: is there a third party search engine that could be easily deployed with the CMS code itself, without needing the user to run anything on the server?

Maybe the solution is easy but i'm totally new to these things.

Answer 1

Perhaps try; http://www.google.co.uk/cse/

Otherwise depending on the complexity of the search perhaps try stack a few SQL LIKEs since you cannot use FULLTEXT.

Answer 2

You can use Zend Framework's implementation of Lucene - it can be used standlone, without other parts of ZF, and it does not need separate server, since the search-index is stored in files.

Answer 3

MySQL's FULLTEXT searching is a very blunt instrument - and doesn't lend itself to refinement. If you want an off-the-shelf solution, you might want to have a look at mnogo which provides a lot of useful search engine functionality out of the box.