by Frederic Descamps | Apr 6, 2016 | MySQL, 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... by Frederic Descamps | Mar 29, 2016 | Insight for DBAs, MySQL
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... by Frederic Descamps | Mar 7, 2016 | MySQL
by Frederic Descamps | Mar 2, 2016 | Insight for DBAs, MySQL
In this post, we’ll address how MaxScale monitors servers. We saw in theWe 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... by Frederic Descamps | Feb 25, 2016 | Insight for DBAs, MariaDB, MySQL
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... by Frederic Descamps | Feb 23, 2016 | MySQL
In this blog post, we’ll determine a MySQL connection using SSL… or not.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... by Frederic Descamps | Oct 15, 2015 | MySQL, Percona Software
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... by Frederic Descamps | Oct 27, 2014 | MySQL, Percona Events
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... by Frederic Descamps | Jul 31, 2014 | MariaDB, MySQL, Percona Software
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... by Frederic Descamps | May 28, 2014 | Insight for DBAs, MySQL
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... by Frederic Descamps | Feb 14, 2014 | MySQL
Before Percona XtraBackup 2.1.7 and Percona XtraDB Cluster 5.6.15-25.3, rsync was the only SST method supporting GTID in the way that it was possible to move an asynchronous slave from one Galera node to another one (related bug).Indeed, previous versions of Percona... by Frederic Descamps | Jan 23, 2014 | MySQL, Percona Events
FOSDEM is a free, yearly event that offers open source communities a place to meet, share ideas and collaborate. It takes place in Brussels, Belgium each February.10 years ago now, the first MySQL devroom was organized there by David Axmark, marking the first time... by Frederic Descamps | Nov 6, 2013 | MySQL
As every year in February, in Brussels, the FOSDEM will take place! And as every year, the MySQL Community will also be present! For the 3rd year in a row, I have the honour of organising the MySQL & Friends Devroom.Let’s start with the most important... by Frederic Descamps | Sep 18, 2013 | MySQL, Percona Events
I will be in Prato (Firenze), Italy Thursday and Friday (September 19th and 20th) to deliver 2 presentations at OSS4B: Installing and managing MySQL like a real devops: automation in production Introduction to Percona XtraDB ClusterIf you want to learn about these... by Frederic Descamps | Jul 30, 2013 | MySQL, Percona Live
In the MySQL ecosystem, there is some sort of conference or another all year long. But why are they important?To answer this, we can split the audience into 3 groups:– MySQL Professionnals – MySQL Community Members – MySQL (Future?) UsersDepending on... by Frederic Descamps | Jun 28, 2013 | MySQL, Percona Software
With the last Percona XtraDB Cluster (PXC) release, two major features were added:* a new command to bootstrap the cluster was added to the init script * SST via Xtrabackup now supports Xtrabackup 2.1 featuresIn this post, I want to explain the benefits of these added... by Frederic Descamps | May 29, 2013 | MySQL, Percona Software
If you are using Percona Replication Manager (PRM) with RHEL/CentOS prior to 6.4, upgrading your distribution to 6.4 may break your cluster. In this post I will explain you how to fix your cluster in case it breaks after a distribution upgrade that implies an update... by Frederic Descamps | Jan 29, 2013 | Percona Software
Before version 5.5.28 of Percona XtraDB Cluster, the easiest way was to join the cluster using wsrep_urls in [mysqld_safe] section of my.cnf.So with a cluster of 3 nodes like this :node1 = 192.168.1.1 node2 = 192.168.1.2 node3 = 192.168.1.3we defined the setting like... by Frederic Descamps | Dec 20, 2012 | MySQL, Percona Software
If you are using SElinux, you should know that it’s advised to disable it to avoid issue with PXC. Generally the communication between your nodes doesn’t work properly and a node having SElinux enabled won’t be able to join the cluster.So when a node... by Frederic Descamps | Dec 19, 2012 | MySQL, Percona Software
How easy is it to identify and debug Percona XtraDB Cluster replication problem ?If you are using PXC, you may have already seen in your datadirectory several log files starting with GRA_Those files correspond to a replication failure. That means the slave thread was...