Backup and Restore
Sophia supports asynchronous Hot/Online Backups.
Each backup iteration creates exact copy of environment, then assigns backup sequential number. Sophia v2.1 does not support incremental backup.
backup.path must be set with a specified folder which will contain resulting backup folders. To start a backup, user must initiate backup.run procedure first. Procedure call is fast and does not block.
sp_setint(env, "backup.run", 0);
backup.active and backup.last_complete variables can be examined to see if backup process is in progress or being succesfully completed.
Additionally, scheduler.event_on_backup can be enabled which will result in asynchronous notifications using scheduler.on_event function and sp_poll(). This might be helpful for a event loop integration.
Backups being made as a part of a common database workflow. It is possible to change backup priorities using compaction redzone settings.
To restore from a backup, a suitable backup version should be picked, copied and used as sophia.path directory.