[Maria-discuss] MariaDB daily backups on EC2/EBS via EBS snapshots?
12 Jul
2021
12 Jul
'21
11:09 a.m.
Hi, for the scenario of a daily backup on a MariaDB with InnoDB engine running on a EC2 with EBS - would a EBS snapshot be enough to have consistent backups that MariaDB could restore from? I know that I might lose in-flight transactions without any "flushing", but for a daily backup, I accept the backup being a few (milli) seconds bit behind, as long as I have a consistent persistent state. To my understanding Amazon EBS snapshots are consistent point-in-time snapshots (e.g via copy-on-write) of the volume, and MariaDB with a transactional storage engine guarantees transactional consistent writes to disk under all conditions. Thanks for any clarification! Joachim
1225
Age (days ago)
1225
Last active (days ago)
0 comments
1 participants
participants (1)
-
Joachim Dorn