How to backup your InnoDB Cluster ?

MySQL InnoDB is more and more popular. The adoption of it is even faster than I expected. Recently, during my travel in Stockholm, Sweden, a customer asked me what was the best practice to backup a cluster.
MySQL InnoDB is more and more popular. The adoption of it is even faster than I expected. Recently, during my travel in Stockholm, Sweden, a customer asked me what was the best practice to backup a cluster.
Over the last few years, our community discussions have moved to MySQL Community Slack and MySQL Community Forums. And, Q&A discussions have moved to StackExchange and StackOverflow. The traditional MySQL mailing lists do not have any meaningful traffic, and are…
I already covered some information related to users password recently (see this post and this one). Today, let’s have a look at the password management features available in MySQL 8.0.
It seems, that this is a question that regularly shows up in forums or stackoverflow. To start, let’s highlight the fact that in MySQL 8.0 it’s not any more possible to create a user directly from the GRANT command (ERROR…
As you know, MySQL uses some keywords and some of them are also reserved. Let’s have a look how to deal with that: mysql> create table WRITE (id int auto_increment primary key, varying varchar(10), than int); ERROR 1064 (42000): You…
I wish you all the best for this end of 2018 and of course a nice start of 2019’s edition ! For the best possible start of 2019, I already invite you to these different events where I will have…
If you are using MySQL InnoDB Cluster (Group Replication) with ProxySQL, you should be familiar with the 2 functions and 1 view required in SYS Schema that ProxySQL uses to see if a node is online, partitioned or not, and…
I had the pleasure to receive a nice educative video from my colleague Narendra Singh Chauhan, working in the QA team for MySQL Replication. If you are curious to understand how all this works, please take a look at the…
For the third year in a row, we will take advantage of the mass presence of our MySQL Engineers during FOSDEM to organize the pre-FOSDEM MySQL Day. The program of this 3rd edition is already on track, thank you to…
Today I read the nice post of Bhuvanesh on the memory leak issue they experienced with MySQL. In fact when you read the post, you realize that MySQL was just following the parameters that were setup (the default of max_prepare_stmt_count…
Has you may already know, in MySQL it is possible to set an expiration period for passwords. It’s not always obvious to see when the password will expire. And most of the time if you don’t pay much attention you…
Recently, I did some maintenance on Innotop and I merged several pull requests including one to support MySQL 8.0 (thank you yoku0825 for the contribution). As you know, Innotop is written in Perl and to be able to use it…
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.