…. 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: Just how useful are binary logs for incremental backups?
July 21, 2009 By 6 Comments
… 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: 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…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
… 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
April 12, 2011 By 15 Comments
…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: Percona XtraBackup 1.4
November 22, 2010 By 10 Comments
…incremental backups. If you do incremental backups, it’s strongly recommended that you upgrade to this release. Functionality Added or Changed Incremental backups…Binaries…
Post: Percona Xtrabackup 1.6.2 released!
July 25, 2011 By 1 Comment
… 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…
Comment: Why MySQL's binlog-do-db option is dangerous
May 14, 2009 By 12 Comments
… important issue to consider is that binary logs are not only used for replication. They are incremental backups, and if you chose to use… history, and should you have a disaster and need the incremental backups, there is no way to retrieve the ignored information.
Comment: xtrabackup-1.2
May 10, 2010 By 2 Comments
Hi, when I use the xtrabackup binary of xtrabackup1.2 to do the incremental backup, have a error.how to resovle it? OS… = ibdata1:10M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 1 xtrabackup: innodb_log_file_size = 2097152 xtrabackup…
Comment: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
…. Does this mean Galera does not write anything like the binary log? Since they have global transaction id’s, a disconnected slave… a certain id. Of course, xtrabackup incremental backup is actually doing the same thing, just from innodb log… For performance penalty, it is… the proper comparison is single node with both innodb_flush_log_at_trx_commit=1 and sync_binlog=1, and two…
