…backups, and 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 data. A differential backup…
Post: Thoughs on Innodb Incremental Backups
November 10, 2008 By 8 Comments
…incremental backups remain the problem. First why do you need incremental backups at all ? Why not just take the full backups…of full copies of large database is not efficient. Especially if it only changes couple of percents per day. The solution MySQL…
Post: Just how useful are binary logs for incremental backups?
July 21, 2009 By 6 Comments
…of using it for incremental backup. Let me make up some numbers for the purposes of this example: We have 2 Servers in a…but to replay one day of binary logs it would take an additional 20 hours ((12 * 0… this problem should be lessened by a MySQL Server feature – parallel execution on slaves….
Post: Percona Xtrabackup 1.6.2 released!
July 25, 2011 By 1 Comment
…’s software is open-source and free, all the details of the release and its development process can be found in… producing a potentially unusable backup. Bug Fixed: #758888 (Alexey Kopytov). Bugs Fixed When creating an InnoDB with its own tablespace after taking a full backup, if the log files have been flushed, taking an incremental backup based on that full one…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
…mysql binary logs for point-in-time recovery after a restoring a backup. Since the backup is a essentially a ‘snapshot’ of the data at the time of the backup…practice, this means that it takes a minimum of a few seconds to incrementally refresh a view, even when the number of changes is very small. …
Post: Percona XtraBackup 1.6.4
December 19, 2011 By 9 Comments
… take a long time, innobackupex would hit the server wait_timeout and be disconnected, leading to a failed backup. With this bug fixed, instead of… send commands to MySQL on a connection that was already closed. The primary example was when running innobackupex with–incremental and –slave-save…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… take online non-blocking backups, or things like that. But in general it can be a …a syntax error in the my.cnf file. For an example, take a look at this bug report (not a bug). Looking at MySQL… second and subsequent are incremental differences. I’ll usually capture two of these. It looks like this…
Post: Percona XtraBackup 1.6.3
September 23, 2011 By 5 Comments
…series, a server upgrade is also recommended. All of Percona… –safe-slave-backup when either –no-lock or –incremental is … while taking a backup could lead to a xtrabackup failure due to a tablespace ID mismatch when using per-table tablespaces. Note that this fix may not work correctly with MySQL…
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: MySQL Master-Master replication manager released
April 5, 2007 By 27 Comments
… used by many companies using MySQL for scale out. Most of the companies would have … ? To take care of this Master Master Manager makes sure only one of the nodes …of the nodes you can use same tool to create a backup with number of methods supported including compressed backup or incremental backups…
