lefred's blog


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

MySQL Shell : the best DBA tool?

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


Friday Feb 1st it is MySQL Day !

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


How to backup your InnoDB Cluster ?

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.


MySQL 8.0 and user password management

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.


How to grant privileges to users 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


recent

Last Tweets

  • RT : Conferences with MySQL this week! ,
  • RT : MySQL Routerさんは8.0.16からhttpしゃべることにしたらしいですね ,
  • RT : NDB Cluster 8.0.16-dmr has been released NDB Cluster is the distributed database combining massive scalability and high availability. It provides in-memory real-time access with transactional consistency across partitioned and distributed datasets ,
  • RT : The 8.0.16 Maintenance Release is Generally Available The MySQL Development team is very happy to announce that MySQL 8.0.16 is now available for download at . ,
  • RT : MySQL Shell 8.0.16も機能がもりもり追加されてるけど、リリースノートにも書かれてない起動オプションがしれっと追加されてる。。。どっかで開発チームのブログで説明するのかな?,
Locations of visitors to this page
categories