DMA Failover

Solved1.29K viewscorrupt database Failover resilience
3
0 Comments

Hello,

I've read that when DMA failover is configured, the passive DMA is continuously updated. Does this happen at a database or application level?

I want to understand if my Cassandra database for my primary DMA becomes corrupted, will the passive DMA also become corrupted?

Regards

Benjamin Cook Selected answer as best 7th June 2021

2 Answers

7
842 0 Comments

Hi Benjamin,

I would distinguish two types of information synchronized between failover agents.

  1. DataMiner files - protocols, elements, scripts, etc. This is synchronized at application level (DataMiner handles this process).
  2. The data written to the database. The way it's synchronized depends on the type of the database.
    1. MySQL: synchronization is handled by DataMiner, similar to file synchronization.
    2. Cassandra: When you set up a failover pair with Cassandra, the two database nodes are joined into the cluster. Since that moment, DataMiner just writes data into the Cassandra cluster, and Cassandra ensures the data is synchronized between the two nodes.

Therefore, the answer to your question depends on the way a corruption is introduced into the database. If it's invalid data pushed by DataMiner, then the data will be identical on both database nodes. If it's an issue with a database node, you should be able to retrieve the data from a healthy node.

Benjamin Cook Selected answer as best 7th June 2021
You are viewing 1 out of 2 answers, click here to view all answers.