February 22, 2012

Comment: Announcing MySQL Monitoring Plugins from Percona

hello,Baron Schwartz, i used xtrabackup for incremental backup , i used –salve-info to incremntal backup for convenience,but i found it always… (0 1172823116) ,so the process of backup countn’t
end , the xtrabackup_suspended file alse exist. when i drop the –salve-info option …

Comment: Announcing Percona XtraBackup 1.6.5

Hi, Stewart Smith, i used xtrabackup for some time, but i found a limitation about it.
when i added or deleted a table , i can’t do a increment backup , could only do a full backup;
when i dropped or added a index on a table , deleted or added one or some fileds on a table…

Post: Announcing Percona XtraBackup 2.0 Beta 1

… is glad to announce our first Beta release of what will become Percona XtraBackup 2.0. We’re releasing this beta to encourage testing of our upcoming… on it for production workloads – use the stable 1.6 series of Percona XtraBackup instead.

In this beta we’re proud to add:

support for Galera …

Post: Announcing Percona XtraBackup 1.6.5

Percona is glad to announce the release of Percona XtraBackup 1.6.5 on 10 February, 2012 (Downloads are available here and from …purely composed of bug fixes and is the current stable release of Percona XtraBackup.

There are some important bug fixes around incremental backups, parallel backups and…

Post: My talks on PL MySQL Conference (+free book inside)

On coming PL MySQL conference 2012 I will give one tutorial:
Percona XtraBackup: install, usage, tricks. This tutorial I will do in joint with … XtraBackup. Our intent is to provide the comprehensive overview of the XtraBackup architecture and features, and we will touch future roadmap. This is all …

Comment: Announcing Percona XtraBackup 1.6.5

It seems there’s no 64-bit binary of 1.6.5 at:

http://www.percona.com/downloads/XtraBackup/XtraBackup-1.6.5/binary/Linux/

whereas it does exist for 1.6.4:

http://www.percona.com/downloads/XtraBackup/XtraBackup-1.6.4/Linux/binary/

Comment: What Are Full, Incremental, and Differential Backups?

… I had honestly not considered using the incremental backup feature of XtraBackup to ever backup the changes of anything other than your most…full backup on Sunday, by providing a “materialized backups” feature, whereby XtraBackup Manager always maintains a fully materialized “restore” of the latest …

Comment: Verifying backup integrity with CHECK TABLES

…opposite direction:
If there is a suspicion for InnoDB corruption, then I suggest Xtrabackup is not the tool to check this with. Because it, in itself,…. So it is possible that in the event of InnoDB corruption, the Xtrabackup would make it even more corrupted, so to speak. The restore process would…

Post: How to recover a single InnoDB table from a Full Backup

…. That is, shutting down with innodb_fast_shutdown=0. We’ll use XtraBackup to avoid the server shutdown.
You must not drop, truncate or alter … in the meanwhile. Though this only works if table was
“exported” with Xtrabackup as this exports essential information from main tablespace which is not …

Comment: Announcing Percona XtraBackup 2.0 Beta 1

The –version option to xtrabackup will tell you exactly what version you’re running.

You could be hitting https://bugs.launchpad.net/percona-xtrabackup/+bug/569387