lefred's blog


There Are 10 Types of People in the World....

MySQL 8.0: if I should optimize only one query on my application, which one should it be ?

Answering this question is not easy. Like always, the best response is “it depends” ! But let’s try to give you all the necessary info the provide the most accurate answer. Also, may be fixing one single query is not enough and looking for that specific statement will lead in finding multiple problematic statements. The most consuming one The first … Read More


Migrate from a single MySQL Instance to MySQL InnoDB Cluster using CLONE plugin

When somebody wants to migrate from a single MySQL instance to a full HA solution using MySQL InnoDB Cluster, the best solution to reduce the downtime is to use asynchronous replication and switch database only once at a certain point in time when everything is ready. This is almost what I explained already in this post. The most difficult part … Read More


MySQL InnoDB Cluster, automatic provisioning, firewall and SELinux

You may have noticed that in many of my demos, I disable firewall and SELinux (I even use –initialize-insecure sometimes 😉 ). This is just to make things easier… But in fact enabling iptables and SELinux are not complicated.


MySQL 8.0.17 and Drupal 8.7

From Drupal’s website, we can see that now the support of MySQL 8 is ready. I just tested it and it works great ! The only restriction is related to PHP and the support for the new authentication method in php-mysqlnd. In this previous post, I was happy because it was included in PHP 7.2.8, but this has been reverted … Read More


Create an Asynchronous MySQL Replica in 5 minutes

I have already posted some time ago a post related to the same topic (see here). Today, I want to explain the easiest way to create an asynchronous replica from an existing MySQL instance, that this time has already data !


recent
categories