Last week I presented the following session at the pre-FOSDEM MySQL Day: The audience seemed very interested on how the MySQL Shell can be extended. During the presentation I showed how I extended the MySQL Shell with two new modules in Python: mydba innotop Both projects are on github and are waiting for ideas, feature requests, pull requests, … Here … Read More
We are less than 48h before the more and more popular pre-FOSDEM MySQL Day ! Unfortunately one of our speaker won’t be able to deliver his talk. Indeed, Giuseppe had ton cancel is talk on containers (Automating MySQL operations with containers) but he will be present during the day and during the Community Dinner, so if you have questions, I’m … Read More
MySQL InnoDB is more and more popular. The adoption of it is even faster than I expected. Recently, during my travel in Stockholm, Sweden, a customer asked me what was the best practice to backup a cluster.
I already covered some information related to users password recently (see this post and this one). Today, let’s have a look at the password management features available in MySQL 8.0.
It seems, that this is a question that regularly shows up in forums or stackoverflow. To start, let’s highlight the fact that in MySQL 8.0 it’s not any more possible to create a user directly from the GRANT command (ERROR 1410 (42000): You are not allowed to create a user with GRANT). This means that to grant some privileges, the … Read More