Hi Dojo,
after migrating to STaaS, we are planning to decommission the former, self-hosted DB infrastructure (Elasticsearch & Cassandra). Before performing that procedure, we are thinking about taking one final backup, to have a snapshot of the data available just in case (e.g. element data).
Is there some kind of best practice or recommended procedure to perform such a backup? How is the distinction of the two DB's? Is element data stored in Cassandra, and alarm and trending data in Elasticsearch?
Thanks a lot!
Hi Nils,
Cassandra stores the element data, trending and a couple of other minor data sources.
Elastic has alarms, information events, DOM & SRM data.
For Cassandra, you can create a snapshot using nodetool on every node for every keyspace.
These are created in the Cassandra data directories and can be transferred over to different storage volumes for archival purposes.
For ElasticSearch/OpenSearch, you can similarly create a snapshot for archival purposes.
Here, you need to first register a repository which can be reached by all nodes in the cluster. This can be a network file path for example that points to your archival storage volume. The snapshot is then taken of the whole cluster at once and placed in the repository.
With Kind Regards,
Hi Simon,
I'll definitely look into that, thanks a lot!