EmergencyEMERGENCY? Get 24/7 Help Now!

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

Docker automatic MySQL slave propagation

 | June 21, 2016 |  Posted In: Docker, MySQL, Percona XtraDB Cluster

MySQL Group Replication

In this post, we’ll discuss Docker automatic MySQL slave propagation for help with scaling. In my previous posts on the Docker environment, I covered Percona XtraDB Cluster. Percona XtraDB Cluster can automatically scale by conveniently adding new nodes using the highly automated State Snapshot Transfer. State Snapshot Transfer allows a new node to copy data […]

Read More

Scaling Percona XtraDB Cluster with ProxySQL in Kubernetes

 | June 16, 2016 |  Posted In: MySQL


How do you scale Percona XtraDB Cluster with ProxySQL in Kubernetes? In my previous post I looked how to run Percona XtraDB Cluster in a Docker Swarm orchestration system, and today I want to review how can we do it in the more advanced Kubernetes environment. There are already some existing posts from Patrick Galbraith […]

Read More