…’s only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. This release is… pool dump files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with… in the transactional log being overwritten before they are copied by the log copying thread. Percona XtraBackup now stores the GTID value…
Post: Percona XtraBackup: Open Source Alternative for InnoDB Hot Backup call for ideas
February 24, 2009 By 20 Comments
… horrible results forcing us to look at more performing alternatives. Innodb Hot Backup is a good working solution but it is not…, which will use same backup approach as InnoDB Hot Backup, that is taking online copy of InnoDB table files and transactional logs. This is… fully OpenSource, GPL licensed backup solution for MySQL (MyISAM and InnoDB for now). We gathered basic ideas here http://www.percona…
Comment: How fast is FLUSH TABLES WITH READ LOCK?
April 26, 2010 By 30 Comments
Sergei, Innodb Hot Backup and XtraBackup indeed does a hot copy without any communication with server – this works for Innodb part of the story. There… binary log position from the innodb log file indeed however you still need to have a consistent copy of .frm files and…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
… or partially executed statements. Table locks is no more problem, hot backups are easy, though there are some important things which… good for MyISAM kills Innodb, such as copying binary tables between the servers. It is important the team understands Innodb and knows how… important to adjust processes as required to work with Innodb. For example binary copy of one of the databases from the Slave…
Post: My "hot" list for next InnoDB features
March 30, 2009 By 18 Comments
Many InnoDB scalability problems seem fixed in InnoDB-plugin-1.0.3 and I expect InnoDB-plugin will run fine on 16-24… time – copying whole 500GB backup while you need to restore only single 20GB table is very non-productive Open InnoDB tables in… asked what are our current plans about XtraDB with recent InnoDB-pluging release, as performance improvements in plugin may make XtraDB…
Post: Thoughs on Innodb Incremental Backups
November 10, 2008 By 8 Comments
For normal Innodb “hot” backups we use LVM or other snapshot based technologies with … tool. Though you can do much better with Innodb in Particular. The Innodb pages have great deal of information helpful for their… and Innodb logs and MyISAM system tables need to be copied fully but they typically do not have any considerable portion of Innodb…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… and Innodb and BDB, It also should work with Solid, PrimeXT and Falcon storage engines. Fast Backup You simply do file copy…. More on this later. Free No extra commercial tools as Innodb Hot Backup are required to perform backup. Are there any downsides… have any long running queries. If you’re using only Innodb tables and do not need to synchronize binary log position…
Post: xtrabackup-0.3, binaries and stream backup
March 13, 2009 By 11 Comments
….1 + standard InnoDB / InnoDB-plugin also are supported. It can fully work as drop-in replacement of innodbackup tool and InnoDB Hot Backup online… the feature which is missed in InnoDB Hot Backup – the backup can be produced as stream and copied to remote box or tape… InnoDB users in any form so far – it is incremental and differential backups. Having that you will be able to make copy…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 25, 2012 By 20 Comments
Hi, Peter These days, i have discussed the hot backup problems with my friends, for percona xtrabackup, i think … TABLES WITH READ LOCK. 1. copy meta data files, like frm file. 2. copy data files other than InnoDB. 3. get the binlog… ddl operations in the progress of hot backup, frm files are consistent. 2. we only use InnoDB as our engine, no other…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… the data, which significantly limits performance compared to basically “zero copy” design one may have streaming data from memory when it… SQL level table locks and using Innodb internal data dictionary instead of Innodb files. We would use Innodb transactional log for replication (which could be extended a bit for this purpose). Finally backup can be done in truly hot…
