Learn how to send MySQL data collected by collectd to Wavefront.

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

Wavefront supports an in-product 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>