Backup and Restore

The OneDB SQL Datastore supports an HA cluster setup. To do this one of the requirements is that a shared RWM storage is available for use. When setting up HA with OneDB an archive is taken from the OneDB HA Primary Server and restored to a OneDB HA Secondary or OneDB HA RSS system.

The shared volume provides all pods access to the archive’s. When deploying a OneDB helm chart one of the initial steps is to take an archive to be used to setup the Secondary and any RSS nodes.

The default behavior is for a level 0 archive to occur every night at 2:30am. The last three backups are retained and any prior archives are cleaned up and removed.

A restore should only be needed if both the OneDB HA primary and OneDB HA secondary servers are corrupted. If just one or ther other is corrupted then a failove scenario can occur to bring the two servers back into sync with one another.