5.1. Grafana
Grafana can quite happily read from the Upsilon MySQL database and show lots of information. The easiest way to probably do this is create a couple of SQL Views that make building Grafana queries a little easier.
5.1.1. Services Dashboard
SQL View
create view `grafana_services` as select id, identifier, lastUpdated, node, case karma when 'GOOD' THEN 3 WHEN 'BAD' THEN 0 WHEN 'UNKNOWN' THEN 1 WHEN 'OLD' THEN 2 ELSE '?' END karma, karma AS karmaDescription FROM services;
Grafana Table view
Use normal settings for table column headers.
Here is how you setup the karma column highlighting.
