Backing Up and Restoring Databases

NuoDB provides several mechanisms for copying and backing up a database. These mechanisms are differentiated by the backup workflow at runtime and the granularity of data available at restore time

  • Offline backup — Copy current state from a shutdown Storage Manager (SM). This requires a redundant SM.

  • Online backup — Copy current state by invoking the NuoDB Command’s hotcopy command on a running database.

  • Online hot copy — Use journal-based point-in-time restore.

  • Asynchronous Storage Manager (ASM) — Replicate changes to a passive data center for quick recovery from a disaster.