Search code examples
phpmysqlsphinxxapiantokyo-tyrant

Sphinx + tokyo Tyrant + mysql

I'm looking at creating a full text search engine for one of my projects. We have a Mysql, Tokyo Tyrant and file documents that need to be indexed.

I'm looking at Sphinx right now but I can't figured out if I can use it to index every document.

I know it's possible to let Sphinx to use Mysql but I'm looking at a way to let Sphinx index and query Tokyo Tyrant as well as index file documents.

It could be Sphinx or Xapian or another one but no JAVA (Lucene is out) but something that can be used with PHP and run on Linux.

Any idea of a search engine that can accept more that Mysql as the source?

Thanks

Solution

  • You can send data from any source to sphinx using the xmlpipe2

    You'd just need to write some code (probably in PHP) to read from Tokyo Tyrant (not sure what that is so you're on your own there) and the filesystem and package it all up as XML. Then you just set up your sphinx source to run a command that executes your custom code and sphinx takes care of the rest.