MySql Metrics

To get started first follow the steps below:

• Install
• Root access
• Verify the required port is open

Older versions can be found here 7, 6, 5

The configuration file below is pre-configured to send data to your Logit.io Stack via Logstash.

Copy the configuration file below and overwrite the contents of metricbeat.yml.

###################### Logit.io Metricbeat Configuration #######################
# =========================== Modules configuration ============================

metricbeat.config.modules:
  # Glob pattern for configuration loading
  path: ${path.config}/modules.d/*.yml

  # Set to true to enable config reloading
  reload.enabled: false

  # Period on which files under path should be checked for changes
  #reload.period: 10s
# ======================= Elasticsearch template setting =======================
setup.template.settings:
  index.number_of_shards: 1
  index.codec: best_compression
  #_source.enabled: false

# ================================== Outputs ===================================
# ------------------------------ Logstash Output -------------------------------
<div class="sw-warning">
    <div>
        <img src="/images/source-wizard/warning-triangle.svg">
    </div>
    <div>
       <b>No input available! </b> Your stack is missing the required input for this data source <a href="#" onclick="Intercom('showNewMessage')" class="btn btn-info btn-sm">Talk to support to add the input</a>
    </div>
</div> 

There are several built in metricbeat modules you can use. To enable the MySql module, run the following:

deb/rpm

metricbeat modules list
metricbeat modules enable mysql

macOS

./metricbeat modules list
./metricbeat modules enable mysql

Windows

PS > .\metricbeat.exe modules enable mysql

Each module has its own configuration file where different metricsets can be enabled / disabled. Locate the configuration file for the MySql module.

deb/rpm /etc/metricbeat/modules.d/mysql.yml

mac/win ~/<EXTRACTED_ARCHIVE>/modules.d/mysql.yml

By default the status metricset is disabled. To enable or disable a metric simply comment or uncomment the line out.

- module: mysql
  metricsets:
    - status
    - galera_status
  period: 10s

You will also need to enter the host location of the database and the username and password to access it.

# Host DSN should be defined as "user:pass@tcp(127.0.0.1:3306)/"
# The username and password can either be set in the DSN or using the username
# and password config options. Those specified in the DSN take precedence.
hosts: ["(127.0.0.1:3306)/"]

# Username of hosts. Empty by default.
username: root

# Password of hosts. Empty by default.
password: secret

Start or restart to apply the configuration changes.

If you don't see data appearing in your Stack after following the steps, visit the Help Centre guide for steps to diagnose no data appearing in your Stack or Chat to support now.

The mysql MetricSets were tested with MySQL and Percona 5.7 and 8.0 and are expected to work with all versions >= 5.7.0. It is also tested with MariaDB 10.2, 10.3 and 10.4.

The MySql module comes with predefined Kibana dashboards.