MySQL 8.0 Roles and Graphml
You may already know that MySQL 8.0 is coming with a nice requested feature : ROLES A role is a named collection of privileges. When you watch some slidedeck about MySQL 8.0 and ROLES, some times you can see a…
Category 8.0
MySQL 8.0: changing configuration easily and cloud friendly !
Changing configuration settings in MySQL wasn’t always easy. Of course it’s possible to change things (hopefully), but keeping track of everything is not always obvious. This is where configuration management systems like puppet, chef, ansible, … excels in making our…
From MySQL 5.6 partitioning to 5.7 and beyond
As you may already know, since MySQL 5.7.17, the generic partitioning handler in the MySQL server is deprecated, and is completely removed in MySQL 8.0. So now, in MySQL 5.7, the storage engine used for a given table is expected…
MySQL 8.0 Data Dictionary Tables… and why they should stay protected
With MySQL 8.0, one key feature is the new Data Dictionary. The system tables that were previously in MyISAM are now replaced by new protected ones in the DD. My friend Giuseppe already explained how you could see those tables…
Where does my MySQL configuration variable value come from ?
As you may already know, there are many different places where a MySQL configuration variables can be initialized. In MySQL 8.0, we added in performance_schema a table allowing you to easily find where a variable was defined. Let’s check this…
