# Metricbeat - mysql module - galera\_status metricset

**URL:** <https://discuss.elastic.co/t/metricbeat-mysql-module-galera-status-metricset/267508>\
**Category:** Beats\
**Tags:** metricbeat\
**Created:** [March 17, 2021, 12:41pm UTC](https://discuss.elastic.co/t/metricbeat-mysql-module-galera-status-metricset/267508 "2021-03-17T12:41:26Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![AlexanderN](https://avatars.discourse-cdn.com/v4/letter/a/258eb7/32.png) [@AlexanderN](https://discuss.elastic.co/u/AlexanderN)\
**Post date:** [March 17, 2021, 12:41pm UTC](https://discuss.elastic.co/t/metricbeat-mysql-module-galera-status-metricset/267508/1 "2021-03-17T12:41:26Z")

</div>

Hello!

First time poster searching for an answer to a problem that google isn't helpful with.

I am using Metricbeat with the mysql module to send metrics from my "5.7.30-log" mysql server with the "galera\_status" metricset enabled.

I see in the raw output that the galera fields are empty:

```auto
      "mysql": {
         "galera_status": {
         "cluster": {},
         "received": {},
         "repl": {},
         "commit": {},
         "evs": {},
         "apply": {},
         "cert": {},
         "flow_ctl": {},
         "local": {
         "recv": {},
         "send": {}
       }
     }

```

Has anyone else come across this?

Best Regards!

---

<div class="post-metadata">

**Author:** ![Andre\_Letterer](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/andre_letterer/32/42248_2.png) [@Andre\_Letterer](https://discuss.elastic.co/u/Andre_Letterer)\
**Post date:** [March 18, 2021, 1:15am UTC](https://discuss.elastic.co/t/metricbeat-mysql-module-galera-status-metricset/267508/2 "2021-03-18T01:15:17Z")

</div>

Hi Alexander,

would you mind to give some background to this mySQL configuration?

My basic question would be if you even have mysql configured to be a Galera cluster?  
Because otherwise it is quite natural that you get an empty resultset.

What does your `my.cnf` and `galera.cnf` look like?  
What is the output of statement `SHOW STATUS LIKE 'wsrep_cluster_size'`?

Because right now I tested with a galera docker container and the output is appropriately filled with values.

---

<div class="post-metadata">

**Author:** ![AlexanderN](https://avatars.discourse-cdn.com/v4/letter/a/258eb7/32.png) [@AlexanderN](https://discuss.elastic.co/u/AlexanderN)\
**Post date:** [March 18, 2021, 8:07am UTC](https://discuss.elastic.co/t/metricbeat-mysql-module-galera-status-metricset/267508/3 "2021-03-18T08:07:42Z")

</div>

Hello Andre!

That explains, I was under the impression that galera was a part of MySQL used for the replication between servers ( since the fields in metricbeat that revolve around replication all come from galera\_status metricset ).

I just want to grab replication status, slave lag from my MySQL Server with metricbeat, is that not possible while using mysql standard replication?

---

<div class="post-metadata">

**Author:** ![Andre\_Letterer](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/andre_letterer/32/42248_2.png) [@Andre\_Letterer](https://discuss.elastic.co/u/Andre_Letterer)\
**Post date:** [March 19, 2021, 1:58am UTC](https://discuss.elastic.co/t/metricbeat-mysql-module-galera-status-metricset/267508/4 "2021-03-19T01:58:09Z")

</div>

Ah, ok. No Galera is an extra part of MySQL for High Availability Scenarios [https://galeracluster.com](https://galeracluster.com)

Going back to your replication question:  
[https://dev.mysql.com/doc/refman/5.7/en/replication.html](https://dev.mysql.com/doc/refman/5.7/en/replication.html)  
How did you exactly set up your replication?

Can you post the relevant `my.cnf` part?

---

<div class="post-metadata">

**Author:** ![reallove](https://avatars.discourse-cdn.com/v4/letter/r/3be4f8/32.png) [@reallove](https://discuss.elastic.co/u/reallove)\
**Post date:** [April 8, 2021, 8:21pm UTC](https://discuss.elastic.co/t/metricbeat-mysql-module-galera-status-metricset/267508/5 "2021-04-08T20:21:46Z")

</div>

I am also interested in this - gather MySQL replication info using the `mysql` metricbeat module.  
From reading the documentation, am I right in saying that `SHOW SLAVE STATUS` is not implemented? I can't see anything related to MySQL replication using the `status` metricset in the `mysql` metricbeat module.  
Thanks!

---

<div class="post-metadata">

**Author:** ![Andre\_Letterer](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/andre_letterer/32/42248_2.png) [@Andre\_Letterer](https://discuss.elastic.co/u/Andre_Letterer)\
**Post date:** [April 11, 2021, 8:57pm UTC](https://discuss.elastic.co/t/metricbeat-mysql-module-galera-status-metricset/267508/6 "2021-04-11T20:57:02Z")

</div>

Hi @reallove

Welcome to the Elastic community.  
As far as I know there is no `SHOW SLAVE STATUS` kind of metricset, there is only one for `SHOW GLOBAL STATUS`.

The portion you are referring to is the Status metricset of the MySQL module:

> **[MySQL status metricset | Metricbeat Reference \[7.12\] | Elastic](https://www.elastic.co/guide/en/beats/metricbeat/current/metricbeat-metricset-mysql-status.html)**

Right now I have tested with a normal Mysql Replicaset and it was instantly working, I got results.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [May 9, 2021, 10:57pm UTC](https://discuss.elastic.co/t/metricbeat-mysql-module-galera-status-metricset/267508/7 "2021-05-09T22:57:06Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.