Docker 1.0 & RedHat 7

18 June 2014 in Databases, Docker, Hi-Tech, Linux, Red Hat, SQL

I really like this kind of news, new versions of docker and RedHat: Docker 1.0: this is the first stable version after more than one year of development. This version is production ready and I will start using it asap. RedHat 7: this is a good news as the version 6 started to be a little bit old now. What’s new? MariaDB replace MySQL \o/ Docker integrated systemd XFS by default Kernel 3.

Mysqlnd: replace your old php mysql client library by mysqlnd

5 May 2014 in Databases, Debian, Hi-Tech, Linux, SQL

As you may know, I’m using and loving MariaDB. A colleague recently introduced me the benefits of the php built-in MySQL/MariaDB library (shame on me, I never heard of it). Here are the informations you can find from it on the MySQL website: The mysqlnd library is highly optimized for and tightly integrated into PHP. The MySQL Client Library cannot offer the same optimizations because it is a general-purpose client library.

PRM: automatic MySQL/MariaDB replication managment

25 April 2014 in Databases, Debian, HA, Hi-Tech, Linux, Red Hat, SQL

The Percona replication manager (PRM) is a framework using the Linux HA resource agent Pacemaker that manages replication and provides automatic failover. This covers the installation of the framework on a set of servers. The PRM framework is made of 4 components: Corosync, Pacemaker, the mysql resource agent and MySQL itself. It’s easy to setup, better if you already know how to use Pacemaker and it works like a charm. In fact it setup a master and x slaves.

MariaDB 10 is out!

1 April 2014 in Hi-Tech, Linux, SQL

And finally MariaDB 10 is out! I’m exited to finish my book about it. Here are the news: Replication MariaDB 10 sets a new standard in performance. It is many times faster than previous generations of MariaDB and especially legacy database MySQL thanks to new features including parallel replication and a further advanced group commit. Also, the replication slaves are now crash-safe. It’s also now possible to replicate data from multiple master servers giving a complete view of the distributed data across big datasets for real-time analytical purposes via the multi-source replication feature.

HAProxy: a powerful load balancer

10 March 2014 in Debian, HA, Hi-Tech, Linux, SQL

I recently played with HAProxy and discovered that I’ve never made a documentation regarding this fantastic software. So if you don’t know what HAProxy is, it’s a load balancer working on layer 7 and specialized for http protocol. It is able to handle sticky sessions which is really powerful. More than that, it has a small footprint and can work under a high load traffic. Here is my documentation.

FOSDEM 2014: day 1

4 February 2014 in Events, Hi-Tech, SQL

Once again the FOSDEM has given awesome talks ! This years I was more focused to SQL and NOSQL databases. I wanted to also see Puppet related conferences, but they were full like the last year. Getting started with MySQL Performance Schema First of all, I started with a MySQL Performance Schema presentation : http://dimitrik.free.fr/mysqltechday_2013_10/MySQL_PFS_2013-dim.pdf I saw that I had underestimated the power of Performance schema ! We can for example see iowaits and waiting time on tables files.

MariaDB: Writing my first book

31 January 2014 in Books, Hi-Tech, Others, Private life, SQL

Some of you may already know that I’ve been contacted by Packt Publishing to write a book. As every aware persons asked me why I was contacted, here is the story : When I was working for Linagora, I gave a training on advanced usage on MySQL/MariaDB. Unfortunately there weren’t slides on that subject at this moment and I had to make them all. That’s what I did and made an unbranded version for me as well.