We are building a backup-restore scenario for a cluster that needs to be on-premise due to regulatory requirements and are trying to get a clear statement about following (of course we can run test scenarios and discover ourselves but it’s better to have the designed feature described):
-
Can Elastic indexes be rebuilt from scratch in case we restore only the temporal database or do we also need to backup restore Elastic? Our assumption is that we need both (based on some older answer) but maybe there is some feature to repopulate Elastic from the main database?
-
In case we restore the main database and Elastic with a small point-in-time difference, what will happen in case we query for:
a. A workflow that is found in Elastic but is already closed as per the main database?
b. A workflow that is not yet in Elastic but is already running as per the main database?
This question is relevant only in case the backup is not manually triggered and the restore happens as part of a business continuity, that means we are not able to gently switch off the cluster before performing the backup in which case of course both sides will contain the latest state that should match. -
Is there a way how to check/align Elastic content based on the main database after a restore (continuation of previous question)? That means it there is any way to get the latest visibility attributes from the main database and fix/update Elastic?
Thanks for the answers. I will also publish any findings once we have the backup/restore procedure designed and tested in case there is potential reused within the community.