Buy Percona ServicesBuy Now!

Webinar Thursday, June 9: Troubleshooting MySQL configuration issues

 | June 6, 2016 |  Posted In: MySQL

MongoDB Schema Design

Please join us on Thursday June 9, at 10:00 am PDT (UTC-7) for the webinar Troubleshooting MySQL configuration issues. MySQL Server is highly tunable. It has hundreds of configuration options which provide great tuning abilities and, at the same time, can be the source of various issues. In this webinar you will learn which types of options […]

Read More

Percona Server 5.7.12-5 is now available

 | June 6, 2016 |  Posted In: Events and Announcements, MySQL, Percona Server for MySQL, Percona Software, TokuDB

percona server for MySQL

Percona is glad to announce the GA release of Percona Server 5.7.12-5 on June 6, 2016. Download the latest version from the Percona web site or from the Percona Software Repositories. Based on MySQL 5.7.12, including all the bug fixes in it, Percona Server 5.7.12-5 is the current GA release in the Percona Server 5.7 series. All of […]

Read More

EL5 and why we’ve had to enable TLSv1.0 again

 | June 6, 2016 |  Posted In: MySQL


We have had to revert back to TLSv1.0. If you saw my previous post on TLSv1.0 (, you’ll know I  wanted to deprecate TLSv1.0 well ahead of PCI’s changes. We made the changes May 31st. Unfortunately, it has become apparent that EL 5, which is in the final phases of End Of Life, does not support TLSv1.1 […]

Read More

MySQL 5.7 By Default 1/3rd Slower Than 5.6 When Using Binary Logs

 | June 3, 2016 |  Posted In: MySQL

binary logs make MySQL 5.7 slower

Researching a performance issue, we came to a startling discovery: MySQL 5.7 + binlogs is by default 37-45% slower than MySQL 5.6 + binlogs when otherwise using the default MySQL settings. Test server MySQL versions used: i7, 8 threads, SSD, Centos 7.2.1511 mysql-5.6.30-linux-glibc2.5-x86_64 mysql-5.7.12-linux-glibc2.5-x86_64 mysqld –options: --no-defaults --log-bin=mysql-bin --server-id=2 Run details: Sysbench version 0.5, 4 threads, socket file connection […]

Read More

Galera warning “last inactive check”

 | June 2, 2016 |  Posted In: Percona XtraDB Cluster, XtraDB Cluster

MySQL high availability

In this post, we’ll discuss the Galera warning “last inactive check” and what it means. Problem I’ve been working with Percona XtraDB Cluster quite a bit recently, and have been investigating various warnings. I came across this one today: [Warning] WSREP: last inactive check more than PT1.5S ago (PT1.51811S), skipping check This warning is related […]

Read More

Percona Live Europe call for papers is now open!

 | June 2, 2016 |  Posted In: Percona Live

Percona Live Europe Call for Papers

The Percona Live Europe 2016 call for papers is now officially open! We’re looking forward to seeing you in Amsterdam this October 3-5, and hearing your speak! Ask yourself “Do I have…”: Fresh ideas? Enlightening case studies? Insight on best practices? In-depth technical knowledge? If the answer to any of these is “YES,” then you need […]

Read More

Why use provisioned IOPS volumes for AWS databases?

 | June 1, 2016 |  Posted In: MySQL

In this blog, we’ll use some test results to look at the rationale for using provisioned IOPS volumes for AWS databases. One piece of advice you often hear running MySQL, MongoDB or other databases in the AWS EC2 environment is that you should use volumes with provisioned IOPs. This kind of makes sense on the “marketing” […]

Read More

MongoDB Administration Checklist for MySQL DBAs

 | June 1, 2016 |  Posted In: MongoDB, MySQL

MongoDB Adminstration Checklist

In this blog, I discuss a MongoDB administration checklist designed to help MySQL DBAs. If you are MySQL DBA, starting MongoDB administration is not always an easy transition. Although most of the concepts and even implementation are similar, the commands are different. The following table outlines the typical MySQL concepts and DBA tasks (on the […]

Read More

Embracing MongoRocks

 | June 1, 2016 |  Posted In: MongoDB

This blog post discusses Percona’s future plans for TokuMX, PerconaFT, and MongoRocks for MongoDB 3.2 and later releases. At Percona, we focus on providing the best solution for our customers, rather than falling into “big ego,” “not invented here” or “sunk cost fallacy” messages. We have limited engineering resources and want to concentrate on the things […]

Read More