MySQL Forums
Forum List  »  Backup

Re: Advise required on backup plan
Posted by: Rick James
Date: November 25, 2012 03:17PM

> I thought Innodb was for bigger databases.
General rule this day: InnoDB for all tables.

> there is no reason why I should switch to Innodb
True, you do not "have to" change.

A Slave makes an excellent backup tool, whether it is InnoDB or MyISAM.

With Percona's Xtrabackup, you can take a live backup of InnoDB tables (but not MyISAM) with virtually no impact on the queries coming in.
Hence, that would be an argument for using InnoDB, then Xtrabackup instead of Replication for backup.

Options: ReplyQuote

Written By
November 20, 2012 04:46AM
November 20, 2012 12:24PM
Re: Advise required on backup plan
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.