EmergencyEMERGENCY? Get 24/7 Help Now!

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

 | May 24, 2016 |  Posted In: Insight for DBAs, MySQL, Percona Toolkit, Replication

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 […]

Read More

Take Percona’s one-click high availability poll

 | May 23, 2016 |  Posted In: High-availability

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

 | May 23, 2016 |  Posted In: Events and Announcements

As of May 31st, 2016, we will be disabling TLSv1.0 support on www.percona.com, repo.percona.com, 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. […]

Read More

Percona XtraBackup 2.4.3 is now available

 | May 23, 2016 |  Posted In: Events and Announcements, MySQL, Percona Software, Percona XtraBackup

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

 | May 20, 2016 |  Posted In: EXPLAIN, MySQL, Technical Webinars

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

 | May 20, 2016 |  Posted In: MySQL

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 […]

Read More

Fixing MySQL scalability problems with ProxySQL or thread pool

 | May 19, 2016 |  Posted In: MySQL

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 […]

Read More

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

 | May 19, 2016 |  Posted In: MongoDB, Performance Schema

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