Monitor InnoDB cluster
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 ?
Subject
Views
Written By
Posted
Monitor InnoDB cluster
930
March 05, 2019 03:06AM
464
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.