… had honestly not considered using the incremental backup feature of XtraBackup to ever backup the changes of anything other than your… backup or incremental backup. In XtraBackup Manager I tried to offset the time spent doing say, a restore on Friday, applying each…” feature, whereby XtraBackup Manager always maintains a fully materialized “restore” of the latest backup you took, so all the restore would require is…
Comment: MySQL Backup tools used by Percona Remote DBA for MySQL
March 14, 2013 By 8 Comments
… the fast restore times are great when you’re in a bad place. It’s all very well having xtrabackup do compression, but in order to check the backup (prior to restore), you need to apply… the past xtrabackup has had bugs at just that point that meant that backups would not restore. Is it possible for xtrabackup to…
Post: Avoiding SST when adding new Percona XtraDB Cluster node
August 2, 2012 By Leave a Comment
… a backup for this purpose, we have 3 prerequisites: use XtraBackup >= 2.0.1 the backup needs to be performed with… called xtrabackup_galera_info. The file contains the local node state at the time of the backup. So when you have restored… fetched during the backup. For example, if we have in xtrabackup_galera_info the following content: 5f22b204-dc6b-11e1-0800-7a9c9624dd66…
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 10 Comments
…. First, you must meet certain prerequisites to be able to restore a ibd tablespace: The ibd file must be from a…, shutting down with innodb_fast_shutdown=0. We’ll use XtraBackup to avoid the server shutdown. You must not drop, truncate… meanwhile. Though this only works if table was “exported” with Xtrabackup as this exports essential information from main tablespace which is…
Comment: How to recover a single InnoDB table from a Full Backup
March 22, 2012 By 10 Comments
… configuration file. I have the backup folder which contains xtrabackup log files, xtrabackup checkpoint file and a folder for my database (called tools) which contains .MYD, .ibd, .frm, .TRG files. I want to restore…). But I am not able to do a SINGLE DATABASE restore using the copy-back command. I am able to get…
Post: Fishing with dynamite, brought to you by the randgen and dbqp
November 16, 2011 By Leave a Comment
… and restores For this bug, we needed to ensure that the server used –innodb_file_per_table and that we used Xtrabackup… then try to restore it. These are basically the same steps we use in our basic_test from the xtrabackup suite. We…
Post: Impossible - possible, moving InnoDB tables between servers
June 8, 2009 By 9 Comments
…, I see real needs in this: – when we need to restore only single table from backup (sometimes developers kill only single… to shutdown instance with innodb_fast_shutdown=1 (done in xtrabackup –prepare –export call). The more complex problem was that InnoDB… information from system tablespace that related to exported table. Both xtrabackup –export mode and XtraDB innodb_expand_import available only in…
Post: What Are Full, Incremental, and Differential Backups?
January 23, 2012 By 9 Comments
… is in the way that you would restore a backup. Suppose that you need to restore your database on Friday. If you… since Sunday. If you have taken incremental backups, you must restore Sunday’s backup, and then apply changes repeatedly until you…, error-prone, and risky. It can also take longer. Percona XtraBackup is capable of taking incremental backups, and when you specify…
Post: An argument for not using mysqldump
November 8, 2010 By 26 Comments
I have a 5G mysqldump which takes 30 minutes to restore from backup. That means that when the database reaches 50G, it should take 30×10=5 hours to restore. Right? Wrong. Mysqldump recovery time is not linear… will always take more time to restore. If I restore from a raw backup (LVM snapshot, xtrabackup, innodb hot backup), it is very…
Comment: What is the largest amount of data do you store in MySQL ?
November 9, 2012 By 19 Comments
… and the hardest part is backups. Xtrabackup works good. But incrementals do not work with compressed Xtrabackups. We had a bug open… xtrabackup, (b) compressed incrementals and (c) parallel recovery (or to put it more simply a simple way to parallelize the restore such…
