{"id":146,"date":"2017-12-13T00:32:05","date_gmt":"2017-12-12T23:32:05","guid":{"rendered":"http:\/\/188.166.119.205\/?page_id=146"},"modified":"2026-11-10T09:55:08","modified_gmt":"2026-11-10T08:55:08","slug":"projects","status":"publish","type":"page","link":"https:\/\/banyek.net\/?page_id=146","title":{"rendered":"Projects"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/mirachess.app\"><strong>MiraChess.app<\/strong><\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Analysing your chess games. It&#8217;s still in development.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/github.com\/banyek\/ZXCode\" data-type=\"link\" data-id=\"https:\/\/github.com\/banyek\/ZXCode\"><strong>ZXCode<\/strong><\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Visual Studio Code plugin for ZX Spectrum BASIC development<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><a href=\"https:\/\/github.com\/banyek\/mybckchk\">MySQL backend checker<\/a><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">MySQL backend checker. This tool is designed to run queries against a MySQL database and based on their results, report HTTP\/200 or HTTP\/500 which could be monitored from a HAProxy instance and route traffic to the host which is &#8216;available&#8217; in a given time.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><a href=\"https:\/\/github.com\/banyek\/mambo\">MySQL statsd sender<\/a><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">MySQL -&gt; statsd proxy. The tool run queries against the database and send their results to a&nbsp; statsd server.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><a href=\"https:\/\/github.com\/banyek\/binlogstreamer\">MySQL binlog streamer utility<\/a><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">This tool runs &#8216;mysqlbinlog&#8217; utility to stream binlogs from a remote MySQL server to a local directory &#8211; and if configured that way &#8211; handles the expiration of those logs. It is aware to find the last log file which is not completely synced, and start streaming from that file.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><a href=\"https:\/\/github.com\/banyek\/Utilities\">Utilities<\/a><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">A bunch of bulk stored&nbsp;utilites which are not interesting enough to put them into separate repositories.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>monitor_space<\/strong> &#8211; this utility is able to keep track of your database table size changes. It reads data from file system, not from information_schema, so you can&#8217;t use it on RDS. (PR&#8217;s accepted.) <a href=\"http:\/\/188.166.119.205\/2013\/07\/16\/keeping-track-of-database-table-size-changes-in-mysql\/\">I posted about this earlier<\/a>.<\/li>\n<\/ul>\n\n\n\n<div class=\"file-navigation js-zeroclipboard-container\">\n<ul>\n<li class=\"breadcrumb js-zeroclipboard-target\"><strong class=\"final-path\">binlog_extractor.awk <\/strong>&#8211; when you use GTID replication, and you want to create a point-in-time recovery from binlogs. Knowing the last GTID executed, this help which position to load.<\/li>\n<\/ul>\n<div>\n<div class=\"file-navigation js-zeroclipboard-container\">\n<ul>\n<li class=\"breadcrumb js-zeroclipboard-target\"><strong class=\"final-path\">check_mysql_connections.sh <\/strong>&#8211; this is nothing actually. You can put it to your .profile as a function and you can spare writing a few characters every time you want to check which servers connected to MySQL &#8211; regarding to netstat<\/li>\n<li>\n<div class=\"file-navigation js-zeroclipboard-container\">\n<div class=\"breadcrumb js-zeroclipboard-target\"><strong class=\"final-path\">checkconn.pl<\/strong> &#8211; helps to check how much connections you have on a server, and you can break them down by server, by database or by user.<\/div>\n<\/div>\n<div><\/div>\n<\/li>\n<li>\n<div class=\"file-navigation js-zeroclipboard-container\">\n<div class=\"breadcrumb js-zeroclipboard-target\"><strong class=\"final-path\">checkfrag.pl<\/strong> &#8211; with this you can check how fragmented your tables in mysql. This checks the file size on disk &#8211; sorry, no RDS &#8211; and then in the data dictionary. After that gives you a list of the tables, and hints you which tables should be rebuilt to free up space. The tool is not precise, but hints good.<\/div>\n<\/div>\n<div><\/div>\n<\/li>\n<li>\n<div class=\"file-navigation js-zeroclipboard-container\">\n<div class=\"breadcrumb js-zeroclipboard-target\"><strong class=\"final-path\">rds_node_selector.sh<\/strong> &#8211; needs dialog, and awscli configured. Queries AWS API to get your RDS server lists, and provides a neat interface to connect to them.<\/div>\n<div><\/div>\n<\/div>\n<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>MiraChess.app Analysing your chess games. It&#8217;s still in development. ZXCode Visual Studio Code plugin for ZX Spectrum BASIC development MySQL backend checker MySQL backend checker. This tool is designed to run queries against a MySQL database and based on their results, report HTTP\/200 or HTTP\/500 which could be monitored from a HAProxy instance and route [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-146","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/banyek.net\/index.php?rest_route=\/wp\/v2\/pages\/146","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/banyek.net\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/banyek.net\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/banyek.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/banyek.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=146"}],"version-history":[{"count":2,"href":"https:\/\/banyek.net\/index.php?rest_route=\/wp\/v2\/pages\/146\/revisions"}],"predecessor-version":[{"id":470,"href":"https:\/\/banyek.net\/index.php?rest_route=\/wp\/v2\/pages\/146\/revisions\/470"}],"wp:attachment":[{"href":"https:\/\/banyek.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=146"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}