question

ike22 avatar image
ike22 asked ike22 answered

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
Toggle Comment visibility. Current Visibility: Viewable by all users

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

2 Answers

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
Toggle Comment visibility. Current Visibility: Viewable by all users

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
Toggle Comment visibility. Current Visibility: Viewable by all users

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