Is a backup transactionally consistent?
Assume a server is busy processing transactions (e.g. MySQL on Ubuntu).
When the DO backup is taken is it guaranteed to maintain transactional (ACID) consistency within the database files?
In other words, if I recover from a backup will it represent a valid database (of some time ago) or will the block copy process sometimes update the log but not the buffer-cache spill or vice versa?
Happy to lose some data, I just need consistent data files for a historic point-in-time :-)
Lastly, is the same true for DO snapshots?