[collectd] Fwd: [5.1] Multiple mysql instances?

[Jacek Osiecki]

Hello,

I'm trying to set up again collectd to handle more than one mysql instance per host.
The problem is, that there is no information on how to do this - anywhere...

When I start collectd, I get the warning:

The read function "mysql-mysql" is already registered. Check for duplicate "LoadPlugin" lines in your configuration!

However, the only place where I handle mysql is /etc/collectd.d/mysql.conf:

LoadPlugin mysql
<Plugin mysql>
	<Database "sqlone">
		User "backup"
		Password "xxxx"
		Host "192.168.0.21"
		Database "mysql"
		#Socket "/var/lib/mysql/sc-sqlcrit/mysql.sock"
	</Database>
	<Database "sqltwo">
		User "backup2"
		Password "yyyy"
		Database "mysql"
		Host "192.168.0.22"
		#Socket "/var/lib/mysql/sc-sqlmain/mysql.sock"
	</Database>
</Plugin>

I tried many combinations: using "Host" in first database and "Socket" in second one, using
different users - nothing helped. Always only the first database is handled.

Am I doing something wrong, or is collectd simply unable to handle two (or more) mysql servers?

Greetings,
-- 
Jacek Osiecki
josiecki at silvercube.pl

Silvercube s.c.
ul. Makuszynskiego 4
31-752 Kraków
+48 (12) 684 21 00