Google Datastore has a backup utility . But for an online database, it’s too slow, requiring several hours to backup or restore several tens of GB. In addition, Google recommends that you turn off cloud storage records during backup, which again is not possible for the operating database.
How can I back up my data warehouse so that if there is data corruption, I can quickly recover without losing more than a few minutes of transactions?
This seems to be an integral part of any fully functional database system.
(Other databases provide this
- storage only for applications or
- periodic backups supplemented by a differential backup or transaction log or
- real-time mirroring, although this does not apply to the case of data corruption from an error that is written to the database.)
source
share