Author - Frederic Descamps

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

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 hands-on […]

Read more

Read-write split routing in MaxScale

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:

Shell

[Splitter Service]
type=service
router=readwritesplit
servers=percona1, percona2
max_slave_replication_lag=30
user=maxscale
passwd=264D375EC77998F13F4D0EC739AABAD4

1234567

[Splitter Service]type=servicerouter=readwritesplitservers=percona1, percona2max_slave_replication_lag=30user=maxscalepasswd=264D375EC77998F13F4D0EC739AABAD4

This router module is designed to spread […]

Read more

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 documents […]

Read more

How MaxScale monitors servers

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:

Shell

[Replication Monitor]
type=monitor
module=mysqlmon
servers=percona1, percona2, percona3
user=maxscale
passwd=264D375EC77998F13F4D0EC739AABAD4
monitor_interval=1000
script=/usr/local/bin/failover.sh
events=master_down

123456789

[Replication Monitor]type=monitormodule=mysqlmonservers=percona1, percona2, percona3user=maxscalepasswd=264D375EC77998F13F4D0EC739AABAD4monitor_interval=1000script=/usr/local/bin/failover.shevents=master_down

But what are […]

Read more

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

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:

Three MySQL servers, […]

Read more

MySQL connection using SSL… or not ?

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 interactive client, […]

Read more

Proxy Protocol and Percona XtraDB Cluster: A Quick Guide

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

Shell

listen 3307-active-passive-writes 0.0.0.0:3307
[…]

Read more

MySQL & Friends Devroom FOSDEM 2015

You can already feel the cold of February coming slowly… you can also smell waffles, fries and see a large amount of beards walking around with laptops… you are right, FOSDEM is coming! And as every year, the MySQL Community will also be present! For the 4th year in a row, I’ll perpetuate the […]

Read more

MariaDB: Selective binary logs events

In the first post in a series on MariaDB features we find interesting, we begin with selectively skipping replication of binlog events. This feature is available on MariaDB 5.5 and 10.
By default when using MySQL’s standard replication, all events are logged in the binary log and those binary log events are replicated to all slaves […]

Read more

Location for InnoDB tablespace in MySQL 5.6.6

There is one new feature in MySQL 5.6 that didn’t get the attention it deserved (at least from me 😉 ) : “DATA DIRECTORY” for InnoDB tables.
This is implemented since MySQL 5.6.6 and can be used only at the creation of the table. It’s not possible to change the DATA DIRECTORY with an ALTER […]

Read more