lefred's blog


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

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


Using the new MySQL Shell Reporting Framework to monitor InnoDB Cluster

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: https://mysql.wisborg.dk/2019/04/26/mysql-shell-8-0-16-built-in-reports/ https://mysql.wisborg.dk/2019/04/27/mysql-shell-8-0-16-user-defined-reports/ I this post, I will show you one user-defined report that can be used to monitor your MySQL InnoDB Cluster / Group … Read More


What configuration settings did I change on my MySQL Server ?

This post is just a reminder on how to find which settings have been set on MySQL Server. If you have modified some settings from a configuration file or during runtime (persisted or not), these two queries will show you what are the values and how they were set. Even if the value is the same as the default (COMPILED) … Read More


MySQL 8.0.16: how to validate JSON values in NoSQL with check constraint

As you may have noticed, MySQL 8.0.16 has been released today ! One of the major long expected feature is the support of CHECK contraints . My colleague, Dave Stokes, already posted an article explaining how this works. In this post, I wanted to show how we could take advantage of this new feature to validate JSON values. Let’s take … Read More


recent
Locations of visitors to this page
categories