From June 16th to 17th, the MySQL Team will be attending and speaking at the Hong Kong Open Source Conference 2018. Unfortunately I won’t be present but some of my great colleagues will be speaking about MySQL. If you are…
Recently during my several talks and trips to meet the MySQL Community and MySQL InnoDB Cluster, I realized that some important message was missing. I got a lot of questions about which version of Router or Shell people should use.…
MySQL 8.0.11 seems to be around the corner and the new MySQL Shell will take advantage of all the new improvements made in MySQL 8.0 like SET PERSIST, RESTART, … see this previous post. In the video below, I show…
If you are interested in MySQL Performance and you are looking for an optimal storage, you should have a look at this presentation by Frank Ober where you will be able to see how MySQL behaves on Intel Optane SSDs:…
At the end we all agree that what really matters is the Query Response Time, isn’t it ? MySQL 8.0 engineers have added more visibility in the summary tables as explained in this previous post. But to add more details,…
Recently on MySQL Forums, somebody was looking for documentation or procedure to upgrade a MySQL InnoDB Cluster (or Group Replication cluster) to a newer version. In this post I am illustrating the best practices to achieve this task safely.
Recently I blogged about the new default authentication plugin in MySQL 8.0 and I got some comments complaining that this new authentication plugin is breaking half of applications. So first of all, if you are using an old connector or…
Today, yet another blog post about improvements in MySQL 8.0 related to Performance_Schema. Before MySQL 8.0 it was not always easy to get an example of the queries you could find in Performance_Schema when looking for statements summaries. You had…
With MySQL 8.0, the error logging subsystem has been redesigned to use the new component architecture. Thanks to this new redesign, now the log events can be filtered, the output can be sent to multiple destinations (different formats like JSON).…
In MySQL 8.0, the engineers have added useful meta-data to the table SETUP_INSTRUMENT. This table lists the classes of instrumented objects for which events can be collected. To the NAME, ENABLES and TIMED columns, were added PROPERTIES, VOLATILITY and DOCUMENTATION.…
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’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…