EmergencyEMERGENCY? Get 24/7 Help Now!

Percona Server 5.5.49-37.9 is now available

 | May 19, 2016 |  Posted In: Events and Announcements, MySQL, Percona Server for MySQL, Percona Software

Replace MySQL with Percona Server

Percona is glad to announce the release of Percona Server 5.5.49-37.9 on May 19, 2016. Based on MySQL 5.5.49, including all the bug fixes in it, Percona Server 5.5.49-37.9 is now the current stable release in the 5.5 series. Percona Server is open-source and free. Details of the release can be found in the 5.5.49-37.9 […]

Read More

Where is the MySQL 5.7 root password?

 | May 18, 2016 |  Posted In: MySQL

Using Vault with MySQL

In this blog, we’ll discuss how to find the MySQL 5.7 root password. While new MySQL software security features are always welcome, they can impact use and performance. Now by default, MySQL 5.7 creates a password for the root user (among other changes) so the installation itself can be considered secure. It’s a necessary change, […]

Read More

MySQL 5.7 read-write benchmarks

 | May 17, 2016 |  Posted In: MySQL

MySQL 5.7 read-write benchmarks

In this post, we’ll look at the results from some MySQL 5.7 read-write benchmarks. In my past blogs I’ve posted benchmarks on MySQL 5.5 / 5.6 / 5.7 in OLTP read-only workloads. For example: MySQL 5.7 sysbench OLTP read-only results: is MySQL 5.7 really faster? MySQL 5.7 primary key lookup results: is it really faster? ProxySQL […]

Read More

MySQL “Got an error reading communication packet” errors

 | May 16, 2016 |  Posted In: MySQL

Galera Error Failed to Report Last Committed

In this blog post, we’ll discuss the possible reasons for MySQL “Got an error reading communication packet” errors, and how to address them. In Percona’s managed services, we often receive customer questions on communication failure errors – where customers are faced with intermittent “Got an error reading communication packets” messages. I thought this topic deserved […]

Read More

Benchmark MongoDB with sysbench

 | May 13, 2016 |  Posted In: Benchmarks, MongoDB

Benchmark MongoDB with sysbench

In this blog post, we’ll discuss how to benchmark MongoDB with sysbench. In an earlier post, I mentioned our use of sysbench-mongodb (via this fork) to run benchmarks of MongoDB servers. I now want to share our work extending sysbench to make it work with MongoDB. If you’re not familiar with sysbench, it’s a great project developed […]

Read More

ProxySQL versus MaxScale for OLTP RO workloads

 | May 12, 2016 |  Posted In: MySQL

ProxySQL versus MaxScale for OLTP RO workloads

In this blog post, we’ll discuss ProxySQL versus MaxScale for OLTP RO workloads. Continuing my series of READ-ONLY benchmarks (you can find the other posts here: https://www.percona.com/blog/2016/04/07/mysql-5-7-sysbench-oltp-read-results-really-faster/ and https://www.percona.com/blog/2016/03/28/mysql-5-7-primary-key-lookup-results-is-it-really-faster), in this post I want to see how much overhead a proxy adds. At this In my opinion, there are only two solid proxy software options for MySQL […]

Read More

Quick start MySQL testing using Docker (on a Mac!)

 | May 11, 2016 |  Posted In: Docker, MySQL

In this post, we’ll discuss how you can quick start MySQL testing using Docker, specifically in a Mac environment. Like a lot of people, I’m hearing a lot about Docker and it’s got me curious. The Docker ecosystem seems to be moving quickly, however, and simple “getting started” or “how-to” type articles that are easy […]

Read More

Query Rewrite plugin can harm performance

 | May 10, 2016 |  Posted In: MySQL

Query Rewrite plugin can harm performance

In this blog post, we’ll discuss how the Query Rewrite plugin can harm performance. MySQL 5.7 comes with Query Rewrite plugin, which allows you to modify queries coming to the server. (You can view the details here: https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin.html.) It is based on the audit plugin API, and unfortunately it suffers from serious scalability issues (which seems […]

Read More

Percona Server 5.7 parallel doublewrite

and  | May 9, 2016 |  Posted In: MySQL

Percona Server 5.7 parallel doublewrite

In this blog post, we’ll discuss the ins and outs of Percona Server 5.7 parallel doublewrite. After implementing parallel LRU flushing as described in the previous post, we went back to benchmarking. At first, we tested with the doublewrite buffer turned off. We wanted to isolate the effect of the parallel LRU flusher, and the results validated […]

Read More