…MySQL hot backups for all versions of Percona Server, MySQL, MariaDB, and Drizzle. It performs streaming, compressed, and incremental MySQL backups. Percona’s enterprise-grade commercial MySQL…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… the world’s only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. This release is… taking a full backup and an incremental one were present in the full backup directory, and were not removed when incremental backups has been merged…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps… taking a full backup and an incremental one were present in the full backup directory, and were not removed when incremental backups has been merged…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
…’s DBD::MySQL package for server communication instead of spawning the MySQL command line client. Support for InnoDB 5.0 and InnoDB 5.1… can use XtraDB changed page tracking feature to perform the Incremental Backups now. Bugs Fixed: innobackupex is using SHOW MASTER STATUS to…
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 11 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…
