Mysql Incremental Backup Query

Hi all,

What is the best solution for mysql incremental backup??

So far, I have tried with mysql-zrm tool for incremental backup. Tested it in our test database. Now i need to implement in our production database. Before that i wanted to be sure whether this mysql-zrm tool is appropriate or there are any better solution.

regards,

--amrush

 

Incremental backup will reduce your daily backup size but when it comes to restore issuse then you could face some problem....it is better you take full database backup everyday...and Mysql-zrm tool is front end of different backup method like mysqldump etc...

 

ZRM is easy to use tool and provides robust backup strategy for MySQL. You can take full and incremental backup with ZRM. There is no issue in implementing it for production database. One more very powerful tool for incremental backup is Xtrabackup from Percona. You can try this also.

 

hi diawilliam,

Thanks for reply...i already implemented mysql-zrm in one of my database for incremental backup...

but i have another query....is there any size limitation for zrm tool? right now my all databases varies upto 10 GB....but it is growing in a high rate...!!

regards,

--amrush

 

http://www.percona.com/software/percona-xtrabackup

 

NO, there is no any size limitation in the zrm tool.