… files, like frm file. 2. copy data files other than InnoDB. 3. get the binlog file and binlog postion information. And… ddl operations in the progress of hot backup, frm files are consistent. 2. we only use InnoDB as our engine, no other engines… file and binlog postion information from xtrabackup_binlog_pos_innodb file since InnoDB will wirte these information in its commit log. Am…
Post: Best kept MySQLDump Secret
March 23, 2012 By 11 Comments
Many people use mysqldump –single-transaction to get consistent backup for their Innodb tables without making database read only. In most cases it…` char(255) NOT NULL, `i` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs… you get some empty tables in your mysqldump –single-transaction backups you will know the potential cause for it. What are…
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 7 Comments
… the backup has been taken. The variable innodb_file_per_table must be enabled. Then, our first step is to get a consistent backup… the magic trick that will help us to get a consistent backup with complete independent ibd files without shutting down the service….cnf –export /tmp/ Then apply the logs to get a consistent backup: # innobackupex –defaults-file=/etc/my.cnf –apply-log –export /tmp…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… this later. Free No extra commercial tools as Innodb Hot Backup are required to perform backup. Are there any downsides ? Need to have… whatever else you might need to do to ensure your backup is consistent. Backing up database which was already corrupted is very… you’re using only Innodb tables and do not need to synchronize binary log position with backup you can skip this step…
Post: 10 things you need to know about backup solutions for MySQL
March 3, 2009 By 23 Comments
… copy? Does the backup system understand that you cannot back up InnoDB by simply copying its files? Does the backup use FLUSH TABLES…-in-time recovery? How does the system guarantee consistency with the binary log, InnoDB logs, and replication? Can you use the system…? Does the system verify that the backup is restorable, e.g. does it run InnoDB recovery before declaring success? Does anyone stand…
Post: Using XtraBackup on NFS for MySQL backups
December 9, 2010 By 5 Comments
… that volume to prepare the backup (apply the logs), that other server might not have a consistent view of the data. That… happens, xtrabackup will potentially see corrupt or inconsistent data. And InnoDB does not tolerate that. It will refuse to work, which… they are completely ready to use. (You should test your backups even more than that — we’ve blogged before about that…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 70 Comments
…LVM for database directory to get more efficient backup. EXT3 file system works OK in most cases…details, check out detailed guide on tuning innodb buffer pool innodb_log_file_size – This depends on …transactions when doing updates, both for sake of consistency and to get better performance. Next if …
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
… online backup work in PBXT, and is incremental backup possible? A recent version of PBXT (1.0.09) supports the MySQL Backup API… version of MySQL 5.4. The Backup API makes it possible to pull a consistent snapshot of an entire database even when… by PBXT using an MVCC-based consistent snapshot. Does PBXT have a maintenance thread like InnoDB‘s main thread? PBXT has several…
Comment: An argument for not using mysqldump
November 8, 2010 By 24 Comments
…’re just running innodb, you can run mysqldump with the –singletransaction flag which will get you a consistent logical backup. It’ll take… innodb, I generally trust its recovery engine so you can snap it w/o the read lock. This is a crash consistent copy and you’ll have to go through a recovery when you try to restore that backup. There are…
Post: Why you can't rely on a replica for disaster recovery
July 31, 2010 By 25 Comments
…view, though, it was still completely corrupted. The “InnoDB file” contained blocks of data that were …blocks over the interconnect, without regard to logical consistency on the filesystem level. Two things can help…the table off your “backup.” I still see people using a replica as a backup, and I …
