Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I don't have a problem with Zmanda but i wonder if there is any better or popular solutions out there other than doing it by hand.

My requirements are:

  • Online backups
  • The tool should decide to use mysqldump or mysqlhotcopy depending on the database
  • Verify integrity of backups
  • Send status emails
  • Clean old backups (optional)
  • Be able to choose between incremental or full backups (optional)

Replication seems to be the "best way to do backups" but I'm not gonna do that on this project.

share|improve this question
add comment

1 Answer

up vote 1 down vote accepted

I know this does not fully answer your question, but anyway:

  • LVM-based snapshots + rdiff-backup or anything else to make differential backup (it's brutal, it might fail you but tends to work for me)
  • xtrabackup - free & open source from Percona. It's young but promising, and provides ability to run live full and incremental backups of InnoDB.

For all of those, you'll need to put some scripts around. I'm ha appy user of backupninja, which I use as wrapper for my scripts. backupninja will mail you when things fail, will log output of commands etc.

Take a look here as well.

share|improve this answer
    
I didn't knew about backupninja, looks like a great tool :) –  pablasso May 29 '09 at 17:57
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.