Author on Oracle MySQL Blog
You may have noticed, I started to blog also on the official Oracle MySQL Blog. When I will do so, I will also publish my articles on lefred.be after a short delay. I really invite you to follow the official…
MySQL Shell and storing passwords
If you plan for example to have a bastion host in the cloud to access all your MySQL servers and use only MySQL Shell, the first time you connect to one of the host, you will realize that MySQL Shell…
From MySQL Group Replication to MySQL InnoDB Cluster
I wanted to be brave and I installed MySQL Group Replication manually…. it was painful ! Then I realized that managing those servers and especially deal with MySQL Routers was even more painful ! What are my options now ?…
MySQL: who’s filling my error log?
This morning, a user asked in the MySQL Community Slack if somebody had an idea why the error log was filled up continuously with a warning messages like this one: 2020-07-24T06:54:00.877128Z 46 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ”sha256_password’ is…
MySQL – Keep an eye on your auto_increment values
In MySQL, it’s very common and recommended to you an auto_increment as Primary Key. However that integer can have different types each having their size limitation, and they can also be signed or not. Many people when creating a table…
MySQL 8.0 – Who stopped mysqld and how long did it take ?
In MySQL 8.0.21, we can see who and how mysqld was stopped and when the process ended. Let’s have a look at different scenarios in this article. SHUTDOWN SQL statement The first test is to initiate the shutdown of MySQL…
MySQL 8.0.21: thank you for the contributions
MySQL 8.0.21 has been released today, wooohooo \o/ As usual, this release contains contributions and let me thanks all the contributors on behalf of the MySQL Team. MySQL 8.0.21 includes contributions from Edgars Irmejs, Daniël van Eeden, Jeremy Cole, Wenfeng…
Sysbench 1.0.20 for MySQL 8.0
As proven again very recently by my colleague and friend Dimitri K, with the TPCC “Mystery”, sysbench made by a former colleague and friend Alexey K, is really the recommended framework to benchmark your system. I use sysbench of course…
MySQL 8.0 InnoDB Cluster with WordPress in OCI – part III
With this post we are reaching the end of our journey to HA for WordPress & MySQL 8.0 on OCI. If you have not read the two previous articles, this is just the right time. MySQL 8.0 InnoDB ReplicaSet with…
MySQL 8.0 InnoDB ReplicaSet with WordPress in OCI – part II
This article is the second part of our journey to WordPress and MySQL 8.0 High Availability on OCI. The first part can be read here. We ended part I with one webserver hosting WordPress. This WordPress was connecting locally to…
MySQL 8.0 InnoDB ReplicaSet with WordPress in OCI
Today’s article is again related to WordPress and MySQL 8.0. We will see how we can setup MySQL InnoDB ReplicaSet and configure WordPress to split the load using both MySQL Instances: we will split reads and writes between the Primary…
Today is a good day…
Today is a good day for me. Today I tweeted that MySQL after 25 years is still GPL and same for all important components: the server, the shell, the router, the clone plugin, workbench ! To be honest, Oracle has…
