I manage a PHP/MySQL website :
- max 500 simultaneous users / average of 4000 per hour in update/read
- 1 MySQL Community Server (5.1) - (Xeon / 16 Go RAM)
- InnoDB Storage engine on 100 tables for 1.4 Go of data
Actually, every 30mn a cronjob make a full dump in file... But since several, it's cause fatal errors on PHP (because of timeout)
So I would like to have a tool to do real Hot Backup... I googled and "stackoverflowed" and it seems that " products seems to do the job : - Percona XTraBackup (free) - Zmanda Recovery Manager Community (free) - Zmanda Recovery Manager Enterprise (500$)
But I can't see what are really the difference and what could be the criteria. My need seems to be simple : made full (or incremental) backup to restore my database if a crash occurs without putting my website down... I'm not a DBA so I need a "simple" product.
Many thanks for you help.