… Xtrabackup tool, which will use same backup approach as InnoDB Hot Backup, that is taking online copy of InnoDB table files and transactional logs. This is going to be fully OpenSource, GPL licensed backup solution for MySQL (MyISAM and InnoDB for…
Post: Percona XtraBackup: Open Source Alternative for InnoDB Hot Backup call for ideas
February 24, 2009 By 20 Comments
Post: Percona's O'Reilly MySQL Conference Community Awards
April 18, 2011 By 5 Comments
… as O’Reilly MySQL Community Contributor of the Year 2011 for InnoDB performance improvements, and to XtraBackup as O’Reilly MySQL Application of the Year 2011 for adding opensource hot backup functionality to MySQL. It…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… standard MySQL crash recovery, and it can be reduced even further. More on this later. Free No extra commercial tools as Innodb Hot Backup are required to perform backup. Are there any downsides ? Need to have snapshot…
Post: xtrabackup-0.3, binaries and stream backup
March 13, 2009 By 11 Comments
…. MySQL 5.1 + standard InnoDB / InnoDB-plugin also are supported. It can fully work as drop-in replacement of innodbackup tool and InnoDB Hot Backup online backup. 2) Do we need to run patched MySQL, because the build instruction mentions the patch for MySQL ? A: xtrabackup…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… as LVM backup may not work in all cases. We also get into synchronization aspects making backup which prevents from having hot backup in… could have if we have a version of MySQL Server which drops everything but Innodb Storage engine (it could be NDB, PBXT… use Innodb transactional log for replication (which could be extended a bit for this purpose). Finally backup can be done in truly hot…
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 pretty good success. However having incremental backups remain the problem… it only changes couple of percents per day. The solution MySQL offers – using binary log works in theory but it is… do much better with Innodb in Particular. The Innodb pages have great deal of information helpful for their incremental backup in their internal…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 53 Comments
…statements. Table locks is no more problem, hot backups are easy, though there are some …backups, balancing, performance analyzes) as well as it exercises not so common paths in the MySQL …Innodb Needs Tuning As a final note about MyISAM to Innodb migration I should mention about Innodb tuning. Innodb…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
… backup impact on server performance may well be). We also assume backup is done on physical level here (cold backup, slave backup, innodb hot backup or snapshot backup… resources which may not be available, especially for CPU bound MySQL Load. The benefit in this case is less space requirement…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…mysql –mysql-host=localhost –mysql-table-engine=innodb –mysql-db=test –oltp-table-name=md_cache_test_small –oltp-table-size=1100000 –mysql-user=msandbox –mysql…
Post: Percona sessions at the MySQL conference
March 15, 2010 By 6 Comments
… Schwartz: MySQL Graphing and Trending with Cacti Vadim Tkachenko: XtraBackup: Hot Backups and More Aleksandr Kuzminsky: Recovery of Lost or Corrupted InnoDB Tables Ryan Lowe: Achieving PCI Compliance with MySQL Yves Trudeau…
