Now that MySQL 8.0.3 RC1 is installed and that we saw how to verify the workload, it’s time to see if we can optimize some of the queries. As explained before, rewriting queries when using a product like WordPress is…
Now that MySQL is upgraded to 8.0 RC1, let’s have a look on how we could check the workload and see if we can optimize something by adding indexes for example. The same technique can be used to find inefficient…
Yesterday I decided to upgrade the database server of lefred.be running the latest WordPress to MySQL 8.0. The previous version was 5.7.19. My dedicated server is still running on CentOS 6.x, and I had just to enable the MySQL Community…
It was expected for a long time…. here is the fix for bug #199 !! The bug #199 submitted by PeterZ has been fixed in 8.0. Thank you to Zhang Simon for his contribution that inspired us to implement the…
Do you want to hear how popular, innovative and leading companies are using MySQL to scale their large workload ? Join Oracle Open World to learn from these successful players how to achieve strong business constraints using the most popular…
Like every year, the a MySQL Community Reception will take place during Open World. If you are using or interested in learning more about MySQL? And if you are attending Oracle OpenWorld and looking for an opportunity to meet and…
OOW17 is just around the corner. And again this year the MySQL team is very proud to present you their work mostly on MySQL 8.0 but also on NDB and all Enterprise tools we have. This year, we will also…
A MySQL replication topology can be very complex (never underestimate a DBA’s creativity). But it’s very frequent to use an asynchronous replica from your primary database to run reporting or logical backup… or any kind of read workload you need.…
From September 25th to 27th 2017, the MySQL engineers and community team will be speaking at Percona Live Europe in Dublin. MySQL is also part of the contributing sponsors. For the conference, we tried to bring new faces to the…
Today is my last day in Asia (China and Taiwan), and between the sessions I had the time to code a small proof-of-concept for people that are asking how they could read their writes on all nodes and ensure the…
Recently I wrote a blog post on how to use ProxySQL with 8.0.2 dmr This blog post was related to the change we implemented in the Group Replication’s monitoring (performance_schema tables) and how sys schema should be changed to modify…
Some time ago I wrote this article explaining how to find which node was the Primary Master in a MySQL Group Replication cluster running in Single-Primary Mode. In the latest release of Group Replication, MySQL 8.0.2 dmr, Jaideep improved the…
As MySQL Community Manager, I am an employee of Oracle and the views expressed on this blog are my own and do not necessarily reflect the views of Oracle.
You can find articles I wrote on Oracle’s blog.