Cassandra/Opensearch cluster – multiple systems

Solved729 viewsCassandra DB elastic cluster
2
0 Comments

Hi all,

Is it possible to connect multiple greenfield DataMiner Systems to the same database cluster? Are there any risks when doing this?

Thx

Leander Druwel [SLC] [DevOps Member] Selected answer as best 12th December 2023

1 Answer

2
814 2 Comments

Hi Leander,

This is possible to do.
The main thing to keep in mind configuration wise is to ensure that each DMS has its own bespoke keyspace/database prefix configured in the configuration in DB.xml

As each prefix is used to uniquely identify the data which belongs to a specific DMS.

Once multiple systems are connected, it is useful to be mindful of the resource usage on the clustered databases. Therefore we would recommend making use of the cluster monitors for Cassandra and Elastic/Opensearch to monitor the clustered databases.

With Kind Regards,

Yvon Masson [DevOps Advocate] Posted new comment 10th January 2024
Leander Druwel [SLC] [DevOps Member] commented

Thanks Simon for the answer.

I do understand that this option will require some maintenance and monitoring to ensure a good functioning. Guess STaaS is the easier option if it comes down to installation & maintenance 🙂 Thx
Yvon Masson [DevOps Advocate] commented

Hello,

Thanks for the clarification.

I have some more questions,

How many DMS can co-exist in the same DB cluster?
How about version compatibility, say we have several DMS with different 10.x versions, I guess Cassandra and OpenSearch versions are less likely to change as often as the DMA?
Imagine we upgrade in the future only one DMS to version 11. What is the risk of upgrading the Cassandra and OpenSearch if needed for the DMS 10.x ones, will you ensure lower Cassandra/OpenSearch version compatibility with the next DMA versions?

Thanks in advanced.

Yvon