…XtraBackup now supports streaming incremental backups. In previous versions streaming backups were performed by the innobackupex script but incremental backups were done by the …be part of the topics at the upcoming Percona Live MySQL Conference and Expo (register now!). Specifically, there are the …
Post: Announcing Percona XtraBackup 1.9.1
February 27, 2012 By 9 Comments
… incremental backups. It is now possible to stream incremental backups, lifting a limitation from previous versions where it was only possible to stream full backups… XtraBackup can now use multiple CPUs to perform a compressed backup, significantly reducing the amount of time needed. Parallel compression (‘–compress…
Post: What Are Full, Incremental, and Differential Backups?
January 23, 2012 By 2 Comments
… differential backups versus incremental backups. What is the difference? A full backup is pretty self-explanatory. It makes a copy of all of your MySQL… backup process can be significantly more efficient. An incremental backup is a modification of a differential backup. An incremental backup records the changes since the last backup…
Post: xtrabackup-0.5, bugfixes, incremental backup introduction
April 7, 2009 By 6 Comments
…backup tool. This version contains several bugfixes and introduces initial implementation of incremental backup. Incremental backup works in next way. When you do regular backup…database server closed innobackupex: Backup created in directory ‘/mnt/data/tmp’ innobackupex: MySQL binlog position: …
Post: Thoughs on Innodb Incremental Backups
November 10, 2008 By 8 Comments
… normal Innodb “hot” backups we use LVM or other snapshot based technologies with pretty good success. However having incremental backups remain the problem. First why do you need incremental backups at all ? Why not just take the full backups daily. The… it only changes couple of percents per day. The solution MySQL offers – using binary log works in theory but it is…
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… solutions? If you are using all InnoDB tables, an XtraBackup incremental backup should be much faster than using binary logs. You… restore! Eventually this problem should be lessened by a MySQL Server feature – parallel execution on slaves. Lets hope that…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
…three node cluster is much more complex than an average MySQL master-slave setup. Potential performance penalty: Although to have performance… with integration with Percona XtraBackup and its incremental backup features, it is possible to have incremental node provisioning. To finalize this post, let…
Post: Percona XtraBackup 1.6
April 12, 2011 By 15 Comments
…-backup-timeout to innobackupex. (Daniel Nichter) Other Changes Eliminated some compiler warnings. (Stewart Smith) Ported XtraBackup to MySQL 5.1.55, MySQL…properly quoted. Bug #688417 – It’s now possible to do incremental backups for compressed InnoDB tables. Bug #701767 – The script innobackupex-1…
Post: Percona Server and XtraBackup weekly news, March 12th
March 13, 2011 By Leave a Comment
… to do incremental backups on compressed tables. We’re improving incremental backups with streaming, so that incrementals can be taken without a base backup needing to…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…snapshots after finishing, sometimes due to the backup script failing before completion. Additionally, LVM …system reboot. The pmp-check-mysql-pidfile plugin verifies that MySQL‘s PID file exists. … supports an incremental mode of operation, so you can (for example) get the incremental increase in…
