After database restoration (cassandra and/or elastic on separate server for a cluster for example), how can I be sure that the restored database is consistent or not? I'm looking for a procedure or tools/scripts.
Hey Yvan,
For Elastic I would recommend verifying historical alarms are present using the alarm console (tutorial here) . Also, Kibana can be used to check Elastic cluster health and indexes.
To do this run C:\Program Files\Elasticsearch\Kibana\bin\kibana.bat as Administrator. Once the cmd prompt indicates Kibana has started you can connect to your node using a web browser (not IE). Kibana Dev Tools can then be used to query Elastic. Some useful queries are below.
#GET cluster health status#
GET /_cluster/health?pretty
#GET indexes sorted by size#
GET /_cat/indices/?v=true&s=store.size
For Cassandra you would want to verify trend graphs contain historical data. Also the status and size of your Cassandra node(s) should be checked using nodetool.
From a Cassandra server, open cmd prompt and navigate to C:\Program Files\Cassandra\bin. Once there enter cmd nodetool status.
Hope this helps.