MySQL Forums
Forum List  »  Backup

Re: Advise required on backup plan
Posted by: Scott Nemes
Date: November 20, 2012 12:24PM

Since you are using MyISAM, locking during backups will always be an issue. Given that, I would definitely recommend setting up a slave to use for backups (ideally on a separate host).

Have you looked into converting your tables to InnoDB? Given that your work load is write-heavy, you would likely see an increase in performance with InnoDB and a properly tuned configuration.

As for what tool to use; mysqldump works fine for simple cases like this with MyISAM. Otherwise you could look into Percona's Xtrabackup (http://www.percona.com/doc/percona-xtrabackup/), however for MyISAM-only that tool will not give you much extra functionality, but it may be quicker as your data set grows (and better if you convert to InnoDB).

As for the drive question, generally separate is better as long as the disk speeds are comparable. I would recommend a RAID 10 configuration for your data directory for speed and reliability with a write-heavy workload. Ideally your backups would be happening on a separate host or separate drive (with some sort of redundancy; either via RAID or storing the backups on multiple hosts for safe keeping).

Hope that helps!

--
Scott Nemes
MySQL DBA

http://www.linkedin.com/in/scottnemes
http://www.twitter.com/ScottNemes

Options: ReplyQuote


Subject
Views
Written By
Posted
2150
November 20, 2012 04:46AM
Re: Advise required on backup plan
1291
November 20, 2012 12:24PM
1191
November 25, 2012 03:17PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.