Which hot backup tools for MySQL InnoDB database : Percona XtraBackup, Zmanda Recovery Manager Enterprise or Community or…? 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.
Disclaimer: I work for Percona and am one of the Percona XtraBackup developers.

You'd need to try the options and see what works best for you.

Given your needs I'd evaluate Percona XtraBackup first. It will perform the full and incremental hot backups just fine. In fact, Zmanda Recovery Manager uses Percona XtraBackup as its backend for the hot InnoDB backups.