We’ve recently received a number of questions on how to implement incremental MySQL backups alongside encryption with Percona XtraBackup. Some users thought it was not initially possible because with the default
options with XtraBackup, all files will be encrypted, but alas, that is not the case. This is where the option
becomes useful, because it allows you to save LSN (Log Sequence Number) information to another directory and exclude it from encryption, allowing you to …[Read more...]
I’d like to congratulate Canonical with the new Ubuntu 14.04
LTS (Trusty Tahr) Release, it really looks like a great
release, and I say it having my own agenda It looks even more
great because it comes with a full line of Percona
If you install Ubuntu 14.04 and run
you will find:
Percona Server 5.6.11-60.3 introduces a new “log archiving” feature. Percona XtraBackup 2.1.5 supports “apply archived logs.” What does it mean and how it can be used?
Percona products propose three kinds of incremental backups. The first is full scan of data files and comparison the data with backup data to find some delta. This approach provides a history of changes and saves disk space by storing only data deltas. But the disadvantage …[Read more...]
TL;DR version: The backup locks feature introduced in Percona
Server 5.6.16-64.0 is a lightweight alternative to
TABLES WITH READ LOCK and can be used to take both
physical and logical backups with less downtime on busy servers.
To employ the feature with
mysqldump --lock-for-backup --single-transaction.
The next release of Percona XtraBackup will also be using backup
locks automatically if the target server supports the
Now on to the gory details, but let’s start with some history.
In the beginning…
In the beginning there was …[Read more...]
I recently conducted a test backup of my “master-slave” setup in my VirtualBox as I was migrating from Percona Server 5.6.12 to version 5.6.13-rel61.0 with Percona XtraBackup v2.2.0 rev. 4885. However, doing the backup on my slave, I encountered this problem:
 Compressing and streaming ./test/checksum.ibd  Compressing and streaming ./mysql/slave_master_info.ibd Assertion "to_read % …[Read more...]
I recently had a case where replication lag on a slave was caused
by a backup script. First reaction was to incriminate the
additional pressure on the disks, but it turned out to be more
subtle: Percona XtraBackup was not able to execute
TABLES WITH READ LOCK due to a long-running query, and the
server ended up being read-only. Let’s see how we can deal with
that kind of situation.
Starting with Percona XtraBackup 2.1.4, you can: