MySQL : command delimiter curiosity – go & ego
Recently, I received a question related to GO as delimter to send a query. The user got some generated statements from a third party tool that looked like this:
MySQL 8.0 : more about new authentication plugin and replication
MySQL 8.0’s new default authentication plugin means more secure connections for users connections but also for replication… but you need to be aware of it ! Yesterday Giuseppe – the datacharmer – Maxia, submitted a bug related to a strange…
MySQL 8.0 : Data Locking Visibility
With MySQL 8.0, engineers improved the visibility of data locking. Usually it was not that easy to deal with the output of SHOW ENGINE INNODB STATUS and mixing Information_Schema tables like INNODB_LOCKS and INNODB_LOCK_WAITS. So in MySQL 8.0 we instrument…
MySQL 8.0: Listing Roles
As you may already know, MySQL 8.0 is coming with SQL Roles . I’ve already quoted them before in some posts (here and here). Giuseppe Maxia is doing a great job testing and promoting them (thank you for that!). Of…
MySQL 8.0 Histograms
Prior to MySQL 8.0, MySQL was missing a very well know feature in other RDBMS: optimizer histograms. The Optimizer Team implemented this feature as more and more MySQL DBAs were requesting it. Definition But what are histograms ? For wikipedia,…
Oracle Open World Call for Papers is open !
Today the call for participation for Oracle Open World 2018 has started. The 2018’s edition will take place in San Francisco as usual, from October 22nd to 25th. As every year, MySQL will be present and if you want to…
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…
MySQL HA Architecture #1 : InnoDB Cluster & Consul
I received many request about MySQL High Availability Architecture. There are a lot of tools, but how can we use them to achieve MySQL HA without over engineering everything. To answer such demand, there is no generic architecture, of…
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…
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…
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…
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…
