EmergencyEMERGENCY? Get 24/7 Help Now!

MySQL Replication Troubleshooting: Q & A

 | September 8, 2016 |  Posted In: MySQL, Technical Webinars

Solving Database Performance Issues

In this blog, I will provide answers to the Q & A for the MySQL Replication Troubleshooting webinar. First, I want to thank everybody for attending the August 25 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 […]

Read More

MHA Quick Start Guide

 | September 2, 2016 |  Posted In: High-availability, MySQL

MHA

MHA (Master High Availability Manager and tools for MySQL) is one of the most important pieces of our managed services. When properly set up, it can check replication health, move writer and reader virtual IPs, perform failovers, and have its output constantly monitored by Nagios. Is it easy to deploy and follows the KISS (Keep It […]

Read More

MySQL Sharding with ProxySQL

 | August 30, 2016 |  Posted In: MySQL

MySQL Sharding with ProxySQL

This article demonstrates how MySQL sharding with ProxySQL works. Recently a colleague of mine asked me to provide a simple example on how ProxySQL performs sharding. In response, I’m writing this short tutorial in the hope it will illustrate ProxySQL’s sharding functionalities, and help people out there better understand how to use it. ProxySQL is […]

Read More

PostgreSQL Day at Percona Live Amsterdam 2016

 | August 25, 2016 |  Posted In: MySQL

PostgreSQL Day

Introducing PostgreSQL Day at Percona Live Europe, Amsterdam 2016. As modern open source database deployments change, often including more than just a single open source database, Percona Live has also changed. We changed our model from being a purely MySQL-focused conference (with variants) to include a significant amount of MongoDB content. We’ve also expanded our […]

Read More

How to stop offending queries with ProxySQL

 | August 23, 2016 |  Posted In: MySQL, ProxySQL

halt_man

This blog discusses how to find and address badly written queries using ProxySQL. All of us are very good in writing good queries. We know this to always be true! 😉 But sometimes a bad query escapes our control and hits our database. There is the new guy, the probie, who just joined the company […]

Read More

Percona Server 5.7.14-7 is now available

 | August 23, 2016 |  Posted In: Events and Announcements, MySQL, Percona Server, Percona Software, TokuDB

percona server 5.6.30-76.3

Percona announces the GA release of Percona Server 5.7.14-7 on August 23, 2016. Download the latest version from the Percona web site or the Percona Software Repositories. Based on MySQL 5.7.14, including all the bug fixes in it, Percona Server 5.7.14-7 is the current GA release in the Percona Server 5.7 series. Percona’s provides completely open-source and free […]

Read More

Query rewrite plugin: scalability fix in MySQL 5.7.14

 | August 22, 2016 |  Posted In: Benchmarks, MySQL

query rewrite plugin

In this post, we’ll look at a scalability fix for issues the query rewrite plugin had on performance. Several months ago, Vadim blogged about the impact of a query rewrite plugin on performance. We decided to re-evaluate the latest release of 5.7(5.7.14), which includes fixes for this issue. I reran tests for MySQL 5.7.13 and 5.7.14 using the […]

Read More

Percona Server 5.5.51-38.1 is now available

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

percona server 5.6.30-76.3

Percona announces the release of Percona Server 5.5.51-38.1 on August 19, 2016. Based on MySQL 5.5.51, including all the bug fixes in it, Percona Server 5.5.51-38.1 is now the current stable release in the 5.5 series. Percona Server is open-source and free. You can find release details of the release in the 5.5.51-38.1 milestone on Launchpad. […]

Read More

Small innodb_page_size as a performance boost for SSD

 | August 10, 2016 |  Posted In: Benchmarks, InnoDB, MySQL

performance boost for SSD

In this blog post, we’ll discuss how a small innodb_page_size can create a performance boost for SSD. In my previous post Testing Samsung storage in tpcc-mysql benchmark of Percona Server I compared different Samsung devices. Most solid state drives (SSDs) use 4KiB as an internal page size, and the InnoDB default page size is 16KiB. I wondered […]

Read More

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.