Using Amazon's EBS for MySQL hot backup
- by flybywire
What are your experiences using Amazons EBS snapshot features for MySql hot backups.
I have a database running a batch processing job in ec2. I backup with EBS snapshot. So far the backups looks consistent. But I am afraid they "will stop being consistent as soon as I stop checking" (Uncertainty principle).
What are your experiences with backuping relational databases (and mysql in particular) with ebs snapshot?