by Yves Trudeau | Jul 9, 2013 | Hardware and Storage, Insight for DBAs, MySQL
For the same customer I am exploring ZFS for backups, the twin server is using regular LVM and XFS. On this twin, I have setup mylvmbackup for a more conservative backup approach. I quickly found some odd behaviors, the backup was taking much longer than what I was...
by Morgan Tocker | Dec 25, 2010 | Insight for DBAs, MySQL
Inspired by Baron’s earlier post, here is one I hear quite frequently – “If you enable innodb_file_per_table, each table is it’s own .ibd file. You can then relocate the heavy hit tables to a different location and create symlinks to the...
by Fred Linhoss | Dec 13, 2010 | MySQL, Percona Software
Percona XtraBackup 1.5-Beta is now available for download. This release adds additional functionality to Percona XtraBackup 1.4, the current general availability version of XtraBackup. This is a beta release. Functionality Added or Changed Support for MySQL 5.5...
by Fred Linhoss | Nov 22, 2010 | MySQL, Percona Software
Percona XtraBackup 1.4 is now available for download. Version 1.4 fixes problems related to incremental backups. If you do incremental backups, it’s strongly recommended that you upgrade to this release. Functionality Added or Changed Incremental backups have...
by Aurimas Mikalauskas | Nov 9, 2010 | Insight for DBAs, MySQL
Before I start a story about the data recovery case I worked on yesterday, here’s a quick tip – having a database backup does not mean you can restore from it. Always verify your backup can be used to restore the database! If not automatically, do this...
by Morgan Tocker | Nov 8, 2010 | Insight for DBAs, MySQL
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. Bigger tables, or tables with more indexes...
by Baron Schwartz | Jul 31, 2010 | Insight for DBAs, MySQL
A couple of weeks ago one of my colleagues and I worked on a data corruption case that reminded me that sometimes people make unsafe assumptions without knowing it. This one involved SAN snapshotting that was unsafe. In a nutshell, the client used SAN block-level...
by Aleksandr Kuzminsky | Jul 1, 2010 | Insight for DBAs, MySQL
For a long time long types like BLOB, TEXT were not supported by Percona InnoDB Recovery Tool. The reason consists in a special way InnoDB stores BLOBs. An InnoDB table is stored in a clustered index called PRIMARY. It must exist even if a user hasn’t defined...
by Baron Schwartz | Apr 24, 2010 | Insight for Developers, MySQL
A week or so ago at the MySQL conference, I visited one of the backup vendors in the Expo Hall. I started to chat with them about their MySQL backup product. One of the representatives told me that their backup product uses FLUSH TABLES WITH READ LOCK, which he...
by Aleksandr Kuzminsky | Apr 13, 2010 | MySQL, Percona Software
Dear Community, The notice is hereby given that next version 1.2 of XtraBackup software is released. The list of changes in this version includes: Changelog: XtraBackup supports now XtraDB 10 tar4ibd supports variable page size and fast_checksum of XtraDB Supported...
by Vadim Tkachenko | Sep 14, 2009 | Percona Software
If you ever wondered how big is that or another index in InnoDB … you had to calculate it yourself by multiplying size of row (which I should add is harder in the case of a VARCHAR – since you need to estimate average length) on count of records. And it...
by Aleksandr Kuzminsky | Aug 20, 2009 | Percona Software
Dear Community, The release 0.9 of the opensource backup tool for InnoDB and XtraDB is available for download. Changelog: tar4ibd could not treat over 8GB file, now max 64GB prepare-speed-hack is added Fixed bugs: Bug #386179: “InnoDB: Error: space id in fsp...
by Morgan Tocker | Jul 21, 2009 | Insight for DBAs
We’ve written about replication slaves lagging behind masters before, but one of the other side effects of the binary log being serialized, is that it also limits the effectiveness of using it for incremental backup. Let me make up some numbers for the...
by Vadim Tkachenko | Jul 7, 2009 | Percona Software
Speed of InnoDB recovery is known and quite annoying problem. It was discussed many times, see: http://bugs.mysql.com/bug.php?id=29847 http://dammit.lt/2008/10/26/innodb-crash-recovery/ This is problem when your InnoDB crashes, it may takes long time to start. Also it...
by Aleksandr Kuzminsky | Jul 1, 2009 | Percona Software
Dear community, The release 0.8 of the opensource backup tool for InnoDB and XtraDB is available for download. Key features: New mode of innobackupex –stream=tar4ibd; new command tar4ibd based on libtar-1.2.11 Experimental option –export is added (see...
by Vadim Tkachenko | May 21, 2009 | Percona Software
We announce next version of our xtrabackup tool and we consider it stable enough to put label RC on it. Changelist includes: – use O_DIRECT by default for handling InnoDB files – use posix fadvise call to disable OS caching of copying files – disable...
by Vadim Tkachenko | May 20, 2009 | Percona Software
Using xtrabackup for copying files can really saturate your disks, and that why we made special option --throttle=rate 1 --throttle=rate to limit rate of IO per second. But it really works when you do local copy. What about stream backup ? Even you copy just to remote...
by Vadim Tkachenko | Apr 29, 2009 | Percona Software
We announce next beta version of our xtrabackup tool. Changelist includes: – set innodb_fast_shutdown=1 on xtrabackup shutdown – set innodb_write_io_threads=10 by default for fast buffer_pool flushing during recovery – build xtrabackup with...
by Vadim Tkachenko | Apr 7, 2009 | Percona Software
I am happy to announce next build of our backup tool. This version contains several bugfixes and introduces initial implementation of incremental backup. Incremental backup works in next way. When you do regular backup, at the end of procedure you can see output: The...
by Vadim Tkachenko | Mar 30, 2009 | Percona Software
We added some new features to our backup tool, namely: Now we can handle log file taken during backup with size exceeding 4GB, it may happen if backup takes too long and you have a lot of updates on InnoDB tables Progress meter during recovery step, now you can see...
