monitoring - Database queries as application healthchecks - management tool -


hey there fellow stackoverflowers,

in our company have several application stacks running on different types of databases (mysql, postgresql, ms sql, azure sql,..). monitoring purposes use scripted queries on databases of these application stacks, nagios reporting results in email.

now, since our support team easy access these queries in order manually run them or modify them, considering building application designed able store, run , modify queries can executed on of above listed database types , offering both user-friendly webinterface , rest api json output our new reporting stack based on sensu, deployed in few months.

my personal belief tool must out there, since use case generic. however, googling did not yield results closely resembling looking for.

so question is: know of such tool? if had build yourself: approach be? we're java/c++ team, open options.

some or may of stuff can done existing api called nagira. on google. give results in json format. think allow run checks manually. can may build little front end , call api achieve want.


Comments