MySQL supports different types of Indexes. They depend on the storage engine and on the type of data. This is the list of supported indexes:
Best Practices
My recommendation are valid for InnoDB storage engine. I won’t talk about MyISAM. There are some best practices to follow when designing your tables. These are the 3 most important:
…[Read more]At the end of the month, some engineers of the MySQL Team will be present in Austin, TX !
We will attend the first edition of Percona Live USA in Texas.
During that show, you will have the chance to meet key engineers, product managers, as well as Dave and myself.
Let me present you the Team that will be present during the conference:
The week will start with the MySQL InnoDB Cluster full day tutorial by Kenny and myself. This tutorial is a full hands-on tutorial where we will start by migrating a classical asynchronous master-replicas topology to a new MySQL InnoDB Cluster. We will then experience …
[Read more]With MySQL Shell 8.0.16, a new very interesting feature was released: the Reporting Framework.
Jesper already blogged about it and I recommend you to read his articles if you are interested in writing your own report:
I this post, I will show you one user-defined report that can be used to monitor your MySQL InnoDB Cluster / Group Replication.
Preparation
Before being able to use the report, you need to download 2 files. The first one is the …
[Read more]We saw yesterday that when an issue (like network splitting), it’s possible to remain with a partitioned cluster where none of the partition have quorum (majority of members). For more info read how to manage a split-brain situation.
If your read the previous article you notice the red warning about forcing the quorum. As an advice is never too much, let me write it down again here : “Be careful that the best practice is to shutdown the other nodes to avoid any kind of conflicts if they reappear during the process of forcing quorum“.
But if some network problem is happening it might not be possible to shutdown those other nodes. Would it be really bad ?
YES !
Split-Brain
Remember, we were in this situation:
We …
[Read more]Why migrating to MySQL 8.0 ?
MySQL 8.0 brings a lot of new features. These features make MySQL database much more secure (like new authentication, secure password policies and management, …) and fault tolerant (new data dictionary), more powerful (new redo log design, less contention, extreme scale out of InnoDB, …), better operation management (SQL Roles, instant add columns), many (but really many!) replication enhancements and native group replication… and finally many cool stuff like the new Document Store, the new MySQL Shell and MySQL InnoDB Cluster that you should already know if you follow this blog (see these TOP 10 for features for developers and this TOP 10 for DBAs & OPS).
Not anymore a drop in replacement !
We …
[Read more]On this article, I will show you how to migrate your wordpress database from the MariaDB on CentOS to the real MySQL.
Why migrating to MySQL 8.0 ?
MySQL 8.0 brings a lot of new features. These features make MySQL database much more secure (like new authentication, secure password policies and management, …) and fault tolerant (new data dictionary), more powerful (new redo log design, less contention, extreme scale out of InnoDB, …), better operation management (SQL Roles, instant add columns), many (but really many!) replication enhancements and native group replication… and finally many cool stuff like the new Document Store, the new MySQL Shell and MySQL InnoDB Cluster that you should already know if you follow this …
[Read more]Consistency during reads have been a small concern from the adopters of MySQL InnoDB Cluster (see this post and this one).
This is why MySQL supports now (since 8.0.14) a new consistency model to avoid such situation when needed.
Nuno Carvalho and Aníbal Pinto already posted a blog series I highly encourage you to read:
[Read more]The Oracle Open World 2019 Call For Paper is open until March 13th.
MySQL track will be part of CodeONE, the parallel conference focused on developers.
We encourage you to submit a session related to the following topics:
Don’t miss the chance to participate to this amazing event. Submit now() here !
Last week I presented the following session at the pre-FOSDEM MySQL Day:
MySQL Shell : the best DBA tool ? from Frederic Descamps
The audience seemed very interested on how the MySQL Shell can be extended.
During the presentation I showed how I extended the MySQL Shell with two new modules in Python:
Both projects are on github and are waiting for ideas, feature requests, pull requests, …
Here is …
[Read more]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.
Since my interlocutor was a customer, the obvious choice is to use MySQL Enterprise Backup (known as MEB). Of course any other physical backup should be also fine.
The customer told me he was using cron to schedule his backup and was only using full backups… That’s perfect. So I told him that there is nothing complicated and that the cron job should something like:
mysqlbackup --with-timestamp --backup-dir /backup backup
Of course, I do not recommend the use of --user
clusteradmin --password=xxxxxin the cronjob but configure
your crendentials using …