If you're unfamiliar with mycheckpoint, well, the one minute sales pitch is: it's a free and open source monitoring tool for MySQL, which is extremely easy to install and execute, and which includes custom queries, alerts (via emails), and out of the box HTTP server and charting.
This is mostly a maintenance release, with some long-time requested features, and of course solved bugs. Here are a few highlights:
- Supports MariaDB and MySQL 5.6 (issues with new variables, space padded variables, text-valued variables)
- Supports alerts via function invocation on monitored host (so not only checking alerts via aggregated data like 'Seconds_behind_master' but also by SELECT my_sanity_check_function() on monitored instance). See alerts.
- Supports single-running-instance via "--single" command line argument
- Supports strict sql_mode, including ONLY_FULL_GROUP_BY, overcoming bug #69310.
- Supports sending of pending email HTML report
- Better re-deployment process
- Better recognizing of SIGNED/UNSIGNED values
- Some other improvements in charting, etc.
mycheckpoint is released under the BSD license.
Downloads are available from the project's page.