MySQL Forums
Forum List  »  Newbie

Re: Need a SIMPLE and COMPLETE Backup Tool
Posted by: Rick James
Date: May 02, 2013 08:11AM

Note his use of words like "supports" and "allows". This is where COMPLETE conflicts with SIMPLE.

"to HDD, FTP, Network or cloud" -- that gives you 'complete', but not 'simple'.

Simple: Just make a copy on disk. Complete: Move that copy to another location for disaster protection.

Simple: No compression or encryption. Complete: Compression (to avoid running out of disk space), encryption (for safety).

Simple: Dump all tables (etc). Complete: Be able to dump one table.

Complete: Clone a Slave to make another Slave; handle Galera clusters; etc. (XtraBackup is good here)

Simple: XtraBackup can run without stopping the server. (Many products, including mysqldump, either stop the server or lock it for a long time.)

Disclaimer: I have no knowledge of mysqlbackupftp, and I am not intending to criticize it.

Options: ReplyQuote




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.