We used to have mostly MyISAM tables (only 1 InnoDB). Our backup solution uses
mysqldump. However we noticed that sometimes the backup "broke" the site for a couple of minutes.
So we've switched to InnoDB, to have more reliable backups and remove the table locks that MyISAM uses.
Now I was wondering whether there are better ways to handle daily backups.
Note: Since we're using Amazon RDS, we can't use programs that need to run on the DB machine itself.