{"id":6353,"date":"2013-05-23T14:21:52","date_gmt":"2013-05-23T12:21:52","guid":{"rendered":"http:\/\/code.openark.org\/blog\/?p=6353"},"modified":"2013-05-23T14:22:48","modified_gmt":"2013-05-23T12:22:48","slug":"mycheckpoint-revision-released","status":"publish","type":"post","link":"https:\/\/code.openark.org\/blog\/mysql\/mycheckpoint-revision-released","title":{"rendered":"mycheckpoint revision 231 released"},"content":{"rendered":"<p>A <a href=\"http:\/\/code.google.com\/p\/mycheckpoint\/\">new release<\/a> for <strong><a href=\"http:\/\/code.openark.org\/forge\/mycheckpoint\">mycheckpoint<\/a><\/strong>: lightweight, SQL oriented MySQL monitoring solution.<\/p>\n<p>If you&#8217;re unfamiliar with <em>mycheckpoint<\/em>, well, the one minute sales pitch is: it&#8217;s a free and open source monitoring tool for MySQL, which is extremely easy to install and execute, and which includes <a href=\"http:\/\/code.openark.org\/forge\/mycheckpoint\/documentation\/custom-monitoring\">custom queries<\/a>, <a href=\"http:\/\/code.openark.org\/forge\/mycheckpoint\/documentation\/alerts\">alerts<\/a> (via <a href=\"http:\/\/code.openark.org\/forge\/mycheckpoint\/documentation\/emails\">emails<\/a>), and out of the box <a href=\"http:\/\/code.openark.org\/forge\/mycheckpoint\/documentation\/http-web-server\">HTTP server<\/a> and <a href=\"http:\/\/mycheckpoint.googlecode.com\/svn\/trunk\/doc\/html\/sample\/http\/mcp_sql00\/sv_report_html_brief\">charting<\/a>.<\/p>\n<p>This is mostly a maintenance release, with some long-time requested features, and of course solved bugs. Here are a few highlights:<\/p>\n<ul>\n<li>Supports MariaDB and MySQL 5.6 (issues with new variables, space padded variables, text-valued variables)<\/li>\n<li>Supports alerts via function invocation on monitored host (so not only checking alerts via aggregated data like <strong>&#8216;Seconds_behind_master&#8217;<\/strong> but also by <strong>SELECT my_sanity_check_function()<\/strong> on monitored instance). See <a href=\"http:\/\/code.openark.org\/forge\/mycheckpoint\/documentation\/alerts\">alerts.<\/a><\/li>\n<li>Supports single-running-instance via <strong>&#8220;&#8211;single&#8221;<\/strong> command line argument<\/li>\n<li>Supports strict <strong>sql_mode<\/strong>, including <strong>ONLY_FULL_GROUP_BY<\/strong>, overcoming <a href=\"http:\/\/bugs.mysql.com\/bug.php?id=69310\">bug #69310<\/a>.<strong><br \/>\n<\/strong><\/li>\n<li>Supports sending of pending email HTML report<\/li>\n<li>Better re-deployment process<\/li>\n<li>Better recognizing of SIGNED\/UNSIGNED values<\/li>\n<li>Some other improvements in charting, etc.<\/li>\n<\/ul>\n<p><em>mycheckpoint<\/em> is released under the BSD license.<\/p>\n<p><a href=\"http:\/\/code.google.com\/p\/mycheckpoint\/\">Downloads are available<\/a> from the project&#8217;s page.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A new release for mycheckpoint: lightweight, SQL oriented MySQL monitoring solution. If you&#8217;re unfamiliar with mycheckpoint, well, the one minute sales pitch is: it&#8217;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 [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"enabled":false},"version":2}},"categories":[5],"tags":[120,46,49,57],"class_list":["post-6353","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-development","tag-monitoring","tag-mycheckpoint","tag-open-source"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2bZZp-1Et","_links":{"self":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/6353","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/comments?post=6353"}],"version-history":[{"count":12,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/6353\/revisions"}],"predecessor-version":[{"id":6365,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/6353\/revisions\/6365"}],"wp:attachment":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/media?parent=6353"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/categories?post=6353"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/tags?post=6353"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}