General Steps for Backing Up Databases

NuoDB recommends the following steps to create database copies and store them as backups:

  1. Define site-specific backup policies and guidelines such as:

    • Naming conventions for directories that will contain database copies

    • Schedule of how often to make copies of databases

    • Any post-processing of database copy destination directories, for example, compressing them with an external tool or moving them to a remote location

  2. According to your backup policies, use offline backup or online backup to regularly obtain a copy of the current state of each database. A running database’s archive and journal provide the current state of that database.

  3. Store the copy in a secure location. Ensure that each stored copy includes both the archive and the journal.

To use Incremental Backups, use the following steps:

  1. Start a SM (or SMs) with the options parameter using journal-hot-copy set to enable.

  2. Run Full Hot Copy of the database and specify the destination archive directory(ies), (optional) journal directory(ies), and participating SMs.

  3. Run Journal Hot Copies of the database at regular intervals, specifying the destination archive directory(ies), (optional) journal directory(ies), participating SMs,

  4. Run Incremental Hot Copies to decrease the time to restore (optional).

With storage groups, participating SMs should be selected such that the storage groups served by those SMs cover all storage groups in the database.