I need to monitor and alert a MySQL DB which is hosted on AWS. I'd like an alert to trigger if certain SQL query criteria aren't met (e.g.
SELECT * FROM my_table returns less than 100 results).
What open-source tools are available for this type of monitoring? Most I've come across tend to monitor low level MySQL DB stats but I'd like specific queries to trigger alerts. I've come across Prometheus but was wondering if there others I could look into?