lefred's blog

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

MySQL InnoDB Cluster, automatic provisioning, firewall and SELinux

You may have noticed that in many of my demos, I disable firewall and SELinux (I even use –initialize-insecure sometimes 😉 ). This is just to make things easier… But in fact enabling iptables and SELinux are not complicated.

MySQL Router 8.0.17’s REST API & MySQL Shell Extensions

You have seen in this previous post, that since 8.0.17, it’s now possible to query the MySQL Router using its REST API. Additionally, we also saw in this post, that since 8.0.17, we are now able to write extensions to MySQL Shell using the Extension Framework. Let’s combine both and see how we can integrate the MySQL Router’s REST API … Read More

MySQL 8.0.17 and Drupal 8.7

From Drupal’s website, we can see that now the support of MySQL 8 is ready. I just tested it and it works great ! The only restriction is related to PHP and the support for the new authentication method in php-mysqlnd. In this previous post, I was happy because it was included in PHP 7.2.8, but this has been reverted … Read More

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