Today we will see how to use MySQL Database Service aka MDS with WordPress. To achieve this easy task, we will use the architecture we already deployed in this article. We have then two Compute Instances on OCI, 1 running…
In a recent article, I explained how to test MySQL Database Service (aka MDS) on OCI without having to setup a VPN. A VPN is the recommended way and of course using some man-in-the-middle exposing the MySQL Classic and X…
Please note that this is not recommended for any production purpose, don’t expose MySQL traffic to the Internet ! MySQL Database Service is now available, take a look at this nice introduction video:
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…
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…
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 ?…
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…
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…
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 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…
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…
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…
As MySQL Community Manager, I am an employee of Oracle and the views expressed on this blog are my own and do not necessarily reflect the views of Oracle.
You can find articles I wrote on Oracle’s blog.