lefred's blog


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

How to safely upgrade to MySQL 8.0 ?

As for each previous version, to upgrade to MySQL 8.0 you must first read the upgrade section in the manual. It’s important to know that you should upgrade without skipping a major version, so upgrade from 5.6 to 8.0 is not supported neither recommended. Please also note that upgrades from any MySQL 8.0 RC won’t work. We support upgrade process … Read More


TOP 10 MySQL 8.0 features for DBAs & OPS

Today, let’s have a look at the TOP 10 new features in MySQL 8.0 that will improve DBA’s life. To shrink the list to 10 only items wasn’t an easy task, but here is the top 10: Temporary Tables Improvements Persistent global variables No more MyISAM System Tables Reclaim UNDO space from large transactions UTF8 performance Removing Query Cache Atomic … Read More


TOP 10 MySQL 8.0 features for developers

MySQL 8.0 RC2 has just been released with a lot of new features compared to MySQL 5.7. In this blog post, I will list the top 10 new features that should excite developers. These functionalities are presented in descending order of preference of our MySQL Community. TOP 10 MySQL Document Store Default to utf8mb4 JSON enhancements CTEs Window Functions Descending … Read More


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 graph illustrating the ROLES and their eventual hierarchy. From the documentation, it seems those graphs are made using the ROLES_GRAPHML() … Read More


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 life easier. /etc/my.cnf With MySQL 8.0, we worked in making your life easier (and the life of configuration management systems … Read More


recent

Last Tweets Last Tweets

    Locations of visitors to this page
    categories