… 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: 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…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… with MyISAM and Innodb and BDB, It also should work with Solid, PrimeXT and Falcon storage engines. Fast Backup You simply do… this later. Free No extra commercial tools as Innodb Hot Backup are required to perform backup. Are there any downsides ? Need to have snapshot… you’re using only Innodb tables and do not need to synchronize binary log position with backup you can skip this step…
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: 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…
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… as a backup may well work for MyISAM but will start taking way too much time to do restore for Innodb. On…
Post: My "hot" list for next InnoDB features
March 30, 2009 By 18 Comments
Many InnoDB scalability problems seem fixed in InnoDB-plugin-1.0.3 and I expect InnoDB-plugin will run fine on 16-24… soon: Fast recovery. Both recovery after crash and recovery from backup can take unacceptable long time, especially if you crashed with… – copying whole 500GB backup while you need to restore only single 20GB table is very non-productive Open InnoDB tables in parallel…
