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

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

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>