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?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.×