June 19, 2013

Post: Percona XtraBackup 2.0.7 for MySQL available for download

…full backup and an incremental one were present in the full backup directory, and were not removed when incremental backups … when preparing the MySQL 5.6 backup if the log files were bigger than 4G on …which could cause backup to fail. Bug fixed #1169726. For the Debian and the Linux binaries, the –…

Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download

…that are caused by the log records in the transactional log being overwritten before they …backup and an incremental one were present in the full backup directory, and were not removed when incremental backups…could cause backup to fail. Bug fixed #1169726. For the Debian and the Linux binaries, the …

Post: Thoughs on Innodb Incremental Backups

…. 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… will take over 24 hours to cover month worth of binary logs… and quite typically you would have much higher update traffic…

Post: xtrabackup-0.5, bugfixes, incremental backup introduction

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

Post: Just how useful are binary logs for incremental backups?

… side effects of the binary log being serialized, is that it also limits the effectiveness of using it for incremental backup.  Let me… are using all InnoDB tables, an XtraBackup incremental backup should be much faster than using binary logs.  You can understand Vadim’s excitement…

Post: Flexviews - part 3 - improving query performance using materialized views

incremental method is somewhat conceptually similar to using mysql binary logs for point-in-time recovery after a restoring a backup. Since the backup is… the binary logs brings the database up-to-date by replaying the changes. An MV is also like a snapshot. The incremental refresh…

Post: Percona XtraBackup 1.6

incremental-basedir is ignored. (Vadim Tkachenko) Added option –incremental-dir to innobackupex. This option is passed directly to the xtrabackup binary…672384 – When no log files can be found in the backup directory while…It’s now possible to do incremental backups for compressed InnoDB tables. Bug …

Post: Announcing Percona XtraBackup 1.6.7

…running with –apply-log, it was reading configuration from the server configuration file instead of backup-my.cnf in backup directory. Bug fixed…when merging an incremental backup to a full one. Bug fixed #1002688 (Alexey Kopytov). XtraBackup binary was leaking file descriptors on –backup. This was…

Post: Percona XtraBackup 1.4

incremental backups. If you do incremental backups, it’s strongly recommended that you upgrade to this release. Functionality Added or Changed Incremental backupsBinaries

Post: Percona Xtrabackup 1.6.2 released!

… xtrabackup binary for printing its version. Previously, the version was displayed only while executing the binary without arguments or performing a backup. Bug… own tablespace after taking a full backup, if the log files have been flushed, taking an incremental backup based on that full one would…