Monthly Archives - May 2016

pt-online-schema-change (if misused) can’t save the day

GTID replication

In this blog post we’ll discuss pt-online-schema-change, and how to correctly use it.
Always use pt-osc?
Altering large tables can be still a problematic DBA task, even now after we’ve improved Online DDL features in MySQL 5.6 and 5.7. Some ALTER types are still not online, or sometimes just too expensive to execute on busy production master.
So […]

Read more

Webinar Thursday May 26: Troubleshooting MySQL hardware resource usage

Join Sveta on Thursday, May 26, 2016, at 10 am PDT (UTC-7) for her webinar Troubleshooting MySQL hardware resource usage.

MySQL does not just run on its own. It stores data on disk, and stores data and temporarily results in memory. It uses CPU resources to perform operations, and a network to communicate with its clients.
In […]

Read more

Take Percona’s one-click high availability poll

high availability

Wondering what high availability (HA) solutions are most popular? Take our high availability poll below!
HA is always a hot topic. The reality is that if your data is not available, your customers cannot do business with you. In fact, estimates show the average cost of downtime is about $5K per minute. With an average […]

Read more

Percona disabling TLSv1.0 May 31st 2016

As of May 31st, 2016, we will be disabling TLSv1.0 support on,, etc.
This is ahead of the PCI changes that will affect the June 30th 2016 deprecation the TLSv1.0 protocol. (PDF)
What does this mean for you the user?
Based on analysis of our IDS logs, this will affect around 6.32% of requests. As of […]

Read more

Percona XtraBackup 2.4.3 is now available

Percona XtraBackup 2.4.3

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 companies with large data sets and mission-critical applications that cannot tolerate long periods […]

Read more

Introduction to Troubleshooting Performance – Troubleshooting Slow Queries webinar: Q & A

InnoDB Troubleshooting

In this blog, I will provide answers to the Q & A for the Troubleshooting Slow Queries webinar.
First, I want to thank you for attending the April 28 webinar. The recording and slides for the webinar are available here. Below is the list of your questions that I wasn’t able to answer during the webinar, with […]

Read more

Percona XtraDB Cluster 5.6.29-25.15 is now available

Percona XtraDB Cluster

Percona is glad to announce the new release of Percona XtraDB Cluster 5.6 on May 20, 2016. Binaries are available from the downloads area or our software repositories.
Percona XtraDB Cluster 5.6.29-25.15 is now the current release, based on the following:

Percona Server 5.6.29-76.2
Galera Replicator 3.15
Codership wsrep API 25.15

All of Percona software is open-source and free, and all […]

Read more

Fixing MySQL scalability problems with ProxySQL or thread pool

Fixing MySQL scalability problems

In this blog post, we’ll discuss fixing MySQL scalability problems using either ProxySQL or thread pool.
In the previous post I showed that even MySQL 5.7 in read-write workloads is not able to maintain throughput. Oracle’s recommendation to play black magic with
innodb_thread_concurrency and
innodb_spin_wait_delay doesn’t always help. We need a different solution to deal with this scaling problem.
All the […]

Read more

Webinar Tuesday, May 24: Understanding how your MongoDB schema affects scaling, and when to consider sharding for help

Please join David Murphy on Tuesday, May 24 at 10 am PDT (UTC-7) as he presents “Understanding how your MongoDB schema affects scaling, and when to consider sharding for help.”

David will discuss the pros and cons of a few MongoDB schema design patterns on a stand-alone machine, and then will look at how sharding […]

Read more