lefred's blog


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

MySQL Router 8.0.17 and the REST API

Since MySQL 8.0.16, the Router as the possibility to launch an internal webserver (see Jan’s blog post). Even if this webserver could serve static files, it was the first piece of a much more interesting solution that is now available since 8.0.17. It’s possible now to query the MySQL Router via its REST API and get a lot of useful … 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


MySQL Group Replication: what are those UDFs ?

To operate more easily a MySQL Group Replication (InnoDB Cluster), the Group Replication plugins provides some UDFs. If you have read the recent article from Tiago Vale about the Group Replication Communication Protocol, you may have heard about two new UDFs allowing to get or set  the communication protocol. So what are all the UDFs provided with the Group Replication … Read More


the MySQL Team in Austin, TX

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 … Read More


MySQL InnoDB Cluster : Recovery Process Monitoring with the MySQL Shell Reporting Framework

As explained in this previous post, it’s now (since 8.0.16) possible to use the MySQL Shell Reporting Framework to monitor MySQL InnoDB Cluster. Additionally, when a member of the MySQL InnoDB Cluster’s Group leaves the group for any reason, or when a new node is added from a backup, this member needs to sync up with the other nodes of … Read More


recent
categories