Learn how to send MySQL data collected by collectd to VMware Tanzu Observability (formerly known as VMware Aria Operations for Applications).

MySQL is a popular open-source relational database. See collectd MySQL plugin documentation.

Tanzu Observability supports a built-in integration that gets data from MySQL using Telegraf. If you want to use collectd instead, follow the instructions on this page.

Installation

  1. On your collectd host, copy the config below into /etc/collectd/managed_config/.
  2. Edit the settings in the file for your MySQL database.
  3. Restart collectd.

Example collectd Configuration

LoadPlugin mysql
<Plugin mysql>
  <Database test>
  Host "localhost"
  Socket "/var/run/mysqld/mysqld.sock"
  User "root"
  Password "abcdABCD1."
  Database "lamptest"
  </Database>
</Plugin>

Example Configuration for Connecting to Remote MySQL Hosts

LoadPlugin "mysql"
<Plugin "mysql">
  <Database "foo">
  Host "hostname"
  User "username"
  Password "password"
  Port 3306
  MasterStats true
  </Database>
</Plugin>
integrations