…’s only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. This release is… pool dump files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with… in the transactional log being overwritten before they are copied by the log copying thread. Percona XtraBackup now stores the GTID value…
Post: Percona XtraBackup: Open Source Alternative for InnoDB Hot Backup call for ideas
February 24, 2009 By 20 Comments
… horrible results forcing us to look at more performing alternatives. Innodb Hot Backup is a good working solution but it is not…, which will use same backup approach as InnoDB Hot Backup, that is taking online copy of InnoDB table files and transactional logs. This is… fully OpenSource, GPL licensed backup solution for MySQL (MyISAM and InnoDB for now). We gathered basic ideas here http://www.percona…
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 … be able to restore to, having huge amount of full copies of large database is not efficient. Especially if it only… and Innodb logs and MyISAM system tables need to be copied fully but they typically do not have any considerable portion of Innodb…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… and Innodb and BDB, It also should work with Solid, PrimeXT and Falcon storage engines. Fast Backup You simply do file copy…. More on this later. Free No extra commercial tools as Innodb Hot Backup are required to perform backup. Are there any downsides…) Mount backup Filesystem: mount /dev/Main/dbbackup /mnt/backup 6) Copy data to backup. Normally you can skip slow query logs…
Post: xtrabackup-0.3, binaries and stream backup
March 13, 2009 By 11 Comments
….1 + standard InnoDB / InnoDB-plugin also are supported. It can fully work as drop-in replacement of innodbackup tool and InnoDB Hot Backup online… the feature which is missed in InnoDB Hot Backup – the backup can be produced as stream and copied to remote box or tape… InnoDB users in any form so far – it is incremental and differential backups. Having that you will be able to make copy…
Comment: How fast is FLUSH TABLES WITH READ LOCK?
April 26, 2010 By 30 Comments
Sergei, Innodb Hot Backup and XtraBackup indeed does a hot copy without any communication with server – this works for Innodb part of the story. There… binary log position from the innodb log file indeed however you still need to have a consistent copy of .frm files and…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
… or partially executed statements. Table locks is no more problem, hot backups are easy, though there are some important things which… good for MyISAM kills Innodb, such as copying binary tables between the servers. It is important the team understands Innodb and knows how… important to adjust processes as required to work with Innodb. For example binary copy of one of the databases from the Slave…
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… time – copying whole 500GB backup while you need to restore only single 20GB table is very non-productive Open InnoDB tables in… asked what are our current plans about XtraDB with recent InnoDB-pluging release, as performance improvements in plugin may make XtraDB…
Post: An argument for not using mysqldump
November 8, 2010 By 26 Comments
…, xtrabackup, innodb hot backup), it is very easy to model how much longer recovery time will take: Backup is 80G Copy is at…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
… get the “snapshot” – shutting down MySQL Server and copying data, using LVM, Using Innodb Hot Backup Tool, Using another Slave, using backup image…
