Cassandra vs MSSQL – What features will I miss out on?

Solved1.60K viewsCassandra database db featuers MSSQL
2
0 Comments

Hello,

I've previously had dataminer training (nearly 2 years ago) and I recall the chap running the class mentioned that using Cassandra was preferable over MSSQL as the backend database.

I've asked a contact from Dataminer about this and was told the following:

"The main difference between MSSQL and Cassandra, is that one is a relational-Database, and the other is a big-data-database.

With MSSQL, along the way the DB will become slower, as more data gets stored in it.

For Cassandra this will not be an issue. Also Cassandra allows us to retrieve information in better and faster way.

Therefore some features in DataMiner will only be available if you have a Cassandra Database."

I would like to know what features of DataMiner will not be available if I used MSSQL - I was asked to post this question here by the DataMiner contact I emailed... Is anyone able to provide me a full list of said features?

Benjamin Cook Selected answer as best 7th June 2021

1 Answer

3
2.71K 2 Comments

Hi Benjamin,

The following features are Cassandra/Elastic only:

Another large feature on the roadmap is "Element Swarming", which will allow elements to load balance between different agents of a DataMiner cluster. This will also require Cassandra (cluster).

Benjamin Cook Selected answer as best 7th June 2021
Benjamin Cook commented

Jens,

Thanks four your reply – great to have some insight into that. Is anyone able to provide me a comprehensive list?

Reason I ask is MSSQL is my strategic database, deploying Cassandra will require more resource and hosting.

I need to determine if the features that Cassandra enables are actually required by users or if we can deploy with MSSQL.
Gellynck Jens [SLC] commented

Hi Benjamin,

I discussed this internally and the list above should be complete now. I have updated my answer to reflect this and added links to the DataMiner help because a comment does not allow me to do that.

Personally, I would still recommend using Cassandra so you’re more future-proof (most new features are scheduled for Cassandra). It does require more resources but should also improve the performance of DataMiner.

I hope this info helps you to decide on this important decision.