In case all Cassandra nodes associated with a DMA are down, database files will be offloaded to the system cache folder on disk, and will be pushed to the database once the connection becomes available again.
I wonder if there is a way to manually enable the offload while the database is up and running?
For debugging purposes, I'd like to see what exactly is being pushed to the database in terms of trend data, element data, etc..., without having to temporarily disconnect the database.
Hello Ruben,
There is the message "FileOffloadToggleRequest", which does exactly what you need (can be sent through the SLNetClientTest tool).
However, this might not work on some versions (in the 9.6.x range). We've also reworked offload since RN25917, which should be in 10.0.9. This message should only be used for debugging purposes though.
Unlike MySQL, its good to note that the data is being serialized into files that can't be read without deserializing (when on fileoffload).
Thanks Thomas. Although it looks like sending the ‘FileOffloadToggleRequest’ manually seems to be broken in 10.0.9, I believe once working it’s currently the best approach for getting insight into data sent to the db.
Note: The sqlite offload file needs to be deserialized in order to extract any useful data.