Setting up ProxySQL 1.4 with MySQL 5.7 Group Replication

January 9, 2018

Tweet Lire cet article en français There are 3 pillars for a database architecture: Monitoring Backup / Restore process High Availability This blog post is about database High Availability; more precisely about one of the best combo of the moment :   MySQL 5.7 Group Replication : the only native HA solution for MySQL, it’s a Single/Multi-master update […]


How to Get MySQL?

July 24, 2017

When starting a new project, it is generally recommended to go on the most recent version of MySQL, to take advantage of the latest features but also (mainly?) to be sure to be up to date with the security patches.

This blog post centralizes the various URLs where to download the world’s most popular open source database.


MySQL first Public Releases

July 19, 2017

I regularly meet with MySQL customers and I’m still a little surprised to see critical applications running on “not really” recent versions (to put it mildly) 🙂

The good news is that obviously old versions of MySQL are sufficiently stable and powerful to run the modern business. However, even if I understand that it is sometimes appropriate to freeze all layers of an architecture, it is often a shame not to take advantage of the latest improvements from a performance, stability, security point of view and obviously for the new features that the latest GA provides :


30 mins with MySQL Query Rewriter

February 25, 2016

Sometime DBAs have to deal with problematic queries and cannot tackle the problem at the source (problematic queries from ORMs, third party apps,… or source unknown…).
MySQL 5.7 provides a pre and post parse query rewrite APIs where users can write their own plug-ins.
With the post-parse query plugin, you can rewrite problematic queries without the need to make application changes, add hints, modify join order…


30 mins with JSON in MySQL

November 17, 2015

MySQL 5.7 is GA and has over than 150 new features. One of them is a Native JSON Data Type and JSON Functions: “Allows for efficient and flexible storage, search and manipulation of schema-less data. Enhancements include a new internal binary format, support for easy integration within SQL, and index management on the JSON Documents using generated columns”.


Free ebooks on Packt Publishing website

February 28, 2015

Tweet   Packt Publishing started a Free Learning Campaign by providing a free ebook everyday till 6th March 2015. How ? Follow this link: