As you could read in this previous post, PHP 7.4 is now completely supporting MySQL 8.0 and the new default authentication plugin. I wanted to make a summary table providing and overview of all PHP versions and how they supported…
The schedule of the preFOSDEM Day is now available ! We had a lot of proposals to deal with. Also this is a MySQL event where we, the MySQL Team has the possibility to show to you, our Community, all…
See some update at the end: 23 Dec 2019 MySQL and PHP is a love story that started long time ago. However the love story with MySQL 8.0 was a bit slower to start… but don’t worry it rules now…
In my road trip of the Open Source projects using MySQL, after having tested WordPress, Drupal and Joomla, let’s try to install Magento using MySQL 8.0 ! In Magento’s manual, we can see that the project requires MySQL 5.6 and…
To avoid infinite replication loops MySQL doesn’t allow you to have log_slave_updates and replicate-same-server-id. When using GTIDs that may lead to something not expected that you may not be aware of. In this scenario, we have 2 MySQL servers using…
As you may know, I’m using MySQL exclusively on GNU To be honest for me it’s almos 20 years that the year of Linux on the desktop happened. And I’m very happy with that. But this week-end, I got a…
Hello dear MySQL Community ! As you know FOSDEM 2020 will take place February 1st and 2nd. After having received many, many requests we decided to organize for the 4th year in a row the pre-FOSDEM MySQL Day… with a…
Today, we will cover a totally different MySQL Shell plugin: InnoDB. Currently only 3 methods have been created: Those related to the Table space fragmentation, have already been covered in this recent article. Let’s discover the getAlterProgress()method. This method allows…
What is great with MySQL Shell Plugins, it’s that it provides you an infinite amount of possibilities. While I was writing the part I and part II of the check plugin, I realized I could extend it event more. The…
In the first part of this article related to the check plugin, we discovered information retrieved from the binary logs. This part, is about what Performance_Schema and SYS can provide us about the queries hitting the MySQL database. Currently, 3…
This blog was initially referring to the audit plugin, but I renamed it as check plugin to be more compatible with all the current and future methods included in it. As you may know, it’s now possible to create your…
To illustrate how easy it’s to see who’s trying to access data they have not been granted for, we will first create a schema with two tables: mysql> create database mydata; mysql> use mydata mysql> create table table1 (id int…
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.