… use LVM or other snapshot based technologies with pretty good success. However having incremental backups remain the problem. First why do you need incremental… Innodb pages have great deal of information helpful for their incremental backup in their internal. There is basically page version allowing…
Post: MySQL Master-Master replication manager released
April 5, 2007 By 27 Comments
… it is implemented based on Linux IP management tools and LVM for snapshot creation but we hope support for other operation systems… will hold the server for administrator to decide. One command LVM based sync is also implemented so restoring broken replication safe… backup with number of methods supported including compressed backup or incremental backups with rdiff. Finally we have implemented safe role switch…
Comment: State of the art: Galera - synchronous replication for InnoDB
October 28, 2009 By 13 Comments
… down”, it is just blocked for the duration of state snapshot transfer. This first implementation is using mysqldump which is slow… much shorter time, but may require some special setup (like LVM). Incremental state transfer is also in the works. But for now…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…full LVM snapshots. LVM backup strategies can fail to delete snapshots after finishing, sometimes due to the backup script failing before completion. Additionally, LVM snapshots …; it also supports an incremental mode of operation, so you can (for example) get the incremental increase in a variable …
Post: Percona XtraBackup: Open Source Alternative for InnoDB Hot Backup call for ideas
February 24, 2009 By 20 Comments
…Linux we have been using LVM snapshots. Performance concerns from performance critical envinronment caused us to do LVM performance research which showed horrible…next stages we are looking to implement advanced functionality like incremental backup (copy only changes from last backup),table-level …
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
… works well when all you want is to remove auto_increment or change ENUM values. When it comes to changes that… mmm_clone i.e. you don’t have lvm or another way to create snapshots, this could be the only good way… all set. If mmm_clone is configured to do mysql snapshots, this could be a better way to achieve the same…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… three commands are for giving me information about LVM devices, volume groups, and logical volumes. At this…server was booted; the second and subsequent are incremental differences. I’ll usually capture two of these….done with that, I’ll grab a few snapshots of SHOW FULL PROCESSLIST, and look for odd…
