… InnoDB. 3. get the binlog file and binlog postion information. And if we ensure the following requirements, we can do a hot backup without using FLUSH TABLES WITH READ LOCK: 1. do not do any ddl operations in the progress of hot backup, frm files are consistent. 2. we only use InnoDB as our engine, no other engines…
Post: Percona XtraBackup: Open Source Alternative for InnoDB Hot Backup call for ideas
February 24, 2009 By 20 Comments
… Xtrabackup tool, which will use same backup approach as InnoDB Hot Backup, that is taking online copy of InnoDB table files and transactional logs. This is going to be fully OpenSource, GPL licensed backup…
Post: Thoughs on Innodb Incremental Backups
November 10, 2008 By 8 Comments
For normal Innodb “hot” backups we use LVM or other snapshot based technologies with pretty good success. However having incremental backups remain the problem… do much better with Innodb in Particular. The Innodb pages have great deal of information helpful for their incremental backup in their internal…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… based MySQL backups are great ? There are number of reasons: Almost Hot backup In most cases you can perform this type of backup while… this later. Free No extra commercial tools as Innodb Hot Backup are required to perform backup. Are there any downsides ? Need to have snapshot… mentioned this solution is often hot backup, but bad thing it is hard to estimate when it is hot and when it is…
Post: xtrabackup-0.3, binaries and stream backup
March 13, 2009 By 11 Comments
… + standard InnoDB / InnoDB-plugin also are supported. It can fully work as drop-in replacement of innodbackup tool and InnoDB Hot Backup online backup. 2) Do… version of xtrabackup contains the feature which is missed in InnoDB Hot Backup – the backup can be produced as stream and copied to remote…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
… backup impact on server performance may well be). We also assume backup is done on physical level here (cold backup, slave backup, innodb hot backup or snapshot backup… you’re not using dedicated server for backups. I should also note for mysqldump backup typically tools with better and slower compression…
Comment: xtrabackup-0.9.5rc
October 26, 2009 By 13 Comments
… both InnoDB Hot Backup and Xtrabackup on different clients, and we don’t find crashing. We did find similar usage for Xtrabackup vs. InnoDB hot backup – so Xtrabackup isn’t causing really different loads than InnoDB hot backup. (we found that xtrabackup consistently…
Comment: xtrabackup-0.9.5rc
November 5, 2009 By 13 Comments
Xtrabackup and InnoDB hot backup do hot backups. A backup is hot when you can perform it on an active database. While …
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 53 Comments
… or partially executed statements. Table locks is no more problem, hot backups are easy, though there are some important things which we… envinronment works great for MyISAM but does not work with Innodb. Backup tools like “mysqlhotcopy” does not work etc. Note Performance also…) for logging. Innodb Needs Tuning As a final note about MyISAM to Innodb migration I should mention about Innodb tuning. Innodb needs tuning. Really…
Comment: Using LVM for MySQL Backup and Replication Setup
January 16, 2009 By 53 Comments
… move away from innodb hot backup. 1) I saw that I can skip the FLUSH TABLES WITH READ LOCK for my Innodb tables, but… you’re using only Innodb tables and do not need to synchronize binary log position with backup you can skip this step… problem? 2) I have a mix of MyISAM and Innodb, but mostly Innodb, is there a work around for this so I…
