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
[email protected]
Silvercube s.c.
ul. Makuszynskiego 4
31-752 Kraków
+48 (12) 684 21 00
_______________________________________________
collectd mailing list
[email protected]
http://mailman.verplant.org/listinfo/collectd
