Hi,
What would be the better way to monitor things using SQL queries?
Do I need to create plugin for every query - or is there a SQL poller
/ agent - which can be used to hook results to RHQ servers and can be
monitored + put alerts on.
You don't need a separate plugin per query - one plugin would be enough.
Then set up a server / service which contains metrics
<metric property="Firtst query | select * from dual;"
displayName="Display dual"/>
<metric proptery="Yaha | select ... " displayName="..." />
And then within getValues() parse the property name and execute the stuff behind the |
sign.
To write the plugin, you can inherit functionality from the abstract database plugin
Let us know how you progress
Heiko