EmergencyEMERGENCY? Get 24/7 Help Now!

Percona Live: Advanced Percona XtraDB Cluster in a Nutshell, La Suite

and  | April 6, 2016 |  Posted In: MySQL, Percona Live

12 Days Until Percona Live

This blog post will discuss what is necessary of the Percona Live  Advanced Percona XtraDB Cluster tutorial. Percona Live 2016 is happening in April! If you are attending, and you are registered to the Percona XtraDB Cluster (Galera) tutorial presented by Kenny and myself, please make sure that you: Bring your laptop, this is a […]

Read More

Read-write split routing in MaxScale

 | March 29, 2016 |  Posted In: Maxscale, MySQL

Read-write split routing performance in MaxScale

In this blog post, we’ll discuss read-write split routing in MaxScale. The two previous posts have shown how to setup high availability (HA) with Maxscale using asynchronous replication and how we monitor replication. Now let’s focus on the routing module performing read-write splits. This is our current configuration:

This router module is designed to spread […]

Read More

JSON document fast lookup with MySQL 5.7

 | March 7, 2016 |  Posted In: MySQL

JSON document fast lookup with MySQL 5-7

In this blog post, we’ll discuss JSON document fast lookup with MySQL 5.7. Recently I attended Morgan Tocker’s talk on MySQL 5.7 and JSON at FOSDEM, and I found it awesome. I learned some great information from the talk. Let me share one of them here: a very useful trick if you plan to store JSON […]

Read More

How MaxScale monitors servers

 | March 2, 2016 |  Posted In: High-availability, Maxscale, MySQL

maxscale monitors servers

In this post, we’ll address how MaxScale monitors servers. We saw in the We saw in the previous post how we could deal with high availability (HA) and read-write split using MaxScale. If you remember from the previous post, we used this section to monitor replication:

But what are we monitoring? We are monitoring […]

Read More

High availability with asynchronous replication… and transparent R/W split

 | February 25, 2016 |  Posted In: GTID, High-availability, MariaDB, Maxscale, MySQL

High availability with asynchronous replication

In this post, the first one of a Maxscale series, I describe how to use MariaDB’s MaxScale and MySQL-utilities with MySQL Asynchronous replication. When we talk about high availability with asynchronous replication, we always think about MHA or PRM. But if we want to transparently use the slave(s) for READs, what can we use ? Description: […]

Read More

MySQL connection using SSL… or not ?

 | February 23, 2016 |  Posted In: MySQL

MySQL connection using SSL

In this blog post, we’ll discuss how we can determine if a MySQL connection is using SSL. Since MySQL 5.7.5 the server generates SSL certificates (see auto_generate_certs) by default if compiled with SSL, or uses mysql_ssl_rsa_setup if compiled with YaSSL. But how can we check to see if our MySQL client connection uses SSL ? When using an […]

Read More

Proxy Protocol and Percona XtraDB Cluster: A Quick Guide

 | October 15, 2015 |  Posted In: MySQL, Percona XtraDB Cluster


On September 21st, we released Percona XtraDB Cluster 5.6.25. This is the first PXC release supporting proxy-protocol that has been included in Percona Server since 5.6.25-73.0. With this blog post, I want to promote a new feature that you may have ignored. Let’s start with a description of the use case: Architecture Overview: HAProxy is configured like […]

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.