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.
Category MySQL
MySQL Mailing Lists
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…
MySQL 8.0 and user password management
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.
How to grant privileges to users 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…
MySQL 8.0 and keywords
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…
