An introduction on how to use XtraBackup to perform hot backups of MySQL

Mark Callaghan discusses the implications of using FLUSH TABLES WITH READ LOCK and what this command actually does.

A quick look at some strong points between InnoDB Hot Backup and Xtrabackup

Informative post about backup and restore procedures, disaster recovery plans and load balancing tips.

A short time ago I posted how I was Using XtraDB Backup to backup InnoDB. Overall, the blog post was positive, but experiences that others have had (and commented to on that blog post) have made me want to put out another short article about using XtraDB backup.The first few points remain the same -- the backup process is stable, we were able to use the binaries without compiling, and using Innobackupex as the wrapper script, analogous to Innobackup.pl. However, we did figure out why Xtrabackup had to be run as the mysql user:Xtrabackup writes to the data dictionary file (ibdata1, for example). We have not examined if it also writes to the data and index files (still ibdata1 by default, or the .ibd files when using innodb_file_per_table). [EDIT: The authors of Xtrabackup have commented below as to why the write occurs:xtrabackup is kind of very small and restricted instance of InnoDB, and reuses a lot of InnoDB code.InnoDB by  []

Consistent backup:A consistent backup is one that represents a snapshot of all data at a point in time. Consistent backups are used for disaster recovery. An inconsistent backup can be useful for retrieving partial data -- for example, if a long-time customer accidentally deletes information from his profile, you can go back to an inconsistent backup and retrieve that information. It is not important that all the data be consistent with each other when retrieving a partial amount of point-in-time data.Logical backups:

As Baron points out, Percona's Xtrabackup tool can be used just like InnoDB Hot Backup.Many are wondering, "is it good enough?" In fact, I wondered the same thing, and after a few weeks of using and testing Xtrabackup (on machines that have MyISAM and InnoDB tables), I can say:0) We have not run into any problems with

There are several ways to backup MySQL, since online backup hasn't made its way into production releases yet, so this is good roundup of what is available now.

A utility like mysqldump is very useful for backing up MySQL data and table schema. However, backups are usually made only once a day or at some other regular interval. If data is lost on your system several hours after the last backup is completed, you may not be able to recover it. There are a few methods by which you can continuously protect data, some of which are explored in this article.(2005-04-26)

There is a cool option for mysqlbinlog for disabling the binary log when doing recovery using binary logs, namely --disable-log-bin. There are various ways for doing this.

Keeping good database backups is crucial because unpredictable disastrous events always occurs. In web-based business – backup is a critical component. There exist different open-source scripts, that could help to organize the database backup process in a customized and easy way, avoiding use of mysqldump (default MySQL backup tool). This article describes various open-source scripts that can help a newbie sysadmin to organize MySQL backup process.

This session will give you an overview about how to perform backups of a MySQL Server using file system snapshots. Lenz will explain the general procedure, Caveats and Gotchas with this backup technique and how to work around some of them. The talk will also introduce two very popular methods for performing the actual snapshots: Linux LVM and using ZFS snapshots. Other utilities suitable for creating snapshot are covered as well.

This session will give you an overview about how to perform backups of a MySQL Server using file system snapshots. Lenz will explain the general procedure, Caveats and Gotchas with this backup technique and how to work around some of them. The talk will also introduce two very popular methods for performing the actual snapshots: Linux LVM and using ZFS snapshots. Other utilities suitable for creating snapshot are covered as well.

Do you use replication? Would you like to improve your data protection and recovery capabilities? If you do, chances are you would also like to improve your ability to recover from failures faster. In this session, we will show you how you can use backup to enhance your replication capabilities.

Do you like to tinker? Would you like to see how MySQL? If you’d like to get your hands dirty (or watch others work their developer magic), stop by this session and learn how to take a simple desktop system running MySQL into a fully functional time based backup system that you can connect to any server and get up to the minute recovery capability.