…incremental backups. In previous versions streaming backups were performed by the innobackupex script but incremental backups…backup, the LRU dump is now included as well. Support for compiling and running Percona XtraBackup against debug versions of InnoDB… Percona Live MySQL Conference and Expo (…
Post: Thoughs on Innodb Incremental Backups
November 10, 2008 By 8 Comments
… 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. There… and yet simple for Incremental backup for Innodb. In a way similar to rdiff the tool could both update the backup and store the…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
… after finishing, sometimes due to the backup script failing before completion. Additionally, LVM…pmp-check-mysql-innodb plugin checks for several indicators of severe internal problems within InnoDB, such…supports an incremental mode of operation, so you can (for example) get the incremental increase…
Post: Just how useful are binary logs for incremental backups?
July 21, 2009 By 6 Comments
… that it also limits the effectiveness of using it for incremental backup. Let me make up some numbers for the purposes… are the solutions? If you are using all InnoDB tables, an XtraBackup incremental backup should be much faster than using binary logs.Â… restore! Eventually this problem should be lessened by a MySQL Server feature – parallel execution on slaves. Lets hope that…
Post: Percona XtraBackup: Open Source Alternative for InnoDB Hot Backup call for ideas
February 24, 2009 By 20 Comments
…backup of files. For next stages we are looking to implement advanced functionality like incremental backup (copy only changes from last backup),table-level backup…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… with integration with Percona XtraBackup and its incremental backup features, it is possible to have incremental node provisioning. To finalize this post, let…downside of MySQL/Galera is that it is based on standard InnoDB 5.1 instead of InnoDB-plugin. Standard InnoDB is seriously behind InnoDB-…
Post: Percona XtraBackup 1.6
April 12, 2011 By 15 Comments
… stream backup. (Vadim Tkachenko) Added option –incremental-lsn to innobackupex. If specified, this option is passed directly to the xtrabackup script and –incremental… Percona Server 5.5, rather than MySQL 5.5. Support for building against InnoDB plugin in MySQL 5.1 has been removed. (Alexey… quoted. Bug #688417 – It’s now possible to do incremental backups for compressed InnoDB tables. Bug #701767 – The script innobackupex-1.5.1…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…increment_incrementblogpercona.commanual auto_increment…
Post: xtrabackup-0.3, binaries and stream backup
March 13, 2009 By 11 Comments
… or with InnoDB also ? A: xtrabackup is designed to work with standard version of InnoDB in MySQL 5.0. MySQL 5.1 + standard InnoDB / InnoDB-plugin… which is not available for InnoDB users in any form so far – it is incremental and differential backups. Having that you will be…
Post: Statistics of InnoDB tables and indexes available in xtrabackup
September 14, 2009 By 6 Comments
… first is that running statistics on your backup database does not need to hurt production…` (`from_message_id`,`link_id`) ) ENGINE=InnoDB AUTO_INCREMENT=26141165 DEFAULT CHARSET=utf8; And size …if you are badly missing some features in MySQL, InnoDB, InnoDB-plugin, XtraDB, XtraBackup – you know whom…
