by Tim Sharp | Aug 25, 2014 | Insight for DBAs, MySQL, Percona Software
In a previous post, my colleague mission statement declares, the Trove project seeks to provide a scalable and reliable cloud database service providing functionality for both relational and non-relational database engines. With the current release of Icehouse, the...
by Matt Griffin | Aug 1, 2014 | Insight for DBAs, MySQL, Percona Services, Percona Software
MySQL plays a critical role in OpenStack. It serves as the host database supporting most components such as Nova, Glance, and Keystone and is the most mature guest database in Trove. Many OpenStack operators use Percona open source software including the MySQL drop-in...
by Jervin Real | Apr 24, 2014 | MySQL, Percona Services, Percona Software
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 --encrypt options with XtraBackup, all files will...
by Alexey Kopytov | Mar 11, 2014 | Insight for DBAs, MySQL, Percona Software
TL;DR version: The backup locks feature introduced in Percona Server 5.6.16-64.0 is a lightweight alternative to FLUSH 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...
by Paul Namuag | Nov 27, 2013 | MySQL, Percona Services, Percona Software
I recently conducted a test backup of my “master-slave” setup in my VirtualBox as I was migrating from Percona XtraBackup v2.2.0 rev. 4885. However, doing the backup on my slave, I encountered this problem: Shell [04] Compressing and streaming ./test/checksum.ibd [01]...
by Stephane Combaudon | Oct 11, 2013 | Insight for DBAs, MySQL, Percona Software
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 FLUSH TABLES WITH READ LOCK...
by Hrvoje Matijakovic | Sep 19, 2013 | Percona Events, Percona Software
Percona is glad to announce the release of Percona XtraBackup 2.1.5 on September 19th, 2013. Downloads are available from our download site here and Percona Software Repositories. This release is the current GA (Generally Available) stable release in the 2.1 series....
by Stewart Smith | Jul 16, 2013 | MySQL, Percona Software
Run Ubuntu and want to try new features of Percona XtraBackup? Well, now you can. We have a Personal Package Archive (PPA) percona-daily/percona-xtrabackup. Every time code is pushed to our main source code repository, the PPA is updated. We are currently building for...
by Mike Benshoof | Jun 10, 2013 | Insight for DBAs, MySQL
Recently, I was working with a client that asked about using Percona Xtrabackup to take a snapshot of a particular MySQL schema and then reload it with a different schema name on the same server. It caught me off guard because I’d never really thought about it...
by Hrvoje Matijakovic | May 22, 2013 | MySQL, Percona Software
Percona is glad to announce the release of Percona XtraBackup 2.1.3 for MySQL on May 22, 2013. Downloads are available from our download site here and Percona Software Repositories. This release fixes a high priority bug. It’s advised to upgrade your latest 2.1...
by Hrvoje Matijakovic | May 18, 2013 | MySQL, Percona Software
Percona is glad to announce the release of Percona XtraBackup 2.1.2 for MySQL on May 18, 2013. Downloads are available from our download site here and Percona Software Repositories. This release fixes number of high-priority bugs since version 2.1 became GA. It’s...
by Hrvoje Matijakovic | May 15, 2013 | MySQL, Percona Software
Percona is glad to announce the release of Percona XtraBackup 2.1.1 on May 15th 2013. Downloads are available from our download site here and Percona Software Repositories. Percona XtraBackup enables backups without blocking user queries, making it ideal for companies...
by Miguel Angel Nieto | May 9, 2013 | Insight for DBAs, MySQL, Percona Software
Percona XtraBackup 2.0.7 has been published with support for GTID based replication. As promised, here is the step-by-step guide on how to create a new GTID based slave (or repair a broken one) using XtraBackup. The process is pretty straightforward. 1- Take a backup...
by Hrvoje Matijakovic | May 7, 2013 | MySQL, Percona Software
Percona is glad to announce the release of Percona XtraBackup 2.1.0-rc1 on May 7, 2013. Downloads are available from our download site here. For this RC release, we will not be making APT and YUM repositories available, just base deb and RPM packages This is an...
by Hrvoje Matijakovic | May 6, 2013 | MySQL
Percona is glad to announce the release of Percona XtraBackup 2.0.7 for MySQL on May 6, 2013. Downloads are available from our download site here and Percona Software Repositories. Percona XtraBackup is the world’s only open-source, free MySQL hot backup...
by Vadim Tkachenko | Mar 21, 2013 | MySQL, Percona Events
I actually don’t remember exactly whether it was in 2006, 2007 or 2008 — but around that time the MySQL community had one of the greatest MySQL conferences put on by O’Reilly and MySQL. It was a good, stable, predictable time. Shortly thereafter, the MySQL...
by Ryan Huddleston | Mar 13, 2013 | Cloud, Insight for DBAs, Insight for Developers, MySQL
As part of Percona Remote DBA for MySQL service we recognize that reliable backups are one of the most important things we can bring to the table. In my experience handling emergencies, the single worst thing that can happen is finding out you don’t have backups...
by Vadim Tkachenko | Jan 29, 2013 | MySQL, Percona Software
We continue to improve Percona XtraBackup, and today I would like to give a preview for one feature which comes in next Percona XtraBackup 2.1 release. This feature is “Compact backups”, and let me explain what it does. As you may know InnoDB PK (Primary...
