{"id":596,"date":"2009-02-25T13:55:45","date_gmt":"2009-02-25T11:55:45","guid":{"rendered":"http:\/\/code.openark.org\/blog\/?p=596"},"modified":"2009-03-13T20:33:53","modified_gmt":"2009-03-13T18:33:53","slug":"announcing-openark-kit","status":"publish","type":"post","link":"https:\/\/code.openark.org\/blog\/mysql\/announcing-openark-kit","title":{"rendered":"Announcing openark kit"},"content":{"rendered":"<p>It is my great pleasure to announce the availability of the <a title=\"openark kit project home page\" href=\"http:\/\/code.openark.org\/forge\/openark-kit\">openark kit<\/a>, a set of lightweight utilities for MySQL, which eases every day tasks.<\/p>\n<p>The available tools are:<\/p>\n<ul>\n<li><a title=\"oak-apply-ri\" href=\"http:\/\/code.openark.org\/forge\/openark-kit\/oak-apply-ri\">oak-apply-ri<\/a>: apply referential integrity on two columns with parent-child  relationship.<\/li>\n<li><a title=\"oak-block-account\" href=\"http:\/\/code.openark.org\/forge\/openark-kit\/oak-block-account\">oak-block-account<\/a>: block or release MySQL users accounts, disabling them or enabling them to login.<\/li>\n<li><a title=\"oak-kill-slow-queries\" href=\"http:\/\/code.openark.org\/forge\/openark-kit\/oak-kill-slow-queries\">oak-kill-slow-queries<\/a>: terminate long running queries.<\/li>\n<li><a title=\"oak-modify-charset\" href=\"http:\/\/code.openark.org\/forge\/openark-kit\/oak-modify-charset\">oak-modify-charset<\/a>: change the character set (and collation) of a textual column.<\/li>\n<li><a title=\"oak-purge-master-logs\" href=\"http:\/\/code.openark.org\/forge\/openark-kit\/oak-purge-master-logs\">oak-purge-master-logs<\/a>: purge master logs, depending on the state of replicating slaves.<\/li>\n<li><a title=\"oak-security-audit\" href=\"http:\/\/code.openark.org\/forge\/openark-kit\/oak-security-audit\">oak-security-audit<\/a>: audit accounts, passwords, privileges and other security settings.<\/li>\n<li><a title=\"oak-show-limits\" href=\"http:\/\/code.openark.org\/forge\/openark-kit\/oak-show-limits\">oak-show-limits<\/a>: show AUTO_INCREMENT \u201cfree space\u201d.<\/li>\n<li><a title=\"oak-show-replication-status\" href=\"http:\/\/code.openark.org\/forge\/openark-kit\/oak-show-replication-status\">oak-show-replication-status<\/a>: show how far behind are replicating slaves on a given master.<\/li>\n<\/ul>\n<p><!--more-->All tools are written in Python, and require Python 2.3 or newer, and the python-mysqldb driver.<\/p>\n<p>The project is hosted in <a title=\"openark kit Google Code page\" href=\"http:\/\/code.google.com\/p\/openarkkit\/\">Google Code<\/a>, where you can find downloads, issue tracking etc. Community feedback is requested and welcome. Please use the &#8216;Issues&#8217; mechanism to report bugs.<\/p>\n<p>The openark kit is released under the <a href=\"http:\/\/www.opensource.org\/licenses\/bsd-license.php\">BSD license<\/a>.<\/p>\n<p>All utilities have been put to work on production, yet all are still being developed, and still more are being created, as new ideas and needs emerge. I have been using custom made scripts for handling DB issues for years, and finally have decided to formalize them and to support them as an open source project. I do hope you try them out.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>It is my great pleasure to announce the availability of the openark kit, a set of lightweight utilities for MySQL, which eases every day tasks. The available tools are: oak-apply-ri: apply referential integrity on two columns with parent-child relationship. oak-block-account: block or release MySQL users accounts, disabling them or enabling them to login. oak-kill-slow-queries: terminate [&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":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"enabled":false},"version":2}},"categories":[5],"tags":[34,31],"class_list":["post-596","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-openark-kit","tag-python"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2bZZp-9C","_links":{"self":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/596","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=596"}],"version-history":[{"count":14,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/596\/revisions"}],"predecessor-version":[{"id":663,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/596\/revisions\/663"}],"wp:attachment":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/media?parent=596"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/categories?post=596"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/tags?post=596"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}