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:
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 sys
that 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 \show
command:
Now let’s see the report in action when I block all writes on mysql2
with a FTWRL and call the report with \watch
:
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 !
using mysql shell 8.0.16
try to use the report but getting below error
IndexError: unknown attribute: sql
Hi Abdullah,
Are you connected to one of the members ? And are you using the X Protocol ? (port 33060 by default)
Cheers,
Thanks ๐ port 33060 by default working
Regards
Thanks ๐ port 33060 by default working
Regards