Top 10 reasons for NoSQL with MySQL
As you know, one of the great new feature in MySQL 8.0 is the Document Store. Now with MySQL you can store your JSON documents in collections and manage them using CRUD operations. NoSQL is now part of MySQL !…
Next week in Barcelona
Next week I will be speaking at DataOps in Barcelona about MySQL 8.0 Document Store. If you don’t know it yet, I really invite you to join this talk, you will be very surprised about all MysQL can do in…
MySQL participating to HKOSCon 2018
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…
MySQL InnoDB Cluster – Compatibility Matrix
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 Shell for MySQL 8.0: your best friends in the cloud !
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…
MySQL 8.0 on Intel Optane SSDs
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:…
MySQL 8.0: Statements Latency Histograms
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,…
MySQL InnoDB Cluster & Group Replication: how to upgrade safely your cluster
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.
Migrating to MySQL 8.0 without breaking old application
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…
MySQL 8.0 : Digest Query Samples in Performance_Schema
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…
MySQL 8.0 : New Error Logging
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).…
MySQL 8.0 : meta-data added to Performance_Schema’s Instruments
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.…
