EmergencyEMERGENCY? Get 24/7 Help Now!

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

wsrep-stages

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

Scaling Percona XtraDB Cluster with ProxySQL in Docker Swarm

 | June 14, 2016 |  Posted In: Docker, MySQL

wsrep-stages

In this post, we’ll look at scaling Percona XtraDB Cluster with ProxySQL in Docker Swarm. In my previous post, I showed how to employ Percona XtraDB Cluster on multiple nodes in a Docker network. The intention is to be able to start/stop nodes and increase/decrease the cluster size dynamically. This means that we should track running […]

Read More

RocksDB from Docker containers

 | June 13, 2016 |  Posted In: Docker, MongoDB

MySQL Group Replication

This post will discuss how to get RocksDB from Docker containers to use with Percona Server for MongoDB. With our Percona Server for MongoDB 3.2 release, we made RocksDB a first class citizen. With this newly-available engine, we want to make it easy for everybody interested to try it. So it is now available in docker […]

Read More

Running Percona XtraDB Cluster in a multi-host Docker network

 | June 10, 2016 |  Posted In: Docker, MySQL

wsrep-stages

In this post, I’ll discuss how to run Percona XtraDB Cluster in a multi-host Docker network. With our release of Percona XtraDB Cluster 5.7 beta, we’ve also decided to provide Docker images for both Percona XtraDB Cluster 5.6 and Percona XtraDB Cluster 5.7. Starting one node is very easy, and not that different from starting Percona Server […]

Read More

Severe performance regression in MySQL 5.7 crash recovery

 | June 7, 2016 |  Posted In: MySQL

MySQL 5.7 Crash Recovery

In this post, we’ll discuss some insight I’ve gained regarding severe performance regression in MySQL 5.7 crash recovery. Working on different InnoDB log file sizes in my previous post: What is a big innodb_log_file_size? I tried to understand how we can make InnoDB crash recovery faster, but found a rather surprising 5.7 crash recovery regression. Basically, […]

Read More