by Peter Zaitsev | Dec 28, 2016 | Insight for DBAs, MySQL, Percona Software
In this blog post, we’ll find out how to use Percona XtraBackup on a MySQL instance with a large number of tables. As of Percona Xtrabackup 2.4.5, you are required to have enough open files to open every single InnoDB tablespace in the instance you’re trying to...
by Hrvoje Matijakovic | Nov 29, 2016 | MySQL
Percona announces the GA release of Percona XtraBackup 2.4.5 on November 29th, 2016. You can download it from our download site and from apt and yum repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies...
by Hrvoje Matijakovic | May 23, 2016 | MySQL, Percona Events, Percona Software
Percona is glad to announce the GA release of Percona XtraBackup 2.4.3 on May 23rd, 2016. Downloads are available from our download site and from apt and yum repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for...
by Hrvoje Matijakovic | Apr 1, 2016 | MySQL, Percona Events, Percona Software
Percona is glad to announce the GA release of Percona XtraBackup 2.4.2 on April 1st, 2016. Downloads are available from our download site and from apt and yum repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for...
by Hrvoje Matijakovic | Mar 17, 2016 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona XtraBackup 2.3.4 on March 17th, 2016. Downloads are available from our download site or Percona Software Repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for...
by Hrvoje Matijakovic | Feb 8, 2016 | MySQL
Percona is glad to announce the first release candidate of Percona XtraBackup 2.4.0-rc1 on February 8th 2016. Downloads are available from our download site and from apt and yum repositories. This is a Release Candidate quality release and it is not intended for...
by Jim Doherty | Jun 25, 2015 | MySQL
Oracle was in the news recently with the story of its license revenue declining as much as 17% in the recent quarter. This is blamed on transitioning to the cloud in some publications, but others, such as Bloomberg and TechRepublic, look deeper, seeing open source...
by Matt Griffin | Apr 8, 2015 | Insight for DBAs, MySQL, Percona Live, Percona Software
In April and May, Percona will hold and participate in two OpenStack events: OpenStack Summit. Join our talks at these events in Santa Clara and Vancouver for new insights into the MySQL operations of the core of OpenStack as well as the latest information on MySQL...
by Matt Yonkovit | Apr 6, 2015 | MySQL, Percona Services
Every day hundreds of millions of dollars are wasted by allowing improperly tuned or misconfigured systems, misunderstood infrastructure, and inefficient IT operations to live and thrive in data centers around the globe. There are both direct and indirect costs...
by Michael Coburn | Apr 3, 2015 | MySQL
On a recent engagement I worked with a customer who makes extensive use of UUID() values for their Primary Key and stores it as char(36), and their row count on this example table has grown to over 1 billion rows. The table is INSERT-only (no UPDATEs or DELETEs), and...
by Hrvoje Matijakovic | Mar 31, 2015 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona XtraBackup 2.2.10 on March 31, 2015. Downloads are available from our download site or Percona Software Repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for...
by Muhammad Irfan | Mar 16, 2015 | MySQL, Percona Services
One of our Percona Support customers recently reported that Percona XtraBackup failed with a page corruption error on an InnoDB table. The customer thought it was a problem or bug in the Percona XtraBackup tool. After investigation we found that an InnoDB page was...
by Fernando Laudares Camargos | Feb 20, 2015 | Insight for DBAs, MySQL, Percona Software
This past week was marked by a series of personal findings related to the use of Global Transaction IDs (GTIDs) on Galera-based clusters such as
by Stephane Combaudon | Feb 19, 2015 | MySQL
In a previous post, titled “Multi-threaded replication with MySQL 5.6: Use GTIDs,” I explained that using GTID replication is almost a requirement when using MySQL 5.6 MTS. Let’s see now how to perform the day-to-day operations when MTS and GTIDs are...
by Hrvoje Matijakovic | Jan 14, 2015 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona XtraBackup 2.2.8 on January 14, 2015. Downloads are available from our download site or Percona Software Repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for...
by Muhammad Irfan | Dec 9, 2014 | Insight for DBAs, MySQL
In MySQL 5.6 Oracle introduced a Transportable Tablespace feature (copying tablespaces to another server) and Percona Server adopted it for partial backups which means you can now take individual database or table backups and your destination server can be a vanilla...
by Tushar Katarki | Nov 1, 2014 | Insight for DBAs, MySQL, Percona Software
MySQL database usage is popular in OpenStack. Core OpenStack services for Compute (Nova), Storage (Cinder), Neutron (Networking), Image (Glance) and Identity (Keystone) all use MySQL database. MySQL – as the world’s most popular database, runs inside OpenStack...
by Tom Diederich | Oct 15, 2014 | Insight for DBAs, MySQL, Percona Software
Founded in 1998, Rackspace has evolved over the years to address the way customers are using data – and more specifically, databases. The San Antonio-based company is fueling the adoption of cloud computing among organizations large and small. Today Rackspace is...
by Hrvoje Matijakovic | Oct 6, 2014 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona XtraBackup 2.2.5 on October 2, 2014. Downloads are available from our download site here and Percona Software Repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for...
by Fernando Laudares Camargos | Aug 26, 2014 | Insight for DBAs, MySQL, Percona Services, Percona Software
The need to have multiple instances of MySQL (the well-known mysqld process) running in the same server concurrently in a transparent way, instead of having them executed in separate containers/virtual machines, is not very common. Yet from time to time the Percona...
