Can sphinx be used over cassandra?

I am planning to build a cassandra store system and also I need a full-text(Chinese) system too. Can sphinx be used on cassandra? (sphinx supports xml f开发者_Python百科ormat but I am not going to use it, cause it is slow and much of time are spent on xml parsing). Or you can share your experiences if you have ever built a full-text searching system over cassandra. Thank you

I would recommend to take a look at Lucandra (Lucandra = Lucene + Cassandra )

There's no other way to build sphinx index except of using xml pipe as of now

In this case I would also recommend using Solandra (ex. Lucandra), which is Solr implementation which uses Cassandra as backend storage. Solandra server node runs both Solr and Cassandra on the same JVM.

One strong points with Solandra over pure Solr or Sphinx is implicit distributed searches over cluster. I have not heard that Sphinx would have Cassandra backend.

You can do initial "feed" with XML, then you could use "live" indexing - using SphinxQL on Sphinx "MySQL" port (3307 I believe).

We do than on very large 200M MySQL table.