MySQL 8.0 Atomic DDL – behavior change
In MySQL 8.0, we have now a new way of storing tables definitions: the Data Dictionary ! Thanks to the Data Dictionary, DDLs in MySQL 8.0 are now Atomic. This means tat we have some changes in the behavior of…
Migrating to MySQL 8.0 for WordPress – episode 3: query optimization
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…
Migrating to MySQL 8.0 for WordPress – episode 2: workload analysis
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…
Migrating to MySQL 8.0 for WordPress – episode 1
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…
👋 🐛 199 – bye bye bug #199, MySQL auto_increment is fixed !
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…
Learn from the bests at the MySQL track of Oracle Open World
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…
Annual MySQL Community Reception at Oracle OpenWorld
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…
The MySQL Team is happy and proud to welcome you at Oracle Open World 2017
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…
Reduce human interaction when using an asynchronous replica to a MySQL InnoDB Cluster
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.…
MySQL Team speaking at Percona Live Dublin 2017
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…
MySQL Group Replication: read your own write across the group
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…
ProxySQL and MySQL 8.0.2 (la suite)
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…
