EmergencyEMERGENCY? Get 24/7 Help Now!

Scaling Percona XtraDB Cluster with ProxySQL in Kubernetes

 | June 16, 2016 |  Posted In: MySQL

Percona XtraDB Cluster Reference Architecture

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: MySQL

Percona XtraDB Cluster Reference Architecture

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

Percona XtraDB Cluster Reference Architecture

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

What is a big innodb_log_file_size?

 | May 31, 2016 |  Posted In: InnoDB, MySQL

big innodb_log_file_size

In this post, we’ll discuss what constitutes a big innodb_log_file_size, and how it can affect performance. In the comments for our post on Percona Server 5.7 performance improvements, someone asked why we use innodb_log_file_size=10G with an indication that it might be too big? In my previous post (https://www.percona.com/blog/2016/05/17/mysql-5-7-read-write-benchmarks/), the example used innodb_log_file_size=15G. Is that too big? Let’s […]

Read More

Fixing MySQL scalability problems with ProxySQL or thread pool

 | May 19, 2016 |  Posted In: MySQL

Fixing MySQL scalability problems

In this blog post, we’ll discuss fixing MySQL scalability problems using either ProxySQL or thread pool. In the previous post I showed that even MySQL 5.7 in read-write workloads is not able to maintain throughput. Oracle’s recommendation to play black magic with innodb_thread_concurrency and innodb_spin_wait_delay doesn’t always help. We need a different solution to deal with this scaling problem. All […]

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

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

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’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.