You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Roshni Rajagopal <ro...@hotmail.com> on 2012/09/19 14:27:43 UTC
Solr Use Cases
Hi,
Im new to Solr, and I hear that Solr is a great tool for improving search performanceIm unsure whether Solr or DSE Search is a must for all cassandra deployments
1. For performance - I thought cassandra had great read & write performance. When should solr be used ?Taking the following use cases for cassandra from the datastax FAQ page, in which cases would Solr be useful, and whether for all?Time series data managementHigh-velocity device data ingestion and analysisMedia streaming (e.g., music, movies)Social media input and analysisOnline web retail (e.g., shopping carts, user transactions)Web log management / analysisWeb click-stream analysisReal-time data analyticsOnline gaming (e.g., real-time messaging)Write-intensive transaction systemsBuyer event analyticsRisk analysis and management
2. what changes to cassandra data modeling does Solr bring? We have some guidelines & best practices around cassandra data modeling.Is Solr so powerful, that it does not matter how data is modelled in cassandra? Are there different best practices for cassandra data modeling when Solr is in the picture?Is this something we should keep in mind while modeling for cassandra today- that it should be good to be used via Solr in future?
3. Does Solr come with any drawbacks like its not real time ?
I can & should read the manual, but it will be great if someone can explain at a high level.
Thank you!
Regards,Roshni
Re: Solr Use Cases
Posted by aaron morton <aa...@thelastpickle.com>.
> Also, Cassandra is great for writes but not as optimized for reads.
From cassandra 1.0 read throughout on a par with writes http://www.datastax.com/dev/blog/whats-new-in-cassandra-1-0-performance
You milage may vary depending on the workload.
Cheers
-----------------
Aaron Morton
Freelance Developer
@aaronmorton
http://www.thelastpickle.com
On 20/09/2012, at 3:08 AM, Michael Kjellman <mk...@barracuda.com> wrote:
> If I were you I would look into ElasticSearch unless you are okay updating the search cache very infrequently.
>
> I tried Solandra vs ElasticSearch in our use case and there was no contest.
>
> Also, Cassandra is great for writes but not as optimized for reads. Honestly, it all depends on your use case and what brand of Lucine depends on it.
>
> I would benchmark it and see what sticks.
>
> On Sep 19, 2012, at 5:28 AM, "Roshni Rajagopal" <ro...@hotmail.com>> wrote:
>
> Hi,
>
> Im new to Solr, and I hear that Solr is a great tool for improving search performance
> Im unsure whether Solr or DSE Search is a must for all cassandra deployments
>
> 1. For performance - I thought cassandra had great read & write performance. When should solr be used ?
> Taking the following use cases for cassandra from the datastax FAQ page, in which cases would Solr be useful, and whether for all?
>
> * Time series data management
> * High-velocity device data ingestion and analysis
> * Media streaming (e.g., music, movies)
> * Social media input and analysis
> * Online web retail (e.g., shopping carts, user transactions)
> * Web log management / analysis
> * Web click-stream analysis
> * Real-time data analytics
> * Online gaming (e.g., real-time messaging)
> * Write-intensive transaction systems
> * Buyer event analytics
> * Risk analysis and management
>
> 2. what changes to cassandra data modeling does Solr bring? We have some guidelines & best practices around cassandra data modeling.
> Is Solr so powerful, that it does not matter how data is modelled in cassandra? Are there different best practices for cassandra data modeling when Solr is in the picture?
> Is this something we should keep in mind while modeling for cassandra today- that it should be good to be used via Solr in future?
>
> 3. Does Solr come with any drawbacks like its not real time ?
>
> I can & should read the manual, but it will be great if someone can explain at a high level.
>
> Thank you!
>
>
> Regards,
> Roshni
>
> 'Like' us on Facebook for exclusive content and other resources on all Barracuda Networks solutions.
> Visit http://barracudanetworks.com/facebook
>
>
Re: Solr Use Cases
Posted by Michael Kjellman <mk...@barracuda.com>.
If I were you I would look into ElasticSearch unless you are okay updating the search cache very infrequently.
I tried Solandra vs ElasticSearch in our use case and there was no contest.
Also, Cassandra is great for writes but not as optimized for reads. Honestly, it all depends on your use case and what brand of Lucine depends on it.
I would benchmark it and see what sticks.
On Sep 19, 2012, at 5:28 AM, "Roshni Rajagopal" <ro...@hotmail.com>> wrote:
Hi,
Im new to Solr, and I hear that Solr is a great tool for improving search performance
Im unsure whether Solr or DSE Search is a must for all cassandra deployments
1. For performance - I thought cassandra had great read & write performance. When should solr be used ?
Taking the following use cases for cassandra from the datastax FAQ page, in which cases would Solr be useful, and whether for all?
* Time series data management
* High-velocity device data ingestion and analysis
* Media streaming (e.g., music, movies)
* Social media input and analysis
* Online web retail (e.g., shopping carts, user transactions)
* Web log management / analysis
* Web click-stream analysis
* Real-time data analytics
* Online gaming (e.g., real-time messaging)
* Write-intensive transaction systems
* Buyer event analytics
* Risk analysis and management
2. what changes to cassandra data modeling does Solr bring? We have some guidelines & best practices around cassandra data modeling.
Is Solr so powerful, that it does not matter how data is modelled in cassandra? Are there different best practices for cassandra data modeling when Solr is in the picture?
Is this something we should keep in mind while modeling for cassandra today- that it should be good to be used via Solr in future?
3. Does Solr come with any drawbacks like its not real time ?
I can & should read the manual, but it will be great if someone can explain at a high level.
Thank you!
Regards,
Roshni
'Like' us on Facebook for exclusive content and other resources on all Barracuda Networks solutions.
Visit http://barracudanetworks.com/facebook
Re: Solr Use Cases
Posted by Brian O'Neill <bo...@alumni.brown.edu>.
Roshni,
We're using SOLR to support ad hoc queries and fuzzy searches against
unstructured data stored in Cassandra. Cassandra is great for storage
and you can create data models and indexes that support your queries,
provided you can anticipate those queries. When you can't anticipate
the queries, or if you need to support a large permutation of
multi-dimensional queries, your probably better off using an index
like SOLR.
Since SOLR only supports a flat document structure, you may need to
perform transformation before inserting into SOLR. We chose not to
use DSE, so we used a cassandra-triggers as our mechanism to integrate
SOLR. (https://github.com/hmsonline/cassandra-triggers) We intercept
the mutation, transform the data into a document (w/ multi-value
fields) and POST it to SOLR.
More recently though, we're looking to roll out ElasticSearch. As our
query demand increases, we expect SOLR to quickly become a PITA to
administrer. (master->slave relationships) IMHO, ElasticSearch's
architecture is a better match for Cassandra. We are also looking to
substitute cassandra-triggers for Storm, allowing us to build a data
processing flow using Cassandra and ElasticSearch bolts. (we've open
sourced the Cassandra bolt and we'll be open sourcing the elastic
search bolt shortly)
-brian
On Wed, Sep 19, 2012 at 8:27 AM, Roshni Rajagopal
<ro...@hotmail.com> wrote:
> Hi,
>
> Im new to Solr, and I hear that Solr is a great tool for improving search
> performance
> Im unsure whether Solr or DSE Search is a must for all cassandra deployments
>
> 1. For performance - I thought cassandra had great read & write performance.
> When should solr be used ?
> Taking the following use cases for cassandra from the datastax FAQ page, in
> which cases would Solr be useful, and whether for all?
>
> Time series data management
> High-velocity device data ingestion and analysis
> Media streaming (e.g., music, movies)
> Social media input and analysis
> Online web retail (e.g., shopping carts, user transactions)
> Web log management / analysis
> Web click-stream analysis
> Real-time data analytics
> Online gaming (e.g., real-time messaging)
> Write-intensive transaction systems
> Buyer event analytics
> Risk analysis and management
>
>
> 2. what changes to cassandra data modeling does Solr bring? We have some
> guidelines & best practices around cassandra data modeling.
> Is Solr so powerful, that it does not matter how data is modelled in
> cassandra? Are there different best practices for cassandra data modeling
> when Solr is in the picture?
> Is this something we should keep in mind while modeling for cassandra today-
> that it should be good to be used via Solr in future?
>
> 3. Does Solr come with any drawbacks like its not real time ?
>
> I can & should read the manual, but it will be great if someone can explain
> at a high level.
>
> Thank you!
>
>
> Regards,
> Roshni
--
Brian ONeill
Lead Architect, Health Market Science (http://healthmarketscience.com)
Apache Cassandra MVP
mobile:215.588.6024
blog: http://brianoneill.blogspot.com/
twitter: @boneill42