Hi, a user is interested in storing real-time trending data for up to a period of 3 years. User is currently running a 4-DMA cluster, and on DMA-10.1.x.
- From a DataMiner training video on the topic of Trending, it is mentioned that real-time trending data is recommended to be stored for only a couple of days (not recommended for weeks, months or years) due to the large amount of data that can be produce. It is observed that this is line with the default TTL value of 1 day.
- However it is also observed that that a max TTL value of 1098 days (approx. 3 years) for real-time trending data is allowed. Given the previous point above, are there any fine prints to be aware of when maxing out this value?
Are there any documented advice or best practice that a user intending to set real-time trending TTL to max value of 1098 should take into consideration? (e.g.: around the topic of DMA and DB Performance & Storage)
Hi Bing, please check that they are running a standalone Cassandra cluster as described in the data storage architectures page : https://community.dataminer.services/supported-system-data-storage-architectures/
So no database on the DMAs itself. That way it's easier to extend the DB cluster if it would be needed.
Also note that it's possible to Override the Time To Live default settings on a protocol base. If they only need it for one of the protocols, then this is the best option.
Unfortunately our calculator doesn't take in account the TTL.
Thank you Jeroen for these pointers. We’ll take them into consideration.