Re: Use-case: multi-instance webshop

2012-05-10 Thread aaron morton
It's hard to beat Solr for seach and faceted navigation. Perhaps consider using Cassandra and Solr or take a look at http://www.datastax.com/products/enterprise Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 8/05/2012, at 11:06 PM, R.

Re: Use-case: multi-instance webshop

2012-05-10 Thread Radim Kolar
Is Cassandra a fit for this use-case or should we just stick with the oldskool MySQL and put things like votes, reviews etc in our C* store? If all your data fits into one computer and you expect only tens of millions records in table then go for SQL. It has far more features and people are

Re: Use-case: multi-instance webshop

2012-05-10 Thread R. Verlangen
@Aaron: Solr will probably be the solution to our problem. Thank you! @Radim: We already have a Cassandra cluster, we do not want to add an extra MongoDB cluster. At this moment the data would fit easily in SQL, but we don't know how our platform grows and we want to be prepared for the future.

Use-case: multi-instance webshop

2012-05-08 Thread R. Verlangen
Hi there, I'm working on a datamodel for a multi-website, multi-customer system. Things we would like to do: - search products (lucene / solr / solandra) - multi-filter (e.g. categories) - reviews - voting I can't really see how to do the filtering of the products by categories and even things