I am looking into FreeBSD to provide a more comprehensive backup and disaster recovery strategy for database servers. Ideally I want to mimic what google is doing with "Persistent disks" https://developers.google.com/compute/docs/disks#snapshots
I am hoping someone who knows more about FreeBSD can validate these ideas/questions:
- I have read that FreeBSD can take instant disk snapshots, therefore if our databases trigger a consistent state (Block all writes, and flush buffers to disk), I would assume I could take snapshots every hour without service interruption for more than a few seconds. Is this true?
Is there a way to take snapshots and back them up offsite easily? Can this be done incrementally as to save how much disk space is actually used?
If a rollback needed to be done, how long does this typically take? Is a rollback also instantaneous?