TODO
It is recommended to put QuestDB into checkpoint mode before performing a backup. Head to <host>:7000/questdb/ and execute CHECKPOINT CREATE. When the backup is done execute CHECKPOINT RELEASE to revert QuestDB to normal operation.
QuestDB does not provide a dedicated backup mechanism, but instead relies on the user to cp or rsync the files to a backup location. The following command can be used to backup the QuestDB data directory:
cd /var/lib/xbat/questdb
tar -czvf /path/for/backup/questdb_backup.tar.gz *
To restore the backup, the following command can be used:
tar -xzvf questdb_backup.tar.gz -C /var/lib/xbat/questdb
Check the QuestDB documentation for further details.
Deleting benchmarks in xbat removes them from the MongoDB database. However, since QuestDB does not support the DELETE operation, there is no direct way of removing data within the constraints of xbat. Administrators can manually trigger a purge of deleted benchmarks from QuestDB by clicking Purge QuestDB in the xbat interface (Overview > Actions). To avoid any issues with running jobs, this action should only be performed when certain that no xbat jobs are currently running (e.g. when cluster is in drain/maintenance). It is recommended to restart xbat after purging QuestDB data to rebuild database indexes.