Monitoring MemSQL cluster with Elastic MySQL Metricbeat

Help
1

Hello Team,

Our monitoring solution is ELK and I wonder if we can use MySQL Beat to monitor Memsql cluster.

Thanks in advance,
Chen.

2

Hello chen,

Our team has not tested with MySQL MetricBeat, But I can make you aware of certain caveats.

  1. If the product depends on MySQL performance_schema, then it will not work against MemSQL as we do not have performance_schema.
  2. We have several tables storing metrics in the information_schema though.

We have a Historical Monitoring product developed in-house and integrated with Kafka and Grafana. If you would like to install it please follow this document link SingleStoreDB Cloud · SingleStore Documentation

Please do post back on your experience setting up and using Historical Monitoring.

Thanks,

1 Like
3

Thanks rnarayanan, I’ll check it out!

4

We tested the on-prem central monitoring using Kafka/Grafana and it seemed to work great with the default dashboards included. The documentation in docs.memsql is very limited and can be a bit confounding with the terminology. MONITORED_CLUSTER (a cluster being monitored) and COLLECTING_CLUSTER (Central monitor which runs kafka and grafana datashboards) would avoid the confusion. But overall a great win for memsql… if we can get 2 dozen pre-canned dashboards (with json) that would be fabulous… we are already starting to implement it ubiquitously.

5

Great feedback isanth. Do you have specific metrics or views that would be most helpful if included in pre-canned dashboards?

6

yes. will be in touch with you the secure customer channel, as I need some time to dredge up all the needed metrics/dashboards which will be super useful (that also assumes we have v7.1 capabilities like blocking info etc… more like a OLTP requirement in memsql.)