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.
Before being able to use the report, you need to download 2 files. The first one is the addition in
systhat I often use to monitor MySQL InnoDB Cluster:
And the second one is the report:
Once downloaded, you can unzip them and install them:
On your Primary-Master run:
mysqlsh --sql clusteradmin@mysql1 < addition_to_sys_GR.sql
Now install the report on your MySQL Shell client’s machine:
$ mdkir -p ~/.mysqlsh/init.d
mv gr_info.py ~/.mysqlsh/init.d
Once installed, you just need to relaunch the Shell and you are ready to call the new report using the
Now let’s see the report in action when I block all writes on
mysql2 with a FTWRL and call the report with
Yet another nice addition to MySQL Shell. With this report you can see which member still has quorum, how many transactions each nodes have to apply, …
Don’t hesitate to also share your reports too !