MySQL Forums
Forum List  »  InnoDB clusters

Monitor InnoDB cluster
Posted by: Fred Barriere
Date: March 05, 2019 03:06AM

I created a InnoDB cluster using mysql shell using commands :
- dba.configureInstance on each node
- dba.createCluster and cluster.addInstance on master node

All works fine. Cluster is running with one master and two slaves. When I update master (create table, insert...), data are replicated on slaves.

Now I want to monitor my cluster. For that I use telegraf with its Mysql plugin.
I have only one problem : there is no information about slaves.
The reason is that when I run the queries below on a slave :
- show master status
- show slave status
the first returns a record with information of master log (it's ok), but the second returns an empty set. And this is this information that is collected by telegraf.
So how to have slave information for an InnoDB cluster set up with Mysql shell ?

Options: ReplyQuote

Written By
Monitor InnoDB cluster
March 05, 2019 03:06AM
March 15, 2019 04:43AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.