lefred's blog

There Are 10 Types of People in the World....

Create an Asynchronous MySQL Replica in 5 minutes

I have already posted some time ago a post related to the same topic (see here). Today, I want to explain the easiest way to create an asynchronous replica from an existing MySQL instance, that this time has already data !

Overview on MySQL Shell 8.0.17 Extensions & Plugins and how to write yours !

With MySQL Shell 8.0.17, a super cool new feature was released: the MySQL Shell Extensions & Plugins ! You will be able to write your own extensions for the MySQL Shell. You may already saw that I’ve written some modules like Innotop or mydba for MySQL Shell. However those plugins were written in Python and only accessible in Python mode. … Read More

MySQL InnoDB Cluster from scratch – even more easy since 8.0.17

Create a MySQL InnoDB Cluster using MySQL 8.0 has always been very easy. Certainly thanks to MySQL Shell and server enhancements like SET PERSIST and RESTART statement (see this post). The most complicated part to deal with was the existing and none existing data. In fact GTID sets must be compatible. Let me explain that with some examples: Example 1 … Read More

Some queries related to MySQL Roles

MySQL Roles are becoming more and more popular. Therefor, we receive more and more questions related to them. First I encourage you to read this previous 2 posts: MySQL 8.0 Roles and GraphML MySQL 8.0: Listing Roles In this post, I will share you some queries I find useful when using MySQL Roles. Listing the Roles The first query allows … Read More

About MySQL and Indexes

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: B-trees (the most common) R-trees (for spatial data) Hashes (for Memory engine) Inverted (for InnoDB Full Text) Best Practices My recommendation are valid for InnoDB storage engine. I won’t talk about MyISAM. There are some … Read More