Hello Dojo,
I have a setup with a DMS (with 3 DMAs) and external databases (cassandra cluster – 2 nodes – and elasticsearch cluster – 3 nodes). I noticed the DMAs servers are using a different time (CET) when comparing to the database servers (using UTC).
I am aware that the 3 DMA servers need to be time synced and between the database servers, we should also use the same timestamp.
But does any of you know if there can be any impact having a time difference between database cluster and DMA servers?
You need the same clock on all the servers that form one cluster. This is for the Cassandra, OpenSearch and DataMiner clusters. To achieve this, use the same NTP server on all the servers within the same cluster (especially when working with VMs). Do not use winter and summer hours on the servers as this will also give unwanted behavior.
I’m not aware that DM and the DB servers have to be using the same time(zone), so AFAIK it is not a requirement.
On a different note, if you have time difference among your cassandra nodes itself, you can run into this problem : Cassandra cluster node in unexpected state | DataMiner Docs.