EmergencyEMERGENCY? Get 24/7 Help Now!

Group Replication: Shipped Too Early

 | February 15, 2017 |  Posted In: Group Replication, High-availability, MySQL, Percona XtraDB Cluster

Group Replication

This blog post is my overview of Group Replication technology. With Oracle clearly entering the “open source high availability solutions” arena with the release of their brand new Group Replication solution, I believe it is time to review the quality of the first GA (production ready) release. TL;DR: Having examined the technology, it is my […]

Read More

Docker Images for Percona Server for MySQL Group Replication

 | February 15, 2017 |  Posted In: Group Replication, MySQL

Group Replication

In this blog post, we’ll point to a new Docker image for Percona Server for MySQL Group Replication. Our most recent release of Percona Server for MySQL (Percona Server for MySQL 5.7.17) comes with Group Replication plugins. Unfortunately, since this technology is very new, it requires some fairly complicated steps to setup and get running. To help […]

Read More

MyRocks Docker images

 | September 6, 2016 |  Posted In: Docker, MySQL


In this post, I’ll point you to MyRocks Docker images with binaries, allowing you to install and play with the software. During the @Scale conference, Facebook announced that MyRocks is mature enough that it has been installed on 5% of Facebook’s MySQL slaves. This has saved 50% of the space on these slaves, which allows them […]

Read More

ProxySQL 1.2.1 GA Release

 | August 18, 2016 |  Posted In: MySQL

The GA release of ProxySQL 1.2.1 is available. You can get it from https://github.com/sysown/proxysql/releases. There are also Docker images for Release 1.2.1: https://hub.docker.com/r/percona/proxysql/. ProxySQL is a high-performance proxy, currently for MySQL and its forks (like Percona Server and MariaDB). It acts as an intermediary for client requests seeking resources from the database. ProxySQL was created for DBAs by […]

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

tpcc-mysql benchmark tool: less random with multi-schema support

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

In this blog post, I’ll discuss changes I’ve made to the tpcc-mysql benchmark tool. These changes make it less random and support multi-schema. This post might only be interesting to performance researchers. The tpcc-mysql benchmark to is what I use to test different hardware (as an example, see my previous post: https://www.percona.com/blog/2016/07/26/testing-samsung-storage-in-tpcc-mysql-benchmark-percona-server/). The first change is support for multiple schemas, […]

Read More

Testing Docker multi-host network performance

 | August 3, 2016 |  Posted In: Docker, MySQL

MySQL Group Replication

In this post, I’ll review Docker multi-host network performance. In a past post, I tested Docker network. The MySQL Server team provided their own results, which are in line with my observations. For this set of tests, I wanted to focus more on Docker networking using multiple hosts. Mostly because when we set up a high availability […]

Read More

Testing Samsung storage in tpcc-mysql benchmark of Percona Server

 | July 26, 2016 |  Posted In: Benchmarks, MySQL

tpcc-mysql benchmark

This blog post will detail the results of Samsung storage in tpcc-mysql benchmark using Percona Server. I had an opportunity to test different Samsung storage devices under tpcc-mysql benchmark powered by Percona Server 5.7. You can find a summary with details here https://github.com/Percona-Lab-results/201607-tpcc-samsung-storage/blob/master/summary-tpcc-samsung.md I have in my possession: Samsung 850 Pro, 2TB: This is a SATA device and […]

Read More

The need for parallel crash recovery in MySQL

 | June 27, 2016 |  Posted In: MySQL

parallel crash recovery in MySQL

In this blog, I will discuss how parallel crash recovery in MySQL benefits several processes. I recently filed an Oracle feature request to make crash recovery faster by running in multiple threads. This might not seem very important, because MySQL does not crash that often. When it does crash, however, crash recovery can take 45 […]

Read More