Bringing together the Apache Cassandra experts from the community and DataStax.

Want to learn? Have a question? Want to share your expertise? You are in the right place!

Not sure where to begin? Getting Started

 

question

ike22 avatar image
ike22 asked ·

What is the recommendation for separating OLTP and OLAP workloads in Cassandra?

My question relates to any best practices regarding Cassandra data being ingested by Decision Support type systems.

If this were Oracle I might setup a read-only standby for decision support systems to query instead of querying the online database to keep from impacting the OLTP transactions.

I'm wondering if there are any "Best Practice" type documents related to Cassandra. My thought is to create a separate DC as part of the cluster for the Decision Support systems to connect. I am wondering how other people are addressing this issue before I try to roll my own solution.

cassandra
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

ike22 avatar image
ike22 answered ·

@Erick Ramirez

Thank you sir!


Share
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

Erick Ramirez avatar image
Erick Ramirez answered ·

You are correct. Our recommendation is to isolate the workloads into a multi-DC setup so that OLAP queries which tend to be expensive don't affect OLTP transactions.

The advantage with using Cassandra is that replication between data centres takes place in real time so OLAP queries are run against the latest dataset. Cheers!

Share
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.