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

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

VMware Aria Operations for Applications 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>