KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
Folks, I'm trying to set up a regular backup of a rather large production database (half a gig) that has both InnoDB and MyISAM tables. I've been using mysqldump so far, but I find that it's taking increasingly longer periods of time, and the server is completely unresponsive while mysqldump is running. I wanted to ask for your advice: how do I either Make mysqldump backup non-blocking - assign low priority to the process or something like that, OR Find another backup mechanism that will be better/faster/non-blocking. I know of the existence of MySQL Enterprise Backup product (http://www.mysql.com/products/enterprise/backup.html) - it's expensive and this is not an option for this project. I've read about setting up a second server as a "replication slave", but that's not an option for me either (this requires hardware, which costs $$). Thank you! UPDATE: more info on my environment: Ubuntu, latest LAMPP, Amazon EC2.
Tags (comma-separated)
Save Edits
Cancel