MySQL Forums
Forum List  »  Backup

Re: Need help with a backup plan
Posted by: Rick James
Date: November 06, 2012 11:18PM

100MB? 100GB gets interesting.

mysqldump will prevent INSERTs and UPDATEs during the read to take the dump.
So will SELECT INTO OUTFILE. So, that won't help.

A MERGE table would let you backup only the latest sub-table, thereby shrinking the length of the lock.

If your tables were InnoDB, you could use XtraBackup, getting both a consistent dump (which you don't 'need') and a virtually no-impact dump.

Replication would let you take the Slave offline for backups. But there is some setup to get that going.

Stoping the server, then doing an rsync, might be faster, since most of the stuff does not change.

LVM is also a near-zero impact dump.

Read other threads in this forum; the various methods are discussed frequently.

Options: ReplyQuote


Subject
Views
Written By
Posted
2673
November 05, 2012 12:17PM
1398
November 05, 2012 12:25PM
Re: Need help with a backup plan
1372
November 06, 2012 11:18PM
1427
November 07, 2012 12:32AM


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.