Re: Advice for asymmetric reporting cluster architecture

2015-10-18 Thread Ryan Svihla
Don't forget SSDs for indexing joy and a reasonable amount of cpu or those indexes will be very behind. If you size the hardware correctly and avoid very silly configuration it works really well for this sort of purpose, especially when combined with Spark to do any hardcore analysis on the

Re: Advice for asymmetric reporting cluster architecture

2015-10-17 Thread Jack Krupansky
Yes, you can have all your normal data centers with DSE configured for real-time data access and then have a data center that shares the same data but has DSE Search (Solr indexing) enabled. Your Cassandra data will get replicated to the Search data center and then indexed there and only there.

Re: Advice for asymmetric reporting cluster architecture

2015-10-17 Thread Mark Lewis
I hadn't considered it because I didn't think it could be configured just for a single data center; can it? On Oct 17, 2015 8:50 AM, "Jack Krupansky" wrote: > Did you consider DSE Search in a DC? > > -- Jack Krupansky > > On Sat, Oct 17, 2015 at 11:30 AM, Mark Lewis

Advice for asymmetric reporting cluster architecture

2015-10-17 Thread Mark Lewis
I've got an existing C* cluster spread across three data centers, and I'm wrestling with how to add some support for ad-hoc user reporting against (ideally) near real-time data. The type of reports I want to support basically boil down to allowing the user to select a single highly-denormalized

Re: Advice for asymmetric reporting cluster architecture

2015-10-17 Thread Jack Krupansky
Did you consider DSE Search in a DC? -- Jack Krupansky On Sat, Oct 17, 2015 at 11:30 AM, Mark Lewis wrote: > I've got an existing C* cluster spread across three data centers, and I'm > wrestling with how to add some support for ad-hoc user reporting against > (ideally)